DataGridViewComboBox column in C#

Question

I am fail to clear the DataTable Bind to the (cnsmNm) datagridviewCombobox column. On New Button Click I am clearing the Data

 dtCnsmbl = dsCnsmspplr.Tables[0]; 
            dtCnsmbl.Rows.Clear();
            cnsmNm.DataSource = dtCnsmbl;
            cnsmNm.DisplayMember = "cnsm_Name";
            cnsmNm.ValueMember = "cnsm_Id";

On TextBox Validating (Outside DataGridView) I am Bind data to Datagridview ComboBox column

                dtqttndtls = dssplrdtls.Tables[3];
                DataTable dtmerge = new DataTable();
                dtmerge.Columns.Add("cnsm_Id", typeof(Int32));
                dtmerge.Columns.Add("cnsm_Name");
                foreach (DataRow drmrg in dtqttndtls.Rows)
                {
                    DataRow drnew = dtmerge.NewRow();
                    drnew["cnsm_Id"] = drmrg["cnsm_Id"];
                    drnew["cnsm_Name"] = drmrg["cnsm_Name"];
                    dtmerge.Rows.Add(drnew);
                }
                dtCnsmbl.Merge(dtmerge);
                cnsmNm.DataSource = dtCnsmbl;
                cnsmNm.DisplayMember = "cnsm_Name";
                cnsmNm.ValueMember = "cnsm_Id";

After filling the Datagridviewcombobox column I am not able to clear the DataTable. I am new to Datagridview.

Answer 1

Hi i think instead of this

        dtCnsmbl = dsCnsmspplr.Tables[0]; 
        dtCnsmbl.Rows.Clear();
        cnsmNm.DataSource = dtCnsmbl;
        cnsmNm.DisplayMember = "cnsm_Name";
        cnsmNm.ValueMember = "cnsm_Id";

write this

       DataTable newdata = dsCnsmspplr.Tables[0].Clone();
       cnsmNm.DataSource = newdata;
        cnsmNm.DisplayMember = "cnsm_Name";
        cnsmNm.ValueMember = "cnsm_Id";