DataGridView

[Ginanity]

I'm using a datagridview in my application that get's data from a MySql Server (not localhost) via the ODBC 3.51 driver. Now i'm trying to update the mysql server with the changed data in the datagridview using a dataset

 

          OpenConnection();
           initInfo();
           string _sql = "SELECT * FROM " +tabel;
           da = new OdbcDataAdapter(_sql, con);
           OdbcCommandBuilder _cb = new OdbcCommandBuilder(da);
           if (ds.HasChanges() == true)
           {
               da.Update(ds);
               ds.AcceptChanges();
           }
           CloseConnection(); 

 

I get following error:

Concurrency violation: the UpdateCommand affected 0 of the expected 1 records.

 

The problem is that I have no idea what table or rows are in the datagridview because the user can add a mysql database and the application generates a listview with the tables. On click the selected table appears in the datagridview.

 

So i can't use the update statement or use a datatable...

[Nate Bross]

where is "ds" coming from?

 

Do you maybe need an

Adapter.Fill(ds); 

before the

ds.HasChanged

[techmanbd]

I would say swap the update command and accept changes.

 

You need to accept the changes before you update the table.