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.

ADODB recordsets are old news...
you should look into + use ADO.Net

http://msdn.microsoft.com/en-us/library/aa302325.aspx

Quote:

---

Originally Posted by .paul.

ADODB recordsets are old news...
you should look into + use ADO.Net

http://msdn.microsoft.com/en-us/library/aa302325.aspx

---

Hey thanks for the suggestion. will try it out and post the feedback.