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 is bubbled event?
Is bulk insert faster than insert?
What are the rules to implement connection pooling?
How do you update a dataset in ado.net and how do you update database through dataset?
What are the different execute methods of Ado.Net?
What two types of data providers does ADO.NET supply? What determines which one you should use?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the drawbacks of using ado.net?
What is datatable in ado.net?
What does executequery return?
Can you explain how to enable and disable connection pooling?
Define connection string?
Why is ADO.NET serialization slower than ADO ?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is basic use of data view?