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
Give an example of a .net application which connects to microsoft access database using ado.net classes.
Do you use stored procedure in ado.net?
Which object is used to add relationship between two Datatables?
Is entity framework better than ado.net?
Can we do database operations without using any of the ado.net objects?
What is ado and rdo?
What is difference between datareader and dataadapter?
How can we add/remove row's in "datatable" object of "dataset"?
What is the usage of the dataset object in ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
Define table relations?
What is the use of adodc?
Define partial class?
What is ado.net object model?
Which database is the ado.net?