.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Difference between datareader and dataset

Posted By: Jegan R     Posted Date: November 01, 2010    Points:2   Category :ASP.Net
Difference between datareader and dataset?

Author: Ramesh P             
Posted Date: November 01, 2010     Points: 5   

Data reader is a read only data. We can retrieve the data only from the database. We cann't edit,update.
But dataset can retrieve and change data from database.

Dataset is a disconnected mode where datareader is a connected mode.

Dataset read data from a single table where dataset can be used in multiple tables.

Datareader is faster than dataset.



Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend