Trying to use a griddropdowncolumn for state abbreviations

[Kathy]

This seems like something that would be fairly straightforward to do.  In my grid, I want to have the 2 letter state abbreviation show up as a gridbound column.  But, when you go to edit or create a new record, I want the state column to be a griddropdowncolumn.  I'm would like to use the autogenerated form for this, not have it be inline edit.  What's the best way to go about this?  Thanks.

[Marin]

Hi Kathy,

You can achieve this by using the GridDropDownColumn, as it is displayed as a simple label in normal mode and it shows the data in a dropdown when the grid switches to edit mode. You need to set its DataSourceID and DataFiled properties for the column to bind correctly. You can additionally configure the column by setting ListValueField, ListTextField. Here is a sample code:

<telerik:GridDropDownColumn DataField="CategoryID"
  DataSourceID="SqlDataSource1" HeaderText="Category"
  ListTextField="CategoryName"
  ListValueField="CategoryID" UniqueName="CategoryID">
</telerik:GridDropDownColumn>

SqlDataSource1 should contain the state abbreviations. And DataField should point to the relevant filed. You may find additional information on the GridDropDownColumn in this help topic and live demo.

Hope this helps.

Kind regards,
Marin
the Telerik team

[Harsh]

I am also using the GridDropDown column but the drop down list is not opening while in-line editing.I can see while debugging that the list controls has 3 rows but only the first row is shown during the inline editing.

[Princy]

Hello Harsh,

I am not quite sure about the scenario. Please take a look at the following Demo and make a double check with your code.
Grid / Column Types.

Thanks,
Princy.