[RESOLVED] ADO to ADO.Net coding(vb)

[timjohn]

In VB6 I did this

       oFile rsUpd, "select * from blankvars"
        With rsUpd
            .MoveFirst
            Do While Not .EOF
                ![oldcode] = gtID & ![oldcode]
                .MoveNext
            Loop
            .Close
        End With

SImply put I replace a column of data in a table updating as I go then close it.
It's an Access .mdb & OFile opens the recordset.

I would like to do the same but now using vb2010/ADO.Net. I must be missing something simple but any help appreciated.