what is data set and data adapter what is used of and why its use

Posted by Umeshdwivedi under ASP.NET on 4/13/2011 | Points: 10 | Views : 25063 | Status : [Member] | Replies : 3
Dear all
pls tell me what is data Set and data Adapter and why it used,
give me an example

Latest Technology Trainer
And Part time software consultant



Responses

Posted by: Vuyiswamb on: 4/13/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
a Dataset its an Ado.net object that can have a datable inside it and an adapter is used to fill a dataset or datatable.

http://www.dotnetfunda.com/articles/article103.aspx

Thank you for posting at Dotnetfunda
[Administrator]

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 4/13/2011 [Member] Bronze | Points: 25

Up
0
Down
A DataSet is an inline memory storage object. Through this you can develop a database simillar schema which includes DataTable, DataRow, Relation ships, primary keys, foreign key etc..

Dataadapter is used to fill data to dataset. Dataadapter plays a middle role between connection and dataset. Also it uses datacommand.

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Biswarup90 on: 11/22/2011 [Member] Starter | Points: 25

Up
0
Down
DataSet
A DataSet is a disconnected sub-copy of the original database, containing multiple tables and restraints between them. The database is maintained by the DBMS, while the sub-copy of data is maintained by the DataSet itself. When data in DataSet is changed, it caches the changes, until it is updated back to the source database.

DataAdapter
A data adapter represents a set of methods used to perform a two-way data updating mechanism between a disconnected DataTable and the database. It aggregates four commands: select, update, insert and delete command. One adapter can only generate and fill one table in a DataSet. Therefore to deal with multiple tables in a DataSet you need multiple DataAdapters.

Biswarup Ghosh

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response