DataSet ds = new DataSet(); ds.Load(cmd.ExecuteReader(), LoadOpti

If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Question Posted / muthu kumar

14 Answers
35240 Views
Ksb, I also Faced
E-Mail Answers

Answer Posted / muthu kumar

DataSet ds = new DataSet();
ds.Load(cmd.ExecuteReader(),
LoadOption.OverwriteChanges, "sample");

DataRow[] dr = ds.Tables[0].Select("id>1 and id<10");

for (int i = 0; i < dr.Length; i++)
{
Response.Write(dr[i][0].ToString()+"<br>");

}

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain how to call the sql commands asynchronously in ado.net version 2.0?

884

What are the ado.net objects?

889

How can I retrieve two tables of data at a time by using data reader?

932

What are the advantages of using datalist?

961

How to pass values into a datatable?

1056

Which is faster sqldataadapter and sqldatareader?

871

What is partial class?

922

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

1088

What is the difference between data grid and data repeater?

1003

What are good ado.net object to replace to ado recordset object.

1030

Can datareader hold data from multiple tables?

1114

Explain the difference between data reader and data set?

870

What is the significance of CommandBehavior.CloseConnection ?

1094

Which is faster entity framework or ado.net?

879

Describe briefly an ADO.NET Dataset ?

1003