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

Which namespaces are used for data access?

717


How to copy the contents from one table to another table and how to delete the source table in ado.net?

616


Is entity framework better than ado.net?

574


Define data access layer?

598


Define atomicity?

678






What is the difference between DataReader and DataSet in ADO.NET?

667


What is ole word?

630


What are the namespaces used in ado.net for data access?

566


What are datareaders?

598


What is an ado connection?

609


What is ado circle?

746


Define different execute methods of ADO.NET command object ?

629


Explain how do you connect to sql server database without using sqlclient?

570


Which is faster ado.net or linq?

616


What does ado stand for in ado.net?

530