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
Explain why edit is not possible in repeater?
What do you know about ado.net's objects?
What is ole2 format?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What are the rules to implement connection pooling?
Explain what are acid properties?
Which method is used by command class to execute SQL statements that return single value?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
What is two way data binding android?
What connected data?
What does ado stand for in ado.net?
Compare Data Reader & Dataset in ado.net?
What is the difference between Datareader and Dataset?
Explain all the classes those are used for database connections between sql server and asp.net?