ColumnMapping problem

[vincenzofoggia]

Hi at all

Before sorry for my poor english.
I have problem with binding column of MySqlDataAdapter.
When i binding column manually i must use tha same name of sorceColumn and DatasetColumn.

MySqlConnection Cn = new MySqlConnection(strConnection);

Cn.Open();

DaMySql = new MySqlDataAdapter();

//binding manually
DaMySql.MissingMappingAction = MissingMappingAction.Error;
DataTableMapping table = DaMySql.TableMappings.Add("Articoli","Articoli");
table.ColumnMappings.Add("Id","Key");
table.ColumnMappings.Add("Codice","Code");

string query = "SELECT Id,Codice FROM Articoli";
DataTable dt = new DataTable("Articoli");

DaMySql.SelectCommand = new MySqlCommand(query,Cn);
DaMySql.Fill(dt);
DaMySql.FillSchema(dt,SchemaType.Mapped);

MySqlCommandBuilder cb = new MySqlCommandBuilder(DaMySql);
DaMySql.UpdateCommand = cb.GetUpdateCommand();
DaMySql.InsertCommand = cb.GetInsertCommand();
DaMySql.DeleteCommand = cb.GetDeleteCommand();

DataRow row = dt.NewRow();
row["Key"] = 34;
row["Code"] = "A07";
dt.Rows.Add(row);

DaMySql.Update(dt);


When I call DaMySql.Update(dt); function i receive exception:"The column Codice is not include in table Articoli".Why?
if i binding column with the same name of sourceColumn all is correct.

Thanks in advance

Vincenzo