Data set and data reader, DOT NET Programming

What is difference between data set and data reader?

Some major differences between dataset and datareader are as folows :-

1) The DataReader gives forward-only and read-only access to the data, while the DataSet object can hold more than one table (in other words rowset) from the similar data source as well as the relationships between them.

2)The Dataset is a disconnected architecture but  datareader is a connected architecture.

3)The Dataset can persist contents while the datareader can not persist contents, they are only forward .

Posted Date: 9/24/2012 2:19:42 AM | Location : United States







Related Discussions:- Data set and data reader, Assignment Help, Ask Question on Data set and data reader, Get Answer, Expert's Help, Data set and data reader Discussions

Write discussion on Data set and data reader
Your posts are moderated
Related Questions
What is the difference between the Take and Skip clauses? The Take clause returns a specified number of elements. For instance, you can use the Take clause to return two values

I need C# API for bitfinex Project Description: Hi, I need a developer to build a library in C# that connects to the bitfinex API. The library must implement all the authenti

Which property on a Combo Box do you set with a column name, prior to setting the Data Source, to display data in the combo box? ComboBox.DataValueField = "ColumnName" When

How do we enable SQL Cache Dependency? Below are some of the steps to enable the SQL Cache Dependency:- Enable the notifications for database. Enable the notificatio

Define Network? A network is a set of devices linked by physical media links. A network is recursively is a connection of two or more nodes by a physical link or two or more

What is CodeDom The "CodeDom" is an object model that represents actually a source code. It is designed for language independent - once you create a "CodeDom" hierarchy for a p

What is basic use of "DataView"? The "DataView" represents the whole table or can be small parts of rows depending on some criteria. It is the best used for sorting and finding

Is spending in projects constant throughout the project? Generally in initial stage of projects (design and requirement phase) the cost is very less (as you require maximum bus

Medical related application in .NET (document, Videos editing must) Project Description: I am seeking a .NET Web application which can do the subsequent: 1. Taking patient

Webpage builder windows application + source code + installer + user friendly interface. Project Description: Website Builder As its name suggests, the site builder should