Re: mysqlcommandbuilder and generated commands for update

[Lou Arnold]

You have done everything correctly, but you are looking at the Insert commands at the wrong time. The command builder only generates the Insert, Update and Delete Commands as part of the DataAdapetr's Update method. Before that call to Update, the dataset looks like its made up for only the first table.

I would also do the following:
-----------------------------------------
array<DataTable^>^ dta; //temp DataTable array returned by FillSchema
pCpyDA->MissingSchemaAction=System::Data::MissingSchemaAction::Add;
dta=pCpyDA->FillSchema(dataSet1,System::Data::SchemaType::Source, "tblCompany");
dta[0]->Columns[0]->AutoIncrement=true;
int kk; //test - get the number of rows read into the dataset.
kk=pCpyDA->Fill(dataSet1, "tblCompany");//Fill the dataset from the table

pStatusDA->MissingSchemaAction=System::Data::MissingSchemaAction::AddWithKey;
dta=pStatusDA->FillSchema(dataSet1,System::Data::SchemaType::Source,"tblStatus");
dta[0]->Columns[0]->AutoIncrement=true;
kk=pStatusDA->Fill(dataSet1, "tblStatus");//Fill the dataset from the table
-------------------------------
Note that I added the FillSchema command and that I execute that BEFORE the Fill method. After that call I set the Autoincrement property yo true so that auto increments will occur properly.