I want to remove a record from a datagridview which is bound to a linq to sql query.
There are two grids, one for master data and other for details entry. The linq tables maintain relationships.
The problem is occuring in details grid.
When the row is saved, I have no problem in deleting the row. Calling db.SubmitChanges() removes the rows. But when user enters a new record and decides to cancel his changes, I get an error "An attempt was made to remove relationship between ......" Is there a way of getting out of this problem.