If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?

Answer Posted / vaidyanathan r.

DataRow[] dr = new DataRow[10];
for(int i = 10 to 19)
dr[i] = DataSet1.Tables[<TableIndex>].Rows[i];

DataRow array dr contains Records between 10 and 20.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the role of data provider in ado.net?

625


Does entity framework use ado.net?

593


What is executequery?

576


What is untyped dataset?

634


Define Execute Reader?

693






What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

871


What are the parameters that control most of connection pooling behaviors?

604


How can we load multiple tables in a dataset?

648


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

1724


What is ambient transaction?

589


What are the benefits of ADO.NET?

736


What is the role of clr?

621


How to copy the contents from one table to another table and how to delete the source table in ado.net?

616


Which control of the BindingNavigator returns the current position within the data source?

812


How to check if a datareader is closed or opened? IsClosed()

668