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 |
What are the several execute methods of ado.net?
How can we add relation between tables in a dataset?
What is a control toolbox?
What is the full form of ado?
Define data access layer?
What is ado net stands for?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
Explain the overview of ado.net architecture?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What are major difference between classic ADO and ADO.NET?
How do you merge 2 datasets into the third dataset in a simple manner?
What providers do you use to connect to oracle database ?
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)