CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> .NET

 Grid Navigator when using Stored procedure

Print topic Send  topic

Author Message

Posts: 165
Posted: 06/05/2008, 10:47 AM

I know that the navigator on a grid does NOT work properly when the data source for the grid is a stored procedure.

Has anyone figured out how to either make it work or has anyone got a suggestion for manually adding a set of navigation links. if you can. I have 1000+ plus rows being returned from a stored proc.
View profile  Send private message

Posts: 1679
Posted: 06/05/2008, 11:59 AM
Double post
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me:
View profile  Send private message

Posts: 165
Posted: 06/05/2008, 1:04 PM

It was a double post but i'll provide the solution here as it's specific to .net

Include a standard navigator.

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)

anyway it's working!

View profile  Send private message

Posts: 5
Posted: 06/10/2008, 11:43 PM

hi , i am new in codecharge ,please give mw idea about this codecharge ,like we have pleanty of example here but, i want to know, can we develop our own customised website, with our own database and design.. if possible please reply me...asap

Software Developer
View profile  Send private message

Posts: 165
Posted: 06/11/2008, 6:49 AM

Yes, that is exactly what CodeCharge Studio is built to do.

Your own web application from your database.

For simple application codecharge does 100% for more complicated application even Enterprise class codecharge will do the first 80% you will then have to custom code the rest.
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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login

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