SqlDataAdapter sda = new SqlDataAdapter(sqlquery , con); DataSet d

If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Question Posted / raghwendra ji chaubey

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

Please Help Members By Posting Answers For Below Questions

What is different between sqlcommand object and command behavior object?

986

How to store data in memory?

892

What are the parameters that control most of connection pooling behaviors?

945

What is an ado connection?

919

How many major types of connection objects in ADO.NET?

991

What is the purpose of using adodb?

904

What are the pre-requisites for connection pooling?

958

What is sqlconnection and sqlcommand?

1004

Which object needs to be closed?

2195

What are three methods for displaying data in a syncfusion datagrid

1018

Which is better ole db or odbc?

857

What two types of data providers does ADO.NET supply? What determines which one you should use?

942

Explain the role of data provider in ado.net?

935

What are disadvantages of microsoft-provided data provider classes in ado.net?

964

What is shadow copy?

935