Join Dotnetcodes DotnetCodes.com is online Discussion Forum for Software professionals . It lets you find friends around the world and Create professional network that share similar interests as you. Get help on ur projects by industry specialists. Also get answers to all ur technical/placement related querries.Get an edge over others.
Already MemberClick here to login
ASP.net MVC Interview Questions Answers Interview Questions
Get Started Developing for Android Apps with Eclipse Articles
Whats New in ASP.NET 4.0 Part 2 Articles
.Net framework 4.0 Interview Questions Answers Interview Questions
SQL server reporting services Interview Questions (SSRS) part 1 Articles
SharePoint 2010 interview Questions Answers Interview Questions
Html5 interview questions and answers Interview Questions
Serial Number in SSRS Articles
How to Print a Crystal Report direct to printer Articles
Explaining SDLC -System Development Life Cycle Articles
Populate or bind Dropdownlist in Asp.net using Jquery and Json Articles
Sql Server Database Backup and Restore through C# Source Codes
ASP .Net Page Life cycle Articles
Benefits of Generics in .net Articles
.Net framework 4.0 major improvements Articles
Submit Articles | More Articles..

What is the difference between DataSet and DataReader?

Posted By: mitu678 On:12/10/2012 8:57:58 PM in:Interview Questions Category:ADO.NET Hits:1241
Following are some major differences 

1. DataReader provides forward-only and read-only access to data, while the DataSet object can hold more than one table  from the same data source as well as the relationships between them.

Following are some major differences 

1.   DataReader provides forward-only and read-only access to         data, while the DataSet object can hold more than one table         from the same data source as well as the relationships                   between them.

2.  DataSet is a disconnected architecture while DataReader is a      connected architecture.

3. DataSet can persist contents while DataReader cannot persist     contents, they are forward only.





comments powered by Disqus
User Profile
Mitu Sinha
Freelancer Software Consultant
Delhi , India
Email :You must Log In to access the contact details.
Latest Post from :mitu678
What is Extensible Output Caching improvement in ASP.NET 4.0?
View: 504 | Submitted on: 1/11/2013 6:18:27 AM
What is Razor View Engine
View: 652 | Submitted on: 12/31/2012 6:10:02 AM
Which are the advantages of using MVC Framework
View: 639 | Submitted on: 12/31/2012 6:03:26 AM
What are ways to create input forms for workflow ?
View: 397 | Submitted on: 12/27/2012 1:54:33 AM
What are the types of input forms that can be created for a workflow
View: 277 | Submitted on: 12/27/2012 1:46:30 AM
Submit Articles | All Post of This User..

All rights reserved to dotnetcodes. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
Best viewed at 1024 x 768 resolution with Internet Explorer 5.0 or Mozila Firefox 3.5 or Google Crome and higher