Interested to Buy Any Domain ? << Click Here >> for more details...
can we have multiple datatables in a datareader ?
- 18 Answers
- 38451 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
Compare Data Reader & Dataset in ado.net?
How can I retrieve two tables of data at a time by using data reader?
What is sql command in ado net?
What is maximum pool size in ado.net connection string?
Which is the feature of ado.net?
What are the differences between OLEDB and SQLClient Providers?
What are the ado.net components?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Explain the advantage of ADO.Net?
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?
Explain the dataadapter class in ado.net?
Explain how to pass multiple tables in datasets simultaneously?
Which is faster ado.net or linq?
What is the use of data grid?
What you mean by filtering of data?
