Multiple column data from from DB to multiplecolumncombo box

See more:

C#

C#4.0

Hi
I need to populate multiple columns from sql DB to MultipleColumnCombobox.

I have refered followed following link and and I am ale to populate the hard coded data to multicolumn combo box.

Multi Column ComboBox[^]

Now I would like to read the data from sql DB to combobox. I am able to do it but when i click on combo box the data from database appears for fraction of second and then disappears.

Not sure what is causing the problem.

Please help.

I have attached my code for reference

private void button1_Click(object sender, EventArgs e)
       {

           CreateDataTable();
           multiColumnComboBox1.Table = dtable;
           multiColumnComboBox1.DisplayMember = "DoctorName";
           multiColumnComboBox1.ColumnsToDisplay = new string[] { "DoctorID", "DoctorName" };
           button1.Enabled = false;

       }

       private void CreateDataTable()
       {
           dtable = new DataTable("Rock");
           //set columns names
           dtable.Columns.Add("Doctor ID", typeof(System.String));
           dtable.Columns.Add("Doctor Name", typeof(System.String));


           con.Open();
           SqlDataAdapter da = new SqlDataAdapter("SELECT DoctorID, DoctorName FROM DoctorTabl", con);

               dataset = new DataSet();
               da.Fill(dataset, "DoctorTabl");
               dtable = dataset.Tables["DoctorTabl"];

       }