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 uses of Stored Procedure?
What is ado.net architecture?
What is acid in ado.net?
Explain acid properties?
What is DataReader Object?
What is difference between connected and disconnected architecture in ado.net?
What you mean by filtering of data?
Explain what a diffgram is and its usage ?
What is ado.net full form?
What is the default Timeout for SqlCommand.CommandTimeout property?
How to Handle the exceptions in Sqlsrver2000
How to retrieve the third table value from the data set?
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)