What is a DataSet?

[Sathyaish]

What is the DataSet object I have spotted now a couple of times? Is this the same as the ADO recordset?

[Shurijo]

DataSets can have multiple dataTables. DataTables have multiple datacolumns and datarows, etc. I think that DataSets are the like the "ADO.NET recordsets", but I think DataTables relate more directly to recordsets and a DataSet is a collection of DataTables.

------------------------------

The DataSet, which is an in-memory cache of data retrieved from a database, is a major component of the ADO.NET architecture. The DataSet consists of a collection of DataTable objects that you can relate to each other with DataRelation objects. You can also enforce data integrity in the DataSet by using the UniqueConstraint and ForeignKeyConstraint objects. For further details about working with DataSet objects, see Creating and Using DataSets.

While DataTable objects contain the data, the DataRelationCollection allows you to navigate though the table hierarchy. The tables are contained in a DataTableCollection accessed through the Tables property. When accessing DataTable objects, note that they are conditionally case-sensitive. For example, if one DataTable is named "mydatatable" and another is named "Mydatatable", a string used to search for one of the tables is regarded as case-sensitive. However, if "mydatatable" exists and "Mydatatable" does not, the search string is regarded as case-insensitive. For more information about working with DataTable objects, see Creating a DataTable.

A DataSet reads and writes data and schema as XML documents. The data and schema can be transported across HTTP and used by any application, on any platform that is XML-enabled. You can save the schema as an XML schema with the WriteXmlSchema method, and the schema and data can be saved using the WriteXml method. To read an XML document that includes both schema and data, use the ReadXml method.

[salvelinus]

Similar to a disconnected recordset. Doesn't have MoveNext, MoveFirst, EOF, BOF, etc.

[Andy]

what's a good site for ado and ado.net tutorials?