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 a column variable?

888

What is the difference between executenonquery () and executescalar ()?

895

What are good ado.net object to replace to ado recordset object.

1054

Define isolation?

924

How to creating a SqlCommand Object?

1083

How to find the given query is optimised one or not?

930

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

932

What is basic use of data view?

952

Describe briefly an ADO.NET Dataset ?

1021

What is ado.net object model?

932

What is the difference between a datareader and a dataset?

958

What are the different execute methods of Ado.Net?

989

differance between ADO vs ADO.Net?

1007

Explain the architecture of ado.net?

1027

What Is Difference Between Ado And Ado.net?

991