In VB6 when I wanted to connect to my SQL server tables, this is what I did.

Dim cn As New ADODB.Connection

cn.ConnectionString = "provider=sqloledb.1;" _
& "persist security info=false;" _
& "UID=;PWD=;" _
& "initial catalog=;" _
& "data source=111.111.1.111"
cn.Open

Dim rs As New ADODB.Recordset

rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.ActiveConnection = cn
rs.LockType = adLockOptimistic

How do I do this same thing in .Net?

Do I have to drop the tabels onto my form using the Server Explorer first?

Do I have to have a dataset on my form before I can get data?