Interested to Buy Any Domain ? << Click Here >> for more details...
once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?
- 2 Answers
- 5894 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hhh
DataSet carry considerable overhead because of relations,
multiple tables,
While DataReader only readony and fawardonly stream of
data, it fatch only one row at a time. thats y its faster
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / abhishek
datareader is forwardonly thus is fast and is mostly used
while retrieving the data from the database.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is a database provider?
What is ole in excel?
What is the difference between Command and CommandBuilder object?
How do you update database through dataset?
What is the difference between executenonquery () and executescalar ()?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
what is execute scalar?
11 Answers Atharva Infotech, Dohatec New Media, Make eIT, Protech,
What is different between sqlcommand object and command behavior object?
Explain ado.net features?
Explain all the classes those are used for database connections between sql server and asp.net?
Is bulk insert faster than insert?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
-
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)
