If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
- 14 Answers
- 33851 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 is the meaning of object pooling?
What are the 3 major types of connection objects in ado.net?
What are the pre-requisites for connection pooling?
What is data control techniques?
Which control of the BindingNavigator returns the current position within the data source?
What is ado recordset?
What are datareaders?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What is ado oledb and odbc?
Explain executenonquery?
Is it possible to load multiple tables in a Dataset?
What are the features of ado.net?
What is the role of the dataset object in ado.net?
Explain all the classes those are used for database connections between sql server and asp.net?
What are the benefits of using of ADO.NET in .NET 4.0?
