DataRow[] dr = new DataRow[10]; for(int i = 10 to 19) dr[i] = DataSet1

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

Question Posted / vaidyanathan r.

14 Answers
35348 Views
Ksb, I also Faced
E-Mail Answers

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

Define different execute methods of ADO.NET command object ?

1024

What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

981

What is ole db and odbc?

870

What is difference between executequery and executeupdate?

934

What is the role of clr?

904

Describe briefly an ADO.NET Dataset ?

1021

What is disconnected scenario in entity framework?

1071

What is the difference between an ADO.NET Dataset and an ADO Recordset?

1006

What is ambient transaction?

899

What are all the different methods under sqlcommand?

943

What is ado control?

916

What is linq and entity framework?

950

What is defaultview in datatable?

998

What is the difference in record set and dataset?

994

What is the default timeout specified for "sqlcommand.commandtimeout" property?

993