I'm really new to VB.Net, anyway I'm trying to read a SAS dataset into a recordset using ADO. I can get this to work using VB 6.0 but I'm not having any luck in .Net . Here is the code so far:
Private Sub btnRunJob_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRunJob.Click
Dim cnADOConnection As New ADODB.Connection
Dim rsRecs As New ADODB.Recordset
cnADOConnection.Provider = "SAS.LocalProvider.1"
cnADOConnection.Properties("Data source") = "C:\Documents and Settings\C18850\medlnamts"
cnADOConnection.Open()
rsRecs.Open("chk1", cnADOConnection, ADODB.OpenStatic, adLockReadOnly, ADODB.adCmdTableDirect)
End Sub
I know it has something to do with namespace. Just not sure how it all fits together properly, any help would be appreciated. Plus could somebody reccommend a good beginning reference book for VB.Net.
Thanks