[Solved] Concatenate displayed text in GridDropDownColumn from multiple database columns

[Soren Michelsen]

Hi,

In my database, I have three fields that I need displayed in one GridDropDownColumn:
Value: zipcode
Text: City (State Zip)

For example:
value: 98027
text: "Issaquah (WA 98027)"

So, basically, instead of setting the ListTextField property to "City", i need it to be a combination of City, State and Zip.

Any ideas, anyone?
Jeppe Jespersen
Denmark

[Princy]

Hello Jeppe,

Check out the following code to achieve the scenario:
aspx:

<telerik:GridDropDownColumn UniqueName="DropDownColumn" DataSourceID="SqlDataSource1"
 ListTextField="City" ListValueField="zipcode" DataField="City">
</telerik:GridDropDownColumn>

c#:

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item is GridEditableItem && e.Item.IsInEditMode)

{

GridEditableItem editItem = (GridEditableItem)e.Item;

RadComboBox combo = (RadComboBox)editItem["DropDownColumn"].Controls[0];

combo.ItemDataBound += new RadComboBoxItemEventHandler(combo_ItemDataBound);

}

}

void combo_ItemDataBound(object sender, RadComboBoxItemEventArgs e)

{

RadComboBoxItem item = (RadComboBoxItem)e.Item;

DataRowView dr = (DataRowView)e.Item.DataItem;

item.Text = item.Text + " ( " + dr["State"].ToString() + " " + dr["Zip"].ToString() + " ) ";

}

Thanks
Princy.

[Soren Michelsen]

Great, Thank you so much!

-jeppe