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 the advantage of ADO.Net?
How would you connect to database using .NET?
What is difference between executequery and executeupdate?
What is executescalar and executenonquery?
What is ambient transaction?
What is the difference between oledbreader and datasetwhile connecting?
What is difference between sqldatareader and sqldataadapter?
Define table relations?
FetCh Records No 5 to 10 From Dataset
Describe datareader object of ado.net with example.
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What are the advantages and disadvantages of using datalist?
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)