If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
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 is method to get XML and schema from Dataset? getXML() and get Schema ()
What are the several execute methods of ado.net?
What are all components of ADO.Net data provider?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is the provider being used to access oracle database?
Which provider is used to connect ms access, oracle, etc…?
What is the default Timeout for SqlCommand.CommandTimeout property?
Is bulk insert faster than insert?
Explain executenonquery?
What is acid in ado.net?
What is ado.net in vb net?
What is sqlconnection and sqlcommand?
What is data relation?
What are the data providers used in ado.net