Updating mysql table gives error

Question

i have this code and it is giving me this error i tried really hard to solve this but i am getting no luck. This method is used to update a table from mysql by giving select statement, tablename and dataset. The error is "Update unable to find TableMapping['tblapartments'] or DataTable 'tblapartments'."

public bool UpdateDatabase(string SelectStat, string tablename, DataSet dataset)
{
    try
    {
        MySqlDataAdapter da = new MySqlDataAdapter(SelectStat, _conn);
        MySqlCommandBuilder MYCB = new MySqlCommandBuilder(da);
        DataSet ds = dataset;
        da.MissingSchemaAction = MissingSchemaAction.AddWithKey;

        da.Update(ds, tablename);
        MySqlConnection.ClearAllPools();
        return true;
    }
    catch (Exception ex)
    {
        return false;
    }

}

this is the whole method used for calling the method.

 DataTable dt = (DataTable)dtgApartList.DataSource;
 DataSet ds = GlobalVariables.Adap.GetTableCus("SELECT NameNo, MaintenanceFee, AdminFee  FROM tblapartments WHERE BuildingID = '" + cmbBuildingName.SelectedValue.ToString() + "'");
 ds.Tables[0].Merge(dt, false);
 GlobalVariables.Adap.UpdateDatabase("SELECT NameNo, MaintenanceFee, AdminFee  FROM tblapartments WHERE BuildingID = '" + cmbBuildingName.SelectedValue.ToString() + "'", "tblapartments", ds);

Can you list the code that calls this?

Poodlehat
– Poodlehat

2011-10-25 14:02:10 +00:00
Commented Oct 25, 2011 at 14:02 — Poodlehat
– Poodlehat, Commented Oct 25, 2011 at 14:02
I editid to show you how i am calling the method

owen
– owen

2011-10-25 14:14:41 +00:00
Commented Oct 25, 2011 at 14:14 — owen
– owen, Commented Oct 25, 2011 at 14:14

owen · Accepted Answer · 2011-10-27 12:25:46Z

I figured out what i was doing wrong i needed to mapp the tables here is the fixed code

public bool UpdateDatabase(string SelectStat, string tablename, DataSet dataset)
{
    try
    {
        MySqlDataAdapter da = new MySqlDataAdapter(SelectStat, _conn);
        MySqlCommandBuilder MYCB = new MySqlCommandBuilder(da);
        DataSet ds = dataset;
        da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
        //Added this
        ITableMapping testing = da.TableMappings.Add(tablename,"Table");
        da.Update(ds, tablename);
        MySqlConnection.ClearAllPools();
        return true;
    }
    catch (Exception ex)
    {
        return false;
    }

}

Collectives™ on Stack Overflow

Updating mysql table gives error

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related