how to convert this MS access code to sql2005 @ vb.net2005 code?

[EDN Admin]

hi
how to convert this MS access code to sql2005 @ vb.net2005 code?
Public Sub RowOrder()<br/>
Dim db As DAO.Database<br/>
Set db = CurrentDb<br/>
Dim rs As DAO.Recordset<br/>
Dim i As Long<br/>
Set rs = db.OpenRecordset("Table2")<br/>
With rs<br/>
Do Until .EOF<br/>
For i = 1 To rs.RecordCount Step 1<br/>
.Edit<br/>
rs!IDD = i<br/>
.Update<br/>
.MoveNext<br/>
Next<br/>
Loop<br/>
End With<br/>
End Sub
<br/>
<br/>

View the full article