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
35807 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

What is connection in ado.net?

950

Explain how do you connect to sql server database without using sqlclient?

1007

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1055

What is a control toolbox?

966

Compare Data Reader & Dataset in ado.net?

998

Define partial class?

960

What is difference between connected and disconnected architecture in ado.net?

1152

What are the Features of a dataset

1303

Give few examples of datareader that is used in different dataproviders.

977

What is the difference between dataset and datatable?

1003

Explain advantages of ado.net?

1047

What is difference between ado and other data object?

912

What providers does Ado.net uses?

1018

What is ole access?

946

What is ado recordset?

991