I created a stored procedure to handle paging and sorting. Linked a LinqToSql to it and bound my gridview from that. I use my Gridview.PageSize to determine how many results to pull from the table through my stored procedure. The issue is because of this a pager never gets created. I wrote another procedure to determine how many pages will be needed based on the page size and was trying to manually create the pager...but it was being a pain. Does anyone know how to effectively force a Gridview's pager? The prformance gains from using my stored procedure for this is great so I would like to keep that as is.
MichaelWClark
0
Junior Poster
Recommended Answers
Jump to PostHey Michael
visit below link..It has nice explaination about Paging with Storedprocedure..I believe it will help to you..
http://www.codeproject.com/KB/database/CustomPagingStoredProc.aspx
I created a stored procedure to handle paging and sorting. Linked a …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.