What is CrazyEngico.com (CE)?

CrazyEngico (CE) is a one-stop solution for interview questions and answers, domain knowledge, e-learning, tutorials, articles and many more learning material.
e-learning - Intelligent e-learning tutorials and articles
Domain Knowledge Learn about various business domains/verticals such as Banking, Financial, Insurance, Healthcare and many more...
Interview Questions and Answers - Post your questions and answers. 1000+ database of ready questions and answers available to prepare for an interview.
Tutorials - 300+ video tutorials from beginner to expert level.
Articles - 300+ technical articles to understand concepts.
Forum - A technical forum to post your queries/responses.

Search Questions

Interview Questions/Answers

Interview Q & A >> ADO.NET >> Difference between DataSet and DataAdapter

<< Previous Question Navigator Next >>

1        0
Difference between DataSet and DataAdapter (Views: 8266)


6        1

The DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the data source. It can be used with multiple and differing data sources, used with XML data, or used to manage data local to the application. The DataSet represents a complete set of data including related tables, constraints, and relationships among the tables. The methods and objects in a DataSet are consistent with those in the relational database model. The DataSet can also persist and reload its contents as XML and its Schema definition language (XSD) schema.
The DataAdapter serves as a bridge between a DataSet and a data source for retrieving and saving data. The DataAdapter provides this brigde by mapping Fill, which changes the data in the DataSet to match the data in the data source, and Update, which changes the data in the data source to match the data in the DataSet.

Submitted By: Anonymous | Created On: 5/16/2009 4:20:27 PM

0        1

I dont think dataAdapter is  acting as a bridge beween dataset and database.We can also insert update and delete from the database with using of data adapter and dataset in a disconnected way

Submitted By: Girija(S/w) Developer | Created On: 5/2/2011 4:29:10 AM

1        4

Data reader 1. It is a read only and forward only data.2. U can access one table at time.3. It can't persist the data.4. It is comes under connected architecture.5. One of the most advantage is it is much faster than dataadapterData set:1. It is defined with multiple tables.2. It can persist the data.3. It is a relational data cache hosted in applicationdomain during execution.4. It is a disconnected architecture.5. It can't defined with out data adapter.

Submitted By: Nanditha(s/w developer) | Created On: 7/21/2011 10:13:35 PM

1        1

yes,   dataset itself cant manipulate datas on database...........for this needs the help of dataadapter.......its like our laptop battery which can store charge but with the help of acadapter. 

Submitted By: Debasish | Created On: 1/23/2012 12:03:23 PM

0        0

Data Set The data from the database is filled into the dataset by using the DataAdapter.A Dataset is a in memory representation of a collection of Database objects including tables of a relational database scheme. Thedataset contains a collection of Tables, Relations, constraints etc

Submitted By: selvi | Created On: 3/23/2012 1:49:50 AM

0        1

I think data set is used for the storage of data of table and other data and these data is given by data  Adapter by fetching the database

Submitted By: Anonymous | Created On: 6/9/2012 12:54:45 PM

1        0

Data set is worked on disconnected architecture mode and Data Adapter worked on connected architecture mode

Submitted By: R.Sharma | Created On: 11/5/2012 11:10:25 PM

0        0

data adapter enable us to retrieve, delete or update data from the respective databases. it acts like a bridge between dataset n data sources(sql server, oracle etc.).
while data set is like an container or cache which can be used to store the data that has to be used in our application. 

Submitted By: Rajesh Kumar Rana | Created On: 6/9/2013 10:26:43 PM

Post your Answer
Your answer will be first reviewed by our administrator before it appears on the site.

Your Answer:

Display Name:

By clicking on Submit button you agree to the Terms of Service agreement.

Copyright © 2018 CrazyEngico.com. All rights reserved.
CrazyEngico.com is not responsible for the content and CrazyEngico.com does not evaluate or guarantee the accuracy of any CrazyEngico.com content.
Please read our terms of service agreement before using this site.