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 isolation?
What is the difference between Optimistic and Pessimistic locking?
Explain the difference between data reader and data adapter?
What are the key events of sqlconnection class?
What is data adapter in ado.net with example?
What are the namespaces used in ADO.Net to connect to a database?
Is bulk insert faster than insert?
How to aggregating data across related tables?
How can I retrieve two tables of data at a time by using data reader?
Name which operations can you not perform on an ado.net dataset?
What does executequery return?
How to add a javaScript function in a datagrid?
What are the uses of Stored Procedure?
Explain how can we load multiple tables in to dataset?
What is the difference between data grid and data repeater?