In VB6 I did this.

Dim cn As New ADODB.Connection

cn.ConnectionString = "provider=sqloledb.1;" _
& "persist security info=false;" _
& "user id=;password=;" _
& "initial catalog=Temp;" _
& "data source="
cn.Open

Dim rs As New ADODB.Recordset

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

rs.Open "Select * from EBY_PriceBk_Temp"

How can do I do this in VB.net?

Thanks