VS 2008 ADO DataSource

Hey All,

Needing pointed in the right direction. I am fooling around with data sources and connections per homework and what I'm looking for is creating an SQL DB connection during runtime.

I know that you can add a data source in design by going through the Wizard but what if one would want to create the connection, adapter, and dataset during runtime? Where would you start?

I have cruzed the net looking for some form of a tutorial to just get me started, I don't need it all completely outlined but I need to know where and how to start and what I need to declare the connection, string, and dataset as. I have seen a lot of information using VB6 but nothing that I come across seems to work.

My basic questions are:
Do I have to create a seperate class for the database connection?
How do I delcare the nuts and bolts of the connection,adapter, and dataset?
If a seperate class isn't required then where is the most realistic place these items would be created?

Thanks guys, I'm going to keep looking for some solid information on this while I wait for some returns. The worst suck job thing about it all is my current "advanced" book doesn't even walk you through manually creating any type of database interaction, it only shows the datasource Wizard windows. I'm starting to think that this is the only way.

Thanks again.