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 are dcl commands?

727


What is microsoft ado?

721


What is ado.net object model?

733


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

846


What is the default provider in ado.net?

715


What is command class in ado.net?

715


Explain sqlconnection object?

779


What is the default timeout specified for "sqlcommand.commandtimeout" property?

780


What does executenonquery () method return?

702


What is meant by executenonquery?

735


Is bulk insert faster than insert?

700


What is the difference between statement and preparedstatement interface?

784


What is the difference between SqlCommand and SqlCommandBuilder?

813


What is ado.net objects?

723


Why do we serialize data?

714