How to find the count of records in a dataset?
Answers were Sorted based on User's Feedback
Answer / jeyaram thangaponnan
DataSet.Tables[0].Rows.Count will give the number of rows
in that table
| Is This Answer Correct ? | 30 Yes | 0 No |
Answer / vaidyanathan r.
int count = 0
foreach(DataTable CurrTable in DataSet1.Tables)
Count += currTable.Rows.Count;
| Is This Answer Correct ? | 9 Yes | 1 No |
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.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / jagadish
DS.Tables["tabname"].Rows.Count;
we can get count of the records.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / pushpendra singh
DataSet.Tables[0].rows.count returns total rows in table.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
foreach(DataTable thisTable in myDataSet.Tables){
// For each row, print the values of each column.
foreach(DataRow myRow in thisTable.Rows)}
| Is This Answer Correct ? | 3 Yes | 8 No |
Difference between ADO and ADO.Net
What are the namespaces used in ado.net for data access?
Which architecture does Datasets follow?
What do you know about ado.net's methods?
How to bind the controls(best practice) comboboxes to the data in the dataset?
Explain ado.net features?
Explain what are the steps to connect to a database?
What are the different layers of ado.net?
Explain the two fundamental objects in ado.net?
Explain how can we load multiple tables in to dataset?
How to create dynamic gridview?
Explain why edit is not possible in repeater?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)