What is the difference betwen ADO.net datasets and ADO recordset?
Datasets are containers — caches — in which you can store data to use in your application. Datasets are a fundamental part of the ADO.NET architecture, providing both high-performance data access as well as scalability.
1.Adding Tables to an Existing Dataset
2. Adding Existing Typed Datasets to a Form or Component
3. Adding Untyped Datasets to a Form or Component
4. Walkthrough: Mapping Data Source Tables to Dataset Tables
The following code examples show how to load a DataSet from an XML stream. The first example shows a file name being passed to the ReadXml method. The second example shows a string that contains XML being loaded using a System.IO.StringReader.
DataSet myDS = new DataSet();
myDS.ReadXml("input.xml", XmlReadMode.ReadSchema);
In the .NET Framework, you can access existing components that return ADO Recordset or Record objects, and you can also access ADO Recordset and Record objects directly using the OLE DB .NET Data Provider. The OLE DB .NET Data Provider supports filling a DataSet from an ADO Recordset or Record. This enables you to consume existing Component Object Model (COM) objects that return ADO objects, without having to rewrite them entirely using the .NET Framework.
