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

Give an example that shows how to execute a stored procedure in ado.net?

1112

What is Data view?

1149

What is the default provider in ado.net?

1021

Which database is the ado.net sql connection object designed for?

1085

Explain how to call the sql commands asynchronously in ado.net version 2.0?

977

How to maintain the relation between two tables in ADO.NET?

1058

What are the advantages using ado.net?

1087

What is the difference between data reader and data adapter?

1072

What is data adapter in ado.net with example?

1103

What is acid in ado.net?

1103

What is the use of sqldatareader class?

1052

What is the difference between statement and preparedstatement interface?

1052

What providers does Ado.net uses?

1062

What is the difference between Dataset. clone and Dataset.copy?

1093

how we can fire event in databound coulm in datagfrid withot using button?

1023