hi,
i just want to know the difference between dataset and recordset.

Thanx

sachin

Dear
Dataset is a named collection of logically related data items arranged in a prescribed manner.
While a recordset object is opened with a SQL query to a database, and the results (or lack thereof) are stored in the recordset

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find it and grab it!

Hi Sachin,

Recordset is an object that refers the entire base table or set or rows that resulted from a query. It is an ADO object. Dataset doesn't exist in ADO.

Dataset is an ADO.Net object. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET as referred in msdn.

If I am right, recordset of ADO is upgraded to Dataset in ADO.Net with more features.

Refer these links for more info on them.
ADO Recordset Object

ADO.NET DataSet

Cheers!

_________________________
- Vijay G
Strive for Perfection

Not quite...

The ADO Recordset is more like a DataTable than a DataSet. A DataSet contains DataTables whereas the Recordset is more or less just one table. (Of course, you can use a multipart query and get multiple result sets in the same Recordset.)

planoie,

Thanks for correcting me, that explains much better. (I am just starting off)

Cheers!

_________________________
- Vijay G
Strive for Perfection