Hi all,

Anyone know how to do paging in ADO.NET other that using DataGrid Web control (which has PageSize property).
The reason I try not to use DataGrid control because I want to get data through Web Service, and want to retrieve data in certain specific range of rows.

Thanks for any input.
Khoa Nguyen

Use the Overloaded DataAdapters Fill method.

Dim Da as New OleDBDataAdapter(SelectStatement, Connection)
Dim Ds as new DataSet()

Da.Fill(ds, 40, 10, "TABLE NAME")

Something like that.

Goodluck

Alan

Hi Alan,

Thanks for replying.
> Da.Fill(ds, 40, 10, "TABLE NAME")
Your example worked very well well. Can you help a little bit more:
I retrieve 3 tables, nested in each other like XML tree:

<Table1>
  <Table2>
    <Table3>
  </Table2>
</Table1>

using follwing compound SQL statements:
"SELECT ID1 FROM Table1; SELECT ID1, ID2 FROM Table2; SELECT ID2 FROM Table3;"

da.Fill(ds);
ds.Tables[0].TableName = "Table1";
ds.Tables[1].TableName = "Table2";
ds.Tables[2].TableName = "Table3";

ds.Relations.Add("R1", ds.Tables[0].Column[ID1], ds.Tables[1].Columns[ID1]).Nested = true;
ds.Relations.Add("R2", ds.Tables[1].Column[ID2], ds.Tables[2].Columns[ID2]).Nested = true;

so can I restrict the range of rows retrieve from Table1, no matter how many rows from nested tables Table2, Table3 ?

Many thanks.
Khoa Nguyen