Reputation: 13616
I use this line:
DataSet.SomeTableName.Rows.InsertAt(someRow, 0);
After this line I update my SQL table. But the inserted row does not appear on the SQL server side.
Any idea why the inserted row doesn't appear on the SQL server side?
Upvotes: 1
Views: 98
Reputation: 67898
Issue the SetAdded
method:
someRow.AcceptChanges();
someRow.SetAdded();
as far as I know InsertAt
doesn't actually perform the RowState
modifications.
Upvotes: 1