My doubts in ADO

hi,

i have some question/doubts about ADO.NET

1. If i use dataset with paging (ex 1000 pages). how the records fetched from Database,it fetches all pages in single request or fetched according to the page the user cliked?

2. how to implement disconnected natures using dataset



v.r.mahendran

1. If you are using ASP.NETs built in paging it still passes all the records from the database to the ASP.NET application. You need to implement your own custom paging only to return the records you will display client-side from the database.

2. The dataAdapter you use to fill the dataset should handle the opening and closing of the database connection.

HTH

DJ