csierra
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!!! |
|
|
csierra
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!!! |
|
|
Oper
Posts: 1195
|
Posted: 09/16/2009, 3:17 PM |
|
the question is no rellated to a specific program just a bit unclear
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|