Answer / jeyaram thangaponnan

DataSet.Tables[0].Rows.Count will give the number of rows
in that table

Answer / vaidyanathan r.

int count = 0
foreach(DataTable CurrTable in DataSet1.Tables)
Count += currTable.Rows.Count;

Answer / eduardo belmonte

Regarding answer # 3 : It is correct.

Regarding answer # 2 : It is not correct, remember a
dataset contains datatables, and those datatables each can
have its own amount of datarows.

So to know "all" datarows in a dataset you have to add how
many rows "each" of its component datatables may have.

Answer / jagadish

DS.Tables["tabname"].Rows.Count;

we can get count of the records.

Answer / pushpendra singh

DataSet.Tables[0].rows.count returns total rows in table.

Answer / guest

foreach(DataTable thisTable in myDataSet.Tables){
// For each row, print the values of each column.
foreach(DataRow myRow in thisTable.Rows)}

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

0 Answers  

Which is faster ado.net or linq?

0 Answers  

Difference between datareader and dataset?

26 Answers   Microsoft, Noel Infotech, Satyam, Value Labs,

How to sort the data in Datatable

2 Answers   NetProphet,

What is fill method in ado.net?

0 Answers  

Define data access layer?

0 Answers  

How can you implement sub data grid in a master datagrid?

1 Answers  

What provider ADO.net use by default?

10 Answers   Accenture, TCS,

Define different execute methods of ADO.NET command object ?

0 Answers   NA,

How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

0 Answers  

How xml files and be read and write using dataset ?

1 Answers  

What is method to get XML and schema from Dataset?

2 Answers