Concurrency violation: the DeleteCommand

i am trying to update database after adding a row to a dataset but keep getting this error:

i have not delete any rows just added one here is the code:

public void AddRow(System.Data.DataSet ds, string tablen, string[] info)

{

row = ds.Tables[tablen].NewRow();

row[0] = info[6];

row[1] = info[0];

row[2] = info[1];

row[3] = info[2];

row[4] = info[3];

row[5] = info[4];

row[6] = info[5];

ds.Tables[tablen].Rows.Add(row);

ds.Tables[tablen].DefaultView.Sort = "Date ASC";

objConnect.UpdateDatabase(ds, tablen);

}

public void UpdateDatabase(System.Data.DataSet ds, string tablen)

{

System.Data.SqlClient.SqlCommandBuilder cb = new System.Data.SqlClient.SqlCommandBuilder(da_1);

cb.DataAdapter.Update(ds, tablen);

}

please help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bhuvanesh Mohankumar10y ago
Remove concurrency and try the same.
Instead of hard delete, do soft delete by adding a column as "IsDeleted" if that is true then hide from user, if false then show the values in queries to user.
Mark as answer, if helpful.
0