Update method of DataSet.xsd doesn't changed DataBase, Why?

Question

I made a DataSet.xds file with VS wizard. Select part of tables works properly. Now I want update a record from a table, I used codes below.

private void AuthorsTableAdapter(DataRow changedDataRow)
    {

            authorsTableAdapter adapter = new authorsTableAdapter();
            adapter.Update(changedDataRow);
    }

This code can change the record and I can see the changes in for example DataGridView, but when I check the DataBase file or restart the application I realize the record(s) doesn't changed! That Update method just changed records in memory not in DataBase file. Any solution?

Sorry for my English and many thanks for your help.

score 0 · Answer 1 · answered Feb 04 '13 at 18:21

0

Is the UpdateCommand property of the adapter populated?

answered Feb 04 '13 at 18:21

Mike the Tike

1,136
8
9

All Select, Insert, Delete and Update commands are generated. Thanks for your attention. – Parham.D Feb 05 '13 at 05:00

score 0 · Answer 2 · answered Feb 10 '13 at 07:59

0

I deleted the DataSet and then make it again without set a copy of database file in project. When you set a copy of database file in project, in every new solution building that database file will copy again. That was the problem!

answered Feb 10 '13 at 07:59

Parham.D

1,158
2
12
31

Update method of DataSet.xsd doesn't changed DataBase, Why?

2 Answers2