Reset Binding is not working.

See more:

C#

.NET

MySQL

Hi. I have a problem on refreshing the dataset. here is my code.

public void BindingMetaboliteName(frmMetCon config)
{
    schemaForm = new SchemaName();
    string connStr = "datasource=localhost;port=3306;username=root;password=root;";
    conn = new MySqlConnection(connStr);
    command = conn.CreateCommand();
    string database = schemaForm.getData;

    try
    {
        dtable = new DataTable();
        bindingSource = new BindingSource();


        conn.Open();
        switch (cmbMetabolite.SelectedIndex)
        {
            case 0:
                dbSumMetabolite.ResetBindings();
                dbSumMetabolite.AutoGenerateColumns = false;
                command.CommandText = "SELECT MetaboliteID, Metabolite_Name FROM " + database +
                                      ".Metabolites " +
                                      "WHERE Metabolite ID IN ('met1', 'met2');";
                MySqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
                dtable.Load(dr);
                dbSumMetabolite.DataSource = null;
                for (int i = 0; i < dtable.Rows.Count; i++)
                {
                    dbSumMetabolite.Rows.Add();
                    dbSumMetabolite.Rows[dbSumMetabolite.Rows.Count - 1].Cells["MetaboliteID"].Value = dtable.Rows[i]["MetaboliteID"].ToString();
                    dbSumMetabolite.Rows[dbSumMetabolite.Rows.Count - 1].Cells["Metabolite_Name"].Value = dtable.Rows[i]["Metabolite_Name"].ToString();
                }
                break;

        }
        conn.Close();
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

The problem i am facing is that the reset binding is not working. whenever i updating the the data the datagridview will duplicate the rows instead of replacing it. and this code is inserted in leavepage event handled