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
What provider ado.net use by default? Explain the role of data provider in ado.net?
What are the different execute methods of Ado.Net?
What is ole in excel?
What do you know about ADO.NET's objects and methods?
What is row state?
What are the advantages of using datalist?
How to add a javaScript function in a datagrid?
What are the steps to connect to a database?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Which object needs to be closed?
What is ado.net and its features?
How to perform sorting on a table in ADO.NET?
How does entity framework work?
What is dataset and datatable in ado.net?
What is the significance of CommandBehavior.CloseConnection ?