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
Which namespaces are used for data access?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
Is entity framework better than ado.net?
Define data access layer?
Define atomicity?
What is the difference between DataReader and DataSet in ADO.NET?
What is ole word?
What are the namespaces used in ado.net for data access?
What are datareaders?
What is an ado connection?
What is ado circle?
Define different execute methods of ADO.NET command object ?
Explain how do you connect to sql server database without using sqlclient?
Which is faster ado.net or linq?
What does ado stand for in ado.net?