
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