rbaldwin
Posts: 172
|
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.
|
|
|
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
|
|
|
rbaldwin
Posts: 172
|
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!
|
|
|
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....
_________________
Software Developer |
|
|
rbaldwin
Posts: 172
|
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.
|
|
|
|