If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
Answer Posted / raghwendra ji chaubey
SqlDataAdapter sda = new SqlDataAdapter(sqlquery , con);
DataSet ds = new DataSet();
sda.Fill(ds);
sda.Fill(ds, 3, 2, "SrcTables");
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Is bulk insert faster than insert?
What is dataadapter in ado.net?
What are the methods of XML dataset object?
How to add a javaScript function in a datagrid?
What does ado stand for?
Is entity framework better than ado.net?
What are the ado.net connection pooling parameters?
What is the provider being used to access oracle database?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
Explain executenonquery?
How do you update a dataset in ado.net?
What are the difference between readonly vs. Const?
What are the connected and disconnected modes in ado.net?