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?

521


What does ado stand for in ado.net?

456


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

1636


What are all the commands used with Data Adapter?

518


How to store data in memory?

506






What is data relation in ado.net?

517


Is datareader faster than datatable?

535


What is the DataTableCollection?

572


What is dao and ado?

480


What is ado code?

498


Which namespaces are used for data access?

621


Why is ADO.NET serialization slower than ADO ?

567


What is isolation?

565


What is ado control?

524


What are the types of databinding?

553