-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Swami_SRS
Message 3 in Discussion
DataSet: This is a disconnected, in-memory representation of the database. In-memory:
The object resides in the client's memory. Representation of a database:
This object can contain one or more than one table's records as separate
datatables, thus is a datacontainer. Additionally it can have constraints,
relationships on the tables present in the dataset. Datatables are similar to ADO's
recordset. Usage: This can be used to persist the records in the client, so that
updates can be made and the changed records can be saved from the same object. This
object should not be used if the data is retrieved for read-only purposes, due to
performance reasons. DataReader: This object too contains the data retrieved from
the database, similar to a datatable in a dataset. But, this needs a live connection
to retrieve the data. All the rows are not fetched upfront, but fetched only on
demand. As all the rows are not fetched upfront, the connection should be closed only
after all the records have been retrieved manually. Moreover you cannot navigate
across the records in a datareader, i.e. its a forward only reader. Usage: This can be
used only to retrieve data, as this cannot persist data. DataAdapter: This object,
as its name implies, acts as an adapter between the datacontainer object
(dataset/datareader) and the datasource ( the db server). There are different methods
supported by this object to populate the different datacontainer objects mentioned
above. This is a very very simple explaination for your query. Maybe all of us can
add more points they think are vital to the object's features. -Swami
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
