PGSQLDATASOURCE AUTOMATIC DATA PAGING PROBLEM

PGSQLDATASOURCE AUTOMATIC DATA PAGING PROBLEM

Postby 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:

ID="dsCatArtistas"
runat="server"
ConnectionString="<%$ ConnectionStrings:PgSqlConnection %>"
OldValuesParameterFormatString="Original_{0}"
ProviderName="<%$ ConnectionStrings:PgSqlConnection.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
JORGEMAL
 
Posts: 164
Joined: Thu 03 Jul 2008 23:55

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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
 
Posts: 164
Joined: Thu 03 Jul 2008 23:55

Postby 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
JORGEMAL
 
Posts: 164
Joined: Thu 03 Jul 2008 23:55

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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
 
Posts: 164
Joined: Thu 03 Jul 2008 23:55

Postby 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
JORGEMAL
 
Posts: 164
Joined: Thu 03 Jul 2008 23:55

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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
JORGEMAL
 
Posts: 164
Joined: Thu 03 Jul 2008 23:55

Postby 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
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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/postgresql/download.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
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for PostgreSQL