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
- 35218 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
Define isolation?
What are the data providers used in ado.net
What are ado.net objects?
What is command class in ado.net?
What is the difference in record set and dataset?
What are the parameters that control most of connection pooling behaviours?
What is dataset object? Explain the various objects in dataset.
What are the ado.net connection pooling parameters?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
How do you connect to sql server database without using sqlclient?
What is an example of ordinal data?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is ole used for?
What is ole data type?
Which is the best method to get two values from the database?
