Hello:
I would like to delete a row in a RecordSet using old school ADODB. Basically, I am deleting rows in a DataGridView, and after deleting various rows I do an update to preserve the order. The problem is, if there were more records to start with, the records at the end need to be deleted.
Hopefully this is an easy question. I have done numerous web searches, including this: https://flylib.com/books/en/3.9.1.26/1/Code:If rs.RecordCount > ccnt Then For cx As Integer = ccnt To rs.RecordCount ' Delete row cx ' rs.Update() Next End If
Things are not obvious.
Thank you!