Interested to Buy Any Domain ? << Click Here >> for more details...
If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
- 14 Answers
- 35809 Views
- Ksb, I also Faced
- E-Mail Answers
Answer Posted / pra vesh hajela
SqlConnection conn = new
SqlConnection(AppConfiguration.ConnectionString);
SqlCommand cmd = new
SqlCommand("SelectCustomerInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//da.Fill(ds);
da.Fill(ds, 10, 10, "table");
return ds;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different methods available under the sqlcommand class to access the data?
Which object is used to add relationship between two Datatables?
What are the benefits of using ado.net?
How to check if the Dataset has records ?
What are disadvantages of microsoft-provided data provider classes in ado.net?
Can we do database operations without using any of the ado.net objects?
How to Read, Add, Update and Delete record in Entity Framework ?
How do I delete a row from a DataTable?
What is a serialized object?
What is openrowset?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Explain the difference between ado and ado.net?
What are two types of transaction supported by ado.net?
What is the difference between data reader and data adapter?
Which keyword is used to accept variable number of parameters?
