Dataset paging Internal concept

[mahivr]

hi,

i cant understand the internal archietecture of dataset paging, about how it handles Paging,. Can any send some article related to internal working concept of Dataset.

My main Doubt is:

if i navigate to another page in datagrid, it connects to DB or where it gets next page content?

[Nikhil Aggarwal]

The artical below shows an example of how to achieve paging in a datagrid by avoiding database calls each time the page is changed.
Click here to view this page
Note: This example uses a session variable to store the dataset object. Since the dataset of probably required only for the page and not for the entire session, using a session variable would not be advisable. Use a ViewState variable instead.

[Danial]

My main Doubt is:

if i navigate to another page in datagrid, it connects to DB or where it gets next page content?

Your assumtion is correct. Datagrid paging is not really proper pagin in a sense that, every time it will go to the database and fetch "All" data and only show n number you specified in Page Size. For most small application it is sufficient but for enterprise level you will have to do your custom paging using SQL Server and Stored Procedure. Do a search on google or 4guysfromrolla.com you will find examples.

Also like the previous poster mentioned, do not use session varable to store DataSet, that is very bad practice and should be avoided at all cost...