DATASET and RECORDSET

[Asgill]

hi..

is DATASET and RECORDSET the same thing..if not then wat are the difference..?

Arvinder Gill

[Tewl]

MSDN - Comparison of ADO.NET and ADO

A recordset looks like a single table. If a recordset is to contain data from multiple database tables, it must use a JOIN query, which assembles the data from the various database tables into a single result table.

In contrast, a dataset is a collection of one or more tables. The tables within a dataset are called data tables; specifically, they are DataTable objects. If a dataset contains data from multiple database tables, it will typically contain multiple DataTable objects. That is, each DataTable object typically corresponds to a single database table or view. In this way, a dataset can mimic the structure of the underlying database.