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
What are dcl commands?
What is microsoft ado?
What is ado.net object model?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is the default provider in ado.net?
What is command class in ado.net?
Explain sqlconnection object?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What does executenonquery () method return?
What is meant by executenonquery?
Is bulk insert faster than insert?
What is the difference between statement and preparedstatement interface?
What is the difference between SqlCommand and SqlCommandBuilder?
What is ado.net objects?
Why do we serialize data?