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

  • Question

  • hi all

    Iam so beginner

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

    Public Sub RowOrder()
    Dim db As DAO.Database
    Set db = CurrentDb
    Dim rs As DAO.Recordset
    Dim i As Long
    Set rs = db.OpenRecordset("Table2")
    With rs
      Do Until .EOF
        For i = 1 To rs.RecordCount Step 1
        .Edit
        rs!IDD = i
        .Update
        .MoveNext
        Next
      Loop
    End With
    End Sub


    Thursday, July 14, 2011 2:54 PM

Answers

All replies