DataGridView Binding with MYSQL Datatable, Where am i wrong??

[deepakmahat]

ON FORM LOAD

odbcDataAdapter = new OdbcDataAdapter(@"call Get_Designers(-1)", sqlConnection.Connection);

dataTable = new DataTable();
odbcDataAdapter.Fill(dataTable);

//odbcDataAdapter.FillSchema(dataTable, SchemaType.Source);

OdbcCommandBuilder commandBuilder = new OdbcCommandBuilder(odbcDataAdapter);


BindingSource bSource = new BindingSource();
bSource.DataSource = dataTable;
dataGridView.DataSource = bSource;

DesignerName.DataPropertyName = "designer_name";
DesignerContact.DataPropertyName = "designer_contact";
DesignerLastModified.DataPropertyName = "last_modified";
DesignerDateCreated.DataPropertyName = "date_added";

ON SAVE BUTTON CLICK //TRIGGERED AFTER CHANGES IN ONE OR MORE DATA ROW IN GRID

OdbcCommand updateCmd = new OdbcCommand(@"call Set_Designer(@designer_id,@designer_name,@designer_contact)");
updateCmd.Parameters.Add("@designer_id", OdbcType.Int, 11, "designer_id");
updateCmd.Parameters.Add("@designer_name", OdbcType.VarChar, 255, "designer_name");
updateCmd.Parameters.Add("@designer_contact", OdbcType.VarChar, 500, "designer_contact");
odbcDataAdapter.UpdateCommand = updateCmd;

odbcDataAdapter.Update(dataTable.GetChanges(DataRowState.Modified));

GIVES EXCEPTION

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

 

[murdoch]

Wow this is all a bit heavy!!!
Think this may be a job for the forum site boss Ian to step out of the shadows & become a super-hero.