SdqlDataAdapter Problem

shailee

Member
Joined
Apr 12, 2005
Messages
13
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
 
Back
Top