Delta E

Delta E

  • NA
  • 1
  • 0

iterate and update ado.net dataset

Jan 14 2009 9:56 AM
Can someone please give me some sample code on how to do the following with a dataset in ado.net.  I am using c#.

rst.Open sqry, cnnSQL, adOpenStatic, adLockOptimistic
    If rst.RecordCount > 0 Then
        With rc
            .MoveFirst
            While Not .EOF
                 ictr = ictr + 1
                .Fields("ID") = ictr
                .Update
                .MoveNext
            Wend
        End With