CodeCharge Studio
search Register Login  

Visual Web Reporting

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

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
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.
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 http://support.yessoftware.com.

MS Access to Web

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

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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