[Solved] RADComboBox in a RadGrid using Linq

[B]

I have been able to make a RADComboBox work in a RADGrid using a template so able to change the value of a field. All this using LINQ.

Cannot make the control display 2 columns (the value to insert and its description) from the lookup table.

Any suggestions or samples available.

Brad

[Rosi]

Hi Brad,

Please, have a look at our online example - MultiColumn Combo.

Regards,
Rosi
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[B]

Rosi,
Hi. Thanks for the online sample. I have seen something similar in the tutorial.

Perhaps I need to be more specific about my problem. Using the Northwind database as an example:

1. Create a RADGrid using the PRODUCTS table
2. Convert the CATEGORYID field to a template and add a RADComboBox (displaying the Category ID and Name)

When selecting a new category for a product do you need to write code to update the PRODUCTS table with the new CATEGORYID.

Want to do this using LINQ.

Thanks
Brad

[rajoo12]

Hi,

I do require the same but NOT for LINQ.

Additionally: How to achieve the search for the same.

I have a Status column with states defined in Database as (0,1,2)
On Item data bound it will be changed to (Open,Working,Closed) for display in grid.
In this case user will try to search with text. Works fine if the search entry is either 0 or 1 or 2. But I need search for Open or Working or Closed. How to achieve this ?

Thanks in advance.

Regards,
Rajoo

[Rosi]

Hi all,

Please review the following examples:

Combo in Grid

Grid Filtered by Combo

Regards,
Rosi
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Curtis Robinson]

I have a single basic RadGrid control on a page that is used for different output requirements. Besides setting the event handlers, all grid properties and all column are define in codebehind. I am trying to add a RadCombobox to the grid that when in edit mode allows the user to either select an item from the grid or type an undetermined text.

I created two classes that implement the ITemplate interface: one for the ItemTemplate for a label and one for the EditItemTemplate for the RadCombobox. I modified the sample project provided in this thread but was not successful in getting it to work.

Could you please provide a revised sample project on how to implement a RadCombobox in a RadGrid using only codebehind where the binding and template definitions are not defined in the aspx?

[Rosi]

Hello Kelly ,

Please review the following KB article- Using RadComboBox with AutoComplete as a custom editor in RadGrid
For further reference you can review these online resources:
RadControls as grid custom editors
how to define custom column editor 

Regards,
Rosi
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Curtis Robinson]

Thanks Rosi for the reply,
As per the example I am still getting the below error. The  RadGridComboboxColumnEditor mentioned in the error is a class which inherits from GridDropDownColumnEditor.

The RadGRid column in which I wish to use the RadCombobox is defined in codebehind as a GridDropDownColumn. When I do a code walkthrough everthing seems fine, until the page is rendered.

Unable to cast object of type 'RadGridComboboxColumnEditor' to type 'Telerik.WebControls.GridDropDownListColumnEditor'.

[Yavor]

Hi Kelly,

Based on the information supplied, it is hard to determine the cause of the issue, although I suspect that you may be using different versions of the controls. In order to further trace the issue, it would be best if you open a formal support ticket, and send us the problematic code. We will review it locally, and get back to you with our findings.

Kind regards,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center