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 is ado.net objects?
How to perform sorting on a table in ADO.NET?
What are the steps you will take to improve performance?
What are the different methods by which we can populate a dataset?
What is ole2 format?
What does ado stand for in ado.net?
What are the rules to implement connection pooling?
What is data adapter in ado.net with example?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What are basic methods of dataadapter?
What is a data control clerk?
What do you know about ADO.NET's objects and methods?
What is the difference in an abstract class and an interface?
Which method is used to sort the data in ADO.Net?
Describe briefly an ADO.NET Dataset ?