|
-
Dec 6th, 2002, 11:30 AM
#1
Thread Starter
Fanatic Member
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|