rbaldwin
Posts: 172
|
Posted: 12/09/2013, 5:17 AM |
|
In an ASP.net (VB) grid where the datasource was modified in the beforeExecuteSelect, or the datasource was a stored proc the Navigator needed to be fixed by supplying values for
m_recordCount and _pagesCount in the afterExecuteSelect
Without InMotion this is what i did:
in the AfterExecuteSelect event for the grid (Not the before event.)
include code to set values for "m_recordCount" and for "_pagesCount"
For "m_recordCount", You will need to query your database for a count(*)
in my case i modified my procedure to just return the count if one of the proc parms had a value of 1 else it returned my result set.
for "_pagesCount" i think this provides a correct value.
_pagesCount = System.Math.Round(m_recordCount / RecordsPerPage + .5)
What is the InMotion equivalent?
thanks in advance.
|
|
|
|