CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> .NET

 Grid Navigator when using Stored procedure

Print topic Send  topic

Author Message
rbaldwin

Posts: 156
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.

vb.net if you can. I have 1000+ plus rows being returned from a stored proc.
View profile  Send private message
wkempees


Posts: 1679
Posted: 06/05/2008, 11:59 AM

http://forums.codecharge.com/posts.php?post_id=97568
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: http://donate.consultair.eu
View profile  Send private message
rbaldwin

Posts: 156
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
mahindra21

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


Thanks....O:)
_________________
Software Developer
View profile  Send private message
rbaldwin

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

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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