CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP.NET - InMotion Framework

 How to correct navigator when data source is proc or is modified

Print topic Send  topic

Author Message

Posts: 172
Posted: 12/09/2013, 5:17 AM

In an (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.
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

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

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