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


Please Help Members By Posting Answers For Below Questions

What is ado.net objects?

705


How to perform sorting on a table in ADO.NET?

762


What are the steps you will take to improve performance?

661


What are the different methods by which we can populate a dataset?

950


What is ole2 format?

680


What does ado stand for in ado.net?

703


What are the rules to implement connection pooling?

750


What is data adapter in ado.net with example?

705


Why ca not we use multiple inheritance and garbage collector paralelly in .net?

771


What are basic methods of dataadapter?

714


What is a data control clerk?

778


What do you know about ADO.NET's objects and methods?

729


What is the difference in an abstract class and an interface?

726


Which method is used to sort the data in ADO.Net?

1747


Describe briefly an ADO.NET Dataset ?

750