Error while using recordsets to delete records
I am using the following code to delete a record in vb:
"If rspmps2("pmpidno").Value = gvr1.Cells("pmpidno").Value Then
rspmps2.Delete()
rspmps2.UpdateBatch()"
where rspmps2 is a ADODB record set and gvr1 is a grid view row. but I keep getting the following error message:
"Row handle referred to a deleted row or a row marked for deletion."
Please can somebody assist me in this.
Re: Error while using recordsets to delete records
ADODB recordsets are old news...
you should look into + use ADO.Net
http://msdn.microsoft.com/en-us/library/aa302325.aspx
Re: Error while using recordsets to delete records
Quote:
Originally Posted by
.paul.
Hey thanks for the suggestion. will try it out and post the feedback.