How do I get data from my connection?
Ok, I have my connection string...
Dim oOleDbConnection As OleDb.OleDbConnection
Dim sConnString As String = _
"Provider=sqloledb;" & _
"Data Source=Blah;" & _
"Initial Catalog=Blah;" & _
"User Id=Titus;" & _
"Password=Blah"
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
In VB 6, I would do this to get the data from this string...
Dim rs As New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.ActiveConnection = oOleDbConnection
rs.LockType = adLockOptimistic
rs.open "Select * from Blah Where Blah = Blah"
How would I do this very same thing in .Net?
Please be very specific because I know very little about .Net.
Thank you.
