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 |
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()
what is a dataview?why is it used for?
What are the two fundamental objects in ADO.NET?
What is the difference between connected environment and a disconnected environment?
Sequence to connect and retrieve data from database useig dataset ?
What are all components of ADO.Net data provider?
How do we invoke queries from the application ?
How to add an aggregate column?
What is adodb dll?
what is type dataset?
once data is fetched into dataset connection gets closed. but in datareader connection is always maintained...then why datareader is fast and mainly recommended ?
describe the dataset object in ado.net.