Hi all I am new to .NET and some what familiar with data connections using VB6. As I understand it this is the process in .NET to connect and use a database.

You need a OleDbConnection object to connect to the database.

An OleDbDataAdapter object that tells what data you want out of the database that you made a connection with using the OleDbConnection object.

Lastly you need DataSet which "holds" the data you are working on.

Is this all correct first off?

If so does the DataSet object actually have the data from the database in memory or is it just a reference to the data?