Hi I'm having problems working with data adapters and datasets... Simple program of just transfering data from MS SQL to MS Access using loop... in vb 6 i use this codes could someone create a VB.net version using ADO.NET?
'Assuming rsSQL is connected to MS SQL DATABASE
'and rsAccess is connetcted to MS Access 2000 Database
do while not rsSQL.eof
rsAccess.AddNew
rsAccess!FName = rsSQL!Fname
rsAccess!LName = rsSQL!Lname
rsAccess.Update
rsSQL.MoveNext
loop
I hope someone can help me....Please, please please.....
Thanks a lot...