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

How to find the count of records in a dataset?

Question Posted / vaidyanathan r.

Answer Posted / vaidyanathan r.

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

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between an ado.net dataset and an ado recordset?

1012

Explain the different row versions available in table?

993

What Is Difference Between Ado And Ado.net?

988

How we can provide data to ado.net?

988

What is difference in record set and dataset?

1001

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1103

What is isolation?

975

What is oledb driver?

890

How can I retrieve two tables of data at a time by using data reader?

946

What is the maximum pool size in ado.net connection string?

895

What is method to get XML and schema from Dataset? getXML() and get Schema ()

932

What is untyped dataset?

1047

How to pass multiple tables in datasets simultaneously?

1019

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

955

What is executenonquery ado.net?

896