CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> ASP

 Change page count on grid navigator with SQL modified datasource

Print topic Send  topic

Author Message

Posts: 123
Posted: 07/23/2009, 12:28 AM

Hello all, i have a datagrid wich it's datasource.sql property is heavily modified on the beforeexecuteselect event, upon many conditions, and it does work fine BUT itīs navigator does not reflect the page numbers accordingly. e.g. the datasource on desingtime is a plain query, wich by default returns, letīs say, 3 pages; the grid then is forced to retreive only certain rows, letīs say 3 rows, or 1 page only, the navigator does not update the pagination correctly so, in the same event I am trying to reference the navigator to modify itīs datasource.sql property too, but no joy here; i am trying:
gridname.navigator.datasource.sql = sqlstring but I get an error that says variable not declared, why?

Is there a way to reference the navigator upon itīs grid.datasource? the event is fired and then we have grid.datasource as the sender, so I am thinking of something like

Dim ogrid

Set oGrid = Sender.PARENT -> do we have something alike? to then try
oGrid.Navigator.DataSource.SQL = SQLString

Any Ideas appreciated
Yes! I Can!!!
View profile  Send private message

Posts: 123
Posted: 07/23/2009, 12:43 AM

I was lost, it is the DataSource.CountSQL property wich has to be affected...

by the way I am wondering if I am asking too silly questions or is that oeveryone is just too busy to answer or what? I have posted at least 5 topics within the last month without a single comment on any of em... I am wondering too if it is just that ASP 3.0 is sooo death that everybody is moving to PHP... I am in the dilemma of learining PHP versos .NET and dont know where to move...
Yes! I Can!!!
View profile  Send private message

Posts: 1190
Posted: 09/16/2009, 3:17 PM

the question is no rellated to a specific program just a bit unclear
____________________________ (Free CMS,CRM Developed in CCS)
Affiliation Web Site Templates

Please do backup first
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright Đ 2003-2004 by  and YesSoftware, Inc.