SdqlDataAdapter Problem

[shailee]

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

[Afraits]

Which update do you get the concurrancy violation on?

[shailee]

the error was on the delete command