If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
- 14 Answers
- 33663 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
What are the drawbacks of using ado.net?
What is the role of the dataset object in ado.net?
What are all components of ADO.Net data provider?
What is ado circle?
Is ado.net an orm?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
How do you update a dataset in ado.net?
Describe the command object and its method.
Define table relations?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is basic use of data view?
What is executequery?
Do we use stored procedure in ADO.Net?
What is a control toolbox?
How do I delete a row from a DataTable?
