Implement custom paging in an asp.net gridview without using datasource controls - Part 54

[@Csharp-video-tutorialsBlogspot]

Hi Harika, yes the number of records per page can be controlled using dropdownlist. But what do you mean by saying controlling the number of pages using a dropdownlist. The number of pages in a gridview control is determined by total number of records in the database table and the page size. Let's say I have 100 records in a database table, and if I select 5 as the page size from dropdownlist, then there should be 20 pages in the gridview control.

[@harikaaakutota7776]

thanks for ur immediate response...pls include sorting as well without using datasource controls....i mean sorting and paging without datasource controls...is it possible to use pager Template field and Gridview_paging event handler method....i have gone through properties,events of gridview....ie y i am asking these concepts....ur teaching is excellent.....i have watched gridview part 55....it is simply superb....no one can reach u.....i am waiting for this video....for the past few days...

[@Csharp-video-tutorialsBlogspot]

Hi Harika, I now understand what you mean. Sorry, I didn't get it the first time. Will record a video on this and upload as soon as I can.

[@amritgopali3298]

Thank you, Venkat.

[@gunnar560]

Thanks Venkat, very useful videos.

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. Really glad you found the videos useful. Dot Net & SQL playlists, which could be useful to you kzbin.infoplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. kzbin.info/www/bejne/r2ibYYCtnb5qZtU If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. kzbin.info If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat

[@harikaaakutota7776]

pls record a video using 2 dropdownlists one for pagerecords and the other for pages using pager template field and gridview_paging method .....from bottom of my heart , i really thank u....

[@Ibrahimkhan-pr1tj]

sir you are the best ...

[@harikaaakutota7776]

thanks a lot for posting sorting and paging video.....

[@harikaaakutota7776]

hi venkat, as u said if i select 5 as the page size from dropdownlistpagerecords then numbers from 1 to 20 should be displayed in dropdownlistpages.from this dropdownlistpages i can select which ever page i want to display....ie i can select for ex 10th page or 15th page... suppose if i select 10 as the pagesize from dropdownlistpagerecords , then numbers from 1 to 10 should be displayed in dropdownlistpages....

[@darnit006]

you save my life with this video can i syd pl0x

[@sumanhappy]

Hi Venkat, in linkbutton handler of the above example to know which control raised the event you used sender object. can that be done with the eventargs object

[@sapanashah3012]

Hello Venkat, Thanks for uploading these videos. I am a fresher ...these videos helps me lot. They are very easy to understand and implement. Now for custom paging if i have more than 5000 records in my db than these code doesn't sound working for me...as it goes only forward not backward. eg if i am on page 300 and if want to go back to page 200 than have to come all the way to record 1 and go from there which is not right design i guess. Please help uploading video which deals with big data and custom pagination.

[@harikaaakutota7776]

hi venkat, can v use dropdownlist to represent number of records per page and depending upon selected item in the dropdownlist , the number of pages should be displayed in another dropdown list ....i mean 2 dropdownlists one for number of records per page and the other dropdown list for number of pages....how to implement this...........in the begining v set page size in properties of gridview...

[@allisonpaiva8265]

Hi venkat, how will you pass the page index after edit /update actions in grid? When I'm trying to edit a row second page, gridview.pageindex is setting to 0, and the row in first page is setting to edit mode.. how can we get Current page index?

[@vaishnavidonade7486]

Thanks for this video but I'm getting here an error 'System.Data.SqlClient.SqlDataReader' has no constructors defined ...... Please tell me how to solve it!

[@kiranpedamkar]

sir how to jump on next text box on enter button is click by user

[@xaviqq5]

How can I do this in MVC 2, please help us men!

[@harikaaakutota7776]

sorry i said gridview_paging instead of gridview_sorting.....and one more doubt...could u explain gridview_rowdatabound and gridview_databound... pls, because this is common qtn asked in interview.

[@sumanhappy]

ok plz atleast let me know when to use object sender and when to use sys.Eventargs handler.