hi..
is DATASET and RECORDSET the same thing..if not then wat are the difference..?
Arvinder Gill
Printable View
hi..
is DATASET and RECORDSET the same thing..if not then wat are the difference..?
Arvinder Gill
MSDN - Comparison of ADO.NET and ADO
Quote:
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.