deleting row from dataset

hi gurus and pros,

I used the following code to delete a row from dataset:

Code:

---

R.delete()

---

the problem that I have an error msg of "System Error" when trying to update the dataset using dataadapter.update method.
every thing else works fine like updating existing records or adding new entries.

any suggestion :confused:

Please post error description. Dont you have any constraints in the database not letting the row to be deleted?

Or execute DELETE command . Here's a very good tutorial .http://samples.gotdotnet.com/quickstart/winforms/

thank you for your reply and sorry for my annoying questions...

error msg is:
"An unhandled exception of type 'System.Data.SqlClient.SqlException' occured in system.data.dll

Additional information: System error."

and I don't have any constraints on the DB. (or at least, this's what I think :) )

by the way: this problem doesn't happen when deleting the last row in the database.

Are you telling it which row to delete?

Is would also probably be helpful if you posted the entire code in question because it is most likely not that exact line causing the error.