can we have multiple datatables in a datareader ?
Answers were Sorted based on User's Feedback
Answer / vaidyanathan r
The DataReader may read multiple data tables(I am not
sure). But it cant hold them. There is a difference between
Reading and Holding
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / amresh chandra
you have to use joint in urs sql syntax.Or indirectly no
more than one table in datareader
| Is This Answer Correct ? | 3 Yes | 8 No |
Answer / vaidyanathan r.
No. DataReader can hold only one record at a time. And it
can read the records in forward-only manner.
| Is This Answer Correct ? | 1 Yes | 13 No |
Answer / kumar vaibhav
No, We can not have multiple datatables in Datareader
instead we can have multiple datatables in DataSet
| Is This Answer Correct ? | 5 Yes | 23 No |
Answer / suhel sadat
No we can't, multiple datatables can be used in dataset.
| Is This Answer Correct ? | 10 Yes | 40 No |
Explain what is datagrid with an example?
What is adodb dll?
How to sort the data in Datatable
What is executequery?
What is the hierarchy of data in databases?
What is difference between ado and other data object?
What is ado.net code?
What does datareader object do?
Which database is the ado.net sql connection object designed for?
What are the different namespaces used in the project to connect the database?
what is connection pooling ?
Which object holds only data and does not interact with data source?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)