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
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
What is the difference between ado.net and oledb?
Which is faster entity framework or ado.net?
Why do we use sqldataadapter?
What is ado.net in mvc?
What is row state?
What is two way data binding android?
What are the Data providers in ADO.Net?
What is ole in vb?
How to work with disconnected data - the dataset and sqldataadapter?
Explain the role of data provider in ado.net?
What are the key events of sqlconnection class?
Explain ado.net features? Benefits? Drawbacks?
What are the steps you will take to improve performance?
What connected data?