Interested to Buy Any Domain ? << Click Here >> for more details...
can we have multiple datatables in a datareader ?
- 18 Answers
- 39143 Views
- Fulcrum Logic, Infosys, Kale Consultants, Ness Technologies, I also Faced
- E-Mail Answers
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
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Does ado.net use odbc?
What is the difference between DataReader and DataSet in ADO.NET?
How to identify the updated rows in a dataset?
What is the role of data provider in ado.net?
Does dapper use ado.net?
What are dataproviders?
Which property is used to check whether a DataReader is closed or opened?
Compare Data Reader & Dataset in ado.net?
Explain the differences between oledb sql server, oledbdotnet provider?
What are the difference between readonly vs. Const?
What is dbcontext and dbset in entity framework?
What is difference between dataset and datatable?
Explain the different row versions available in table?
What is difference between ado and other data object?
