New MultiColumnComboBox?

[Keivan Kechmiri]

Hi

Where is/when can we get the same new feature MultiColumnComboBox as for example .Net Core?

 

[Marin Bratanov]

Hi Keivan,

You can do this by defining the templates of the RadComboBox and writing the data source query to target the desired fields of the data source in the ItemsRequested handler. You can find such an example in the following demo: https://demos.telerik.com/aspnet-ajax/combobox/examples/functionality/multicolumncombo/defaultcs.aspx.

Regards,
Marin Bratanov
Progress Telerik

[Keivan Kechmiri]

This won't work, what I need is the ability to search & filter on different colums.

A simple example:

I have a table with media (audio & video) and I have a field with the media type (1-audio 2-video). I need to be able to select/filter that I only whant for exampel videos (because a musicvideo can have the same title as a audio track) when a search for a title.

[Marin Bratanov]

Hello Keivan,

You can do this by crafting your database query in the appropriate way. Here is how this is done in the demo:

• we are examining the first combobox that has filtering enabled
• it fires the ItemsRequested event
• in that event, we set the appropriate query:

  protected void RadComboBox1_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e)
  {
      //get all customers whose name starts with e.Text
      string sql = "SELECT * from Customers WHERE ContactName LIKE '" + e.Text + "%'";
  
      SessionDataSource1.SelectCommand = sql;
      RadComboBox1.DataBind();
  }

 

Regards,
Marin Bratanov
Progress Telerik