can we have multiple datatables in a datareader ?
Answer Posted / eduardo belmonte
Some people get confused.
A datareader can not have any amount of datatables.
Not even one of them.
Datatables exist by themmselves or inside a dataset, but
they are not generated nor filled by a datareader.
A datareader generates "only datarows", it doesn't generate
datatables. Each one of the datarows comply with a
structure as defined by the SELECT sql statement.
That SELECT statement may have columns that belong to one
or more "tables in the database". By example using a JOIN
or something similar. But listen well I said "tables" not
"datatables".
OK my friends?
| Is This Answer Correct ? | 12 Yes | 8 No |
Post New Answer View All Answers
What are the data access namespaces in .NET?
Explain ODP.net
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the role of the dataset object in ado.net?
What is the meaning of executenonquery?
How to check if the Dataset has records ?
Which is the feature of ado.net?
How to check if a datareader is closed or opened? IsClosed()
What are the uses of Stored Procedure?
What is ole db query?
Does executenonquery return a value?
What is bubbled event?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What are all features of ADO.Net?
What is the difference between Dataset. clone and Dataset.copy?