I have TypedDataSet with foreignKey relationship between two table tableA is parent and TableB is the Child table.
first I fill the DataSet from the DataAdapter
TableABDataSet ds = new TableABDataSet();
tableAdataAdapter.parameters["ID"].value = 1;
tableAdataAdapter.fill(ds ,"TableA");
tableBdataAdapter.parameters["ParentID"].value = 1;
tableBdataAdapter.fill(ds ,"TableB");
well I get the dataset as I want
now when I delete one of the child table row as
ds.TableB.Rows[0].delete();
tableAdataAdapter.Update(ds ,"TableA");
tableBdataAdapter.Update(ds ,"TableB");
I get following error
"Concurrancy voilation"
it occurs only when I delete the row not when i update or add rows;
can any one help
first I fill the DataSet from the DataAdapter
TableABDataSet ds = new TableABDataSet();
tableAdataAdapter.parameters["ID"].value = 1;
tableAdataAdapter.fill(ds ,"TableA");
tableBdataAdapter.parameters["ParentID"].value = 1;
tableBdataAdapter.fill(ds ,"TableB");
well I get the dataset as I want
now when I delete one of the child table row as
ds.TableB.Rows[0].delete();
tableAdataAdapter.Update(ds ,"TableA");
tableBdataAdapter.Update(ds ,"TableB");
I get following error
"Concurrancy voilation"
it occurs only when I delete the row not when i update or add rows;
can any one help