stickleprojects Level: Moderator

 Registered: 09-09-2002 Posts: 891
|
Re: what is the difference between an ADO.NET Dataset and an ADO Recordset?
Hi,
In brief...
An ADO Recordset is a single resultset (ie. table)
An ADO.NET DataSet is a structure containing many DataTables. A DataTable is effectively the same as an ADO Recordset.
There are many additional features in a DataSet (ie. Relationships, etc.) and in a DataTable (ie. there is a command to give you the records that have been added / deleted / updated by the user) and DataViews (ie. a subset of the contents of the table - sorted/filtered).
See links below for more info:
http://www.dnjonline.com/articles/essentials/iss22_essentials.html
http://msdn.microsoft.com/msdnmag/issues/04/07/DataPoints/default.aspx
or search on Google
____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)
|