How to programmatically populate a multicolumn combobox

[Gaston]

I am trying to programmatically populate a multicolumn combobox after user selected another customer from the previous combo box
this is the sample of the code.

01.private void RadMultiColumnComboBox3SelectedIndexChanged(object sender, EventArgs e)
02.       {
03.           string a;
04.           a = string.Format("{0}", radMultiColumnComboBox3.EditorControl.Rows[radMultiColumnComboBox3.SelectedIndex].Cells["customerID"].Value);
05.           Int32 b;
06.           Int32.TryParse(a, out b);
07.           radMultiColumnComboBox4.Enabled = true;
08.           OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/RoadRunnerDB.mdb");
09.           string cmdStr = string.Format("Select * FROM addressList WHERE customerID = {0}", b);
10.
11.           try
12.           {
13.               conn.Open();
14.               OleDbCommand cmd = new OleDbCommand(cmdStr, conn);
15.               OleDbDataReader reader = cmd.ExecuteReader();
16.               //fill the grid!??
17.           }
18.           catch (Exception ex)
19.           {
20.               MessageBox.Show(ex.Message);
21.           }
22.       }

[Dimitar]

Hello Gaston,

Thank you for writing.

You can load the data from the reader as follows:

radMultiColumnComboBox2.EditorControl.MasterTemplate.LoadFrom(reader);

Detailed information is available in the following article: Binding to DataReader.

Please let me know if there is something else I can help you with.

Regards,
Dimitar
Telerik

 

 

[Gaston]

Thank you it worked like a charm! :D