Devart Forums

I have a web form with a grid to show information from a DB. I set a datasource in such a web form without a select statement because it is set at run time depending on several choices I made in my web form.
The select statement is built as follows:

String strQuery = "";
strQuery += "SELECT fld1, fld2, fld3,....,fldn "
strQuery += "FROM tbl1 "
strQuery += "INNER JOIN ........."
strQuery += "INNER JOIN ........."
strQuery += "WHERE conditions "
strQuery += "ORDER BY order criteria"

dsCatAlbumes.SelectCommandType = SqlDataSourceCommandType.Text;

dsCatAlbumes.DataPagingMode = Devart.Common.Web.DataPagingMode.Auto;
dsCatArtistas.SelectCommand = strQuery;

grdCatArtistas.DataSource = Session["dsCatArtistas"];
grdCatArtistas.DataBind();

The pgSqlDataSource is defined in my aspx form as follows:

"
OldValuesParameterFormatString="Original_{0}"
ProviderName="" >


Nothing is shown in the grid; nevertheless, if I remove the DataPaginMode line then it works.

What am I doing wrong?

I am using the following versions:
PostgreSQL - V8.3.1
dotConnect for PostgreSQL - V4.0.12.0

I work with Devexpress - V9.3.3.0 controls, I wonder if this could be a problem.

Respectfully,
Jorge Maldonado

We've reproduced the problem with the DevExpress grid, whereas with usual DataGrid the Auto paging mode worked properly. We will investigate the situation and inform you about the results.

Please be aware that I am not using the latest version of dotConnect for PostgreSQL (4.0), nevertheless, I just renewed my suscription because it is my intention to start upgrading soon.

With respect,
Jorge Maldonado

StanislavK wrote:We've reproduced the problem with the DevExpress grid, whereas with usual DataGrid the Auto paging mode worked properly. We will investigate the situation and inform you about the results.

Any news about this issue?

Regards,
Jorge Maldonado

We have fixed the problem. The fix will be available in the nearest build which we plan to release in about a week.

StanislavK wrote:We have fixed the problem. The fix will be available in the nearest build which we plan to release in about a week.

GREAT NEWS !!!!
I WILL BE AWARE OF IT.

THANK YOU.

StanislavK wrote:We have fixed the problem. The fix will be available in the nearest build which we plan to release in about a week.

One last question.
Does the DataPagingMode works only with controls that support page processing like gridviews or can it be used also with other controls like comboboxes and listboxes?

Regards,
Jorge Maldonado

The DataPagingMode property specifies the way PgSqlDataSource generates a data table. The way this data table is processed by a particular control depends on the control implementation. If some custom list box or combo box components support paginal data access, then it should be possible to use DataPagingMode for these components.

StanislavK wrote:We have fixed the problem. The fix will be available in the nearest build which we plan to release in about a week.

Is this nearest release 4.90.102 ?

Regards,
Jorge Maldonado

The 4.90.102 Beta build of dotConnect for PostgreSQL was released on March 4. The next build will be published in several days, we will inform you when it is released.

We have released the new 4.95.140 build of dotConnect for PostgreSQL. It can be downloaded from
http://www.devart.com/dotconnect/postgr ... nload.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

The new build contains the fix for problem with filling DevExpress ASPxGridView in Auto DataPagingMode of PgSqlDataSource. For more information on fixes and improvements available in version 4.95.140, please see
http://www.devart.com/forums/viewtopic.php?t=18032