What is dataset and uses of dataset ?

Answers were Sorted based on User's Feedback



What is dataset and uses of dataset ?..

Answer / 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

What is dataset and uses of dataset ?..

Answer / nagaraj

1. datasert is connection less in memory representation of
the data xml represention.
2. once the data load into dataset their is no need to
maintain the live connection.
3.once dataset is collection of any no.of datatable
objects.the information of these table may be taken from
diff datasource.
4.the dataset updatable
5.the data set will represent the information inthe xml
format internally

Is This Answer Correct ?    9 Yes 1 No

What is dataset and uses of dataset ?..

Answer / ponvanaraja

A Dataset is a in memory representation of a collection of
Database objects including tables of a relational database
scheme. The dataset contains a collection of Tables,
Relations, constraints etc.,

It can be used for manipulating the data remotely and
finally updating the database with the modified data. This
way it enables disconnected means of working with data. This
improves performance in terms of reducing the number of
times a database is accessed for data manipulations.

Is This Answer Correct ?    7 Yes 1 No

What is dataset and uses of dataset ?..

Answer / sathish

dataset solved a lot of handling huge amount of data.The
dataset when pointed to stored procedures can be able to
load data of many tables and can be accessed at any instant
any record.

Is This Answer Correct ?    5 Yes 2 No

What is dataset and uses of dataset ?..

Answer / kavitha

dataset are tow types
typed dataset typeddataset and untypeddataset
typedataset is xml format
untypeddataset is textformat
dataset as any modifications create insert delete insert
update & edit
dataset like as database

Is This Answer Correct ?    3 Yes 0 No

What is dataset and uses of dataset ?..

Answer / supriya

Dataset is a memory represtation of data.it is collection
of datatables object.it can manipulated and updated
independent of the database.it is normally hold the result
of datasets.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More ASP.NET Interview Questions

What is asp net objects?

0 Answers  


what is satellite assembly in .net?

4 Answers   iSoft,


How can I open ashx file in mobile?

0 Answers  


What setting must be added in the configuration file to deny a particular user from accessing the secured resources?

0 Answers  


What are different transaction options?

2 Answers   Astadia,






What is the difference between appsetting and connectionstring tags in web.config file

2 Answers   HCL, TCS,


How can we access static variable?

0 Answers  


What is the extension of master page in asp.net?

0 Answers  


What benefit does your code receive if you decorate it with attributes demanding specific Security permissions?

2 Answers  


I M working in 1.1 .net framework. In a page I have 5 text box & 2 data grid. In PageLoad() All text box will populate with blank value & 1st dataGrid with some value. When I click on EDIT button Of the 1st dataGrid,The Relevent data Of the particular row will populate in first 3 textboxs & corresponding relevent data Will populate in the 2nd DataGrid. Now when I click 2nd datagrid's EDIT button of a perticular Row,relevent data will populate on last 2 textboxs & 1st 3 textbox's value will be same as per as it was........ ........My Problem Is ........... When I click on edit button Of 2nd DataGrid, 1st 3 text boxes values goes Off & 2nd DataGrid Is goes off Due to Postback.but The relevent value is populated In last 2 textboxes.So How I stoped this postback??So that all the data in 1st 3 textboxes will be same.So that I can edit the values of 2nd Grid with 1st 3 textBoxes value.. plz dirctly mail me 1 copy of post to... maloy.adhikari@in.com

2 Answers  


What are the event handlers that we can have in global.asax file?

0 Answers  


Types of values mode can hold session state in web.config ?

1 Answers   Accenture, Parrot Systems,


Categories