How to apply paging to a dataset?

Question

How can I apply paging to a dataset? I have a method in which I dynamically build a table from a dataset. Querying the database from which I am getting my dataset is not a problem, but datarows from the dataset are repeating slowly.

To improve performance when loading a page containing many datarows, I want to use the paging ability.

A feature that would be good for the user is the ability of the user to set the page size (the number of lines for each page).

Answer 1

DataTable, AsEnumerable(). IEnumerable. LINQ.Skip() .Take().

IEnumerable<DataRow> MyDataPage = MyDataTable.AsEnumerable().Skip(100).Take(10);

101 110 MyDataTable, IEnumerable, , . , DataTable, CopyToDataTable(), :

DataTable NewDT = MyDataPage.CopyToDataTable();

Answer 2

GridView, : http://msdn.microsoft.com/en-us/library/5aw1xfh3%28v=VS.80%29.aspx

Answer 3

Linq.

ROW_NUMBER() SQL Server 2005