-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Vijay.Net
Message 4 in Discussion
How is
Dataset different from Recordset?
ADO � ADO.NET
DataReader
vs. RecordSet
�RecordSet
uses special programming models while DataReader uses stream interface
�DataReader is
the fastest way to access data today
RecordSet
returns fields as variants while DataReader returns fields as COM+ datatypes for
faster code. You also can get them as Objects
�The
predictability of the RecordSet was uncertain and new Objects were factored to
allow them to always be predictable
ADO.NET
�The
performance is better because each Object is designed for a specific type of
access
�The
programming model is designed to work with streams of data more efficiently
DataSet Object
DataSet is an in-memory scratch pad for data. A DataSet has no knowledge
of a data connection. Once a DataSet has been filled, it does not know where the
data came from. You can add data to a DataSet from several sources. For
instance, you can add data into one DataSet from multiple sources and then
relate them.
The centerpiece of any software solution using ADO .NET is the
DataSet. A DataSet contains any number of data tables, each of which typically
corresponds to a database table or view. A DataSet constitutes a "disconnected"
view of the database data. That is, it exists in memory without an active
connection to a database containing the corresponding tables or views. This
disconnected architecture enables increased scalability by only using database
server resources when reading or writing from the database. At run time, data is
passed from the database to a middle-tier Business Object and then down to the
user interface. To accommodate the exchange of data, ADO .NET uses an XML-based
persistence and transmission format. That is, to transmit data from one tier to
another an ADO .NET solution expresses the in-memory data (the DataSet) as XML
and sends the XML to the other component.
Regards
-Vijay
----- Original Message -----
From:
Mamatha_md
To: BDOTNET
Sent: Thursday, November 27, 2003 4:13
PM
Subject: Answers required
New Message on BDOTNET
Answers
required
Reply
Reply to Sender Recommend
Message 1 in
Discussion
From: Mamatha_md
Hi all,
What is the difference between assemblies and
namespaces?
Please give some scenarios where to use user controls and
custom controls.
How is dataset different from record
set?
Thanks,
Mamatha
-----------------------------------------------------------
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]
