migrating VBA code into vb.net

[gouthamsworld]

hi i have some vba modules in access database

now we are trying to develop the same thing using vb.net but as i am new to .net having troubles i have some code like below..

**************************************************
If Tbl.EOF = True Then Exit Sub
If Not Tbl.EOF Then healthTbl.MoveFirst
If Not Tbl.EOF Then assessmentTbl.MoveFirst ' assessmentTbl.MoveFirst

Do While Not Tbl.EOF
If assessmentTbl.EOF = True Then
assessmentTbl.AddNew
Else
assessmentTbl.Edit
End If
assessmentTbl!AppID = healthTbl!AppID
*******************************************
can somebody try to help me doing this in .net i red somewhere that we can do this using "datareaders" and datasets but not sure


i can connect to a access database using odbc/oledb/sql but after that i am not sure how can i manipulate a table in my databse????????



can anyone help?

thanks in advance

 

[cjard]

Ugh. This part needs rewriting properly. Read the Dw2 link in my signature, section on Creating a Simple Data App