How to show title in multi-column combobox ,and I to refresh it whan I save new record?

Question

https://www.codeproject.com/Articles/19781/A-data-bound-multi-column-combobox

I used this example for my Combobox( com_Plan)，How to add column name on it ?

And then when I save new record how to refresh it ?

I try to call form load, but it is distorted.

 private void Form1_Load(object sender, EventArgs e)
        {
            Get_PlanNo(e,e);
           
        }

        private void Get_PlanNo(object sender, EventArgs e)
        {
            string sql = string.Format("SELECT   Plan_No, Footage, Pcs ,RecID FROM [VG1] WHERE   (LEFT(Plan_No, 1) = 'T')ORDER BY RecID DESC; ");
          
            com_plan.SelectedIndexChanged -= com_plan_SelectedIndexChanged;
            com_plan.DataSource = db.GetDataSet(sql).Tables[0];
            com_plan.DisplayMember = "Plan_No";
            com_plan.ValueMember = "Plan_No";
            com_plan.Text = "";
            com_plan.SelectedIndexChanged += com_plan_SelectedIndexChanged;

}

Please help, thank you so much.

Answer 1

I've not seen a clean control for this other than in third party libraries. The best I've seen has some issues from Code Project e.g. does not properly size columns and needed some tweaks.

• Original code
• Modified code
• Example project