Connectionless strings in .Net

[indydavid32]

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?

[amitabh]

See if this link helps you.

[indydavid32]

Thanks for your reply.

Where do you place the following snipet of code in my program?

Imports System.Data.SqlClient

Thanks

[indydavid32]

Nevermind, I got it. Thanks for your help.

[amitabh]

Not sure of the answer though, but you can take a look at http://aspnet.4guysfromrolla.com/ .

[amitabh]

Oops. Didn't saw that you had already found an answer.