PGSQLDATASOURCE AUTOMATIC DATA PAGING PROBLEM

JORGEMAL · Post by **JORGEMAL** » Sun 14 Mar 2010 18:48

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

StanislavK · Post by **StanislavK** » Mon 15 Mar 2010 13:50

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.

JORGEMAL · Post by **JORGEMAL** » Mon 15 Mar 2010 14:32

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

JORGEMAL · Post by **JORGEMAL** » Thu 18 Mar 2010 16:12

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

StanislavK · Post by **StanislavK** » Fri 19 Mar 2010 10:11

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

JORGEMAL · Post by **JORGEMAL** » Fri 19 Mar 2010 14:51

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.

JORGEMAL · Post by **JORGEMAL** » Fri 19 Mar 2010 14:54

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

StanislavK · Post by **StanislavK** » Mon 22 Mar 2010 13:33

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.

JORGEMAL · Post by **JORGEMAL** » Mon 29 Mar 2010 01:49

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

StanislavK · Post by **StanislavK** » Mon 29 Mar 2010 12:04

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.

StanislavK · Post by **StanislavK** » Fri 21 May 2010 16:54

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