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 |
How to Handle the exceptions in Sqlsrver2000
What is the difference between oledb sql server and oledbdotnet provider?
Why do we serialize data?
Where does ADO.NET and XML web services come in the architecture ?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
What is difference between ado and other data object?
Explain ado.net features? Benefits? Drawbacks?
What is a sqldataadapter?
What is the difference between ado.net and entity framework?
What is the difference between Optimistic and Pessimistic locking?
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)