0
Answer

iterate and update ado.net dataset

Delta E

Delta E
16y
3k
1
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
Next Recommended Forum