What is dataset and uses of dataset ?

Answer Posted / k.nagavani

DATASET:
The dataset is a in-memory representation of data.
DataSet is made up of a collection of DataTable objects.
It can be considered as a local copy of the relevant
portions of the database.
The data is persisted in memory and the data in it can be
manipulated and updated independent of the database. When
the use of this dataset is finished, changes can made back
to the central database for updating.
The data in dataset can be loaded from any valid
datasources like Microsoft SQL Server database, an Oracle
database or a Microsoft Access database.
USES:
1. You normally use datasets to hold results of database
queries, but you can also create them on the fly and
populate them programmatically.
2. The DataSet object has characteristics that make it
suitable for persisting application settings: It can hold
hierarchical data in the Tables collection, and you can use
the WriteXml() method to save the entire dataset into an
XML file with a simple call:

ds.WriteXml(strFileName,
XmlWriteMode.WriteSchema);
3. We can seperate data layer from presentation layer by
using class or dataset in .net 2.0.
4. The DataSet in .Net rocks, it provides so much
functionality for free, that it makes it the prefered data
transport mechanism between the presentation layer and the
buisiness layer, when dealing with a pure .Net technology
stack then DataSet's are the way to go.
5. DataSet has some powerful XML-related capabilities. For
example, you can serialize a DataSet into XML through its
WriteXml() method; conversely, you can populate a DataSet
from a properly formatted XML stream using the DataSet's
ReadXml() method.

Is This Answer Correct ?    21 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the role of global.asax?

720


What is asp.net architecture?

720


They mostly asked difference between versions of technologies

1121


What are the Types of object in asp

820


Which method has beenintroduced in asp.net 4.0 to redirect a page permanently?

733


Why session is more secure than cookies?

669


What is the difference between adding reference in solution explorer and adding references by using ?

762


i want the asp.net technical questions and answeres

1786


Difference between Response.redirect vs server.transfer?

850


Tell me the code snippet to show how we can return 404 errors from HttpError?

1014


What should you do is you want to remove an existing component but would like to make some funtionalities?

1715


What are the Types of objects in ASP

754


Just by seeing the signature of the bean how can you specify whether it is a stateful or stateless session bean?

731


What is difference between mvc and asp.net? : Asp.Net MVC

798


Which of the following .NET framework supports Web API?

833