Is is possible to save both the Text and Value to separate database fields using a GridDropDownColumn?

[Mark]

I have grid that contains a GridDropDownColumn (data from a different table).  This uses a different value in the ListValueField than it does in the ListTextField.  The reason is because I need a less descriptive value for use as a QueryString later on.  I need to keep the descriptive text as well on the database for the record.  How can I save both values in my database using the single GridDropDownColumn?  Do I need to use code behind?  If so, what event needs to be used?

Thanks!

[Eyup]

Hi Mark,

You could access the updated Text and Value of the GridDropDownColumn using the OnItemCommand server side event and overwrite your database accordingly:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.PerformInsertCommandName || e.CommandName == RadGrid.UpdateCommandName)
        {
            if (e.Item is GridEditableItem && e.Item.IsInEditMode)
            {
                GridEditableItem editItem = e.Item as GridEditableItem;
                RadComboBox cmbBox = editItem["ColumnUniqueName"].Controls[0] as RadComboBox;

                string updatedText = cmbBox.SelectedItem.Text;
                string updatedValue = cmbBox.SelectedValue;
            }
        }
    }

Please check out the following article where GridDropDownColumn's specifications are described:
  Configure GridDropDownColumn

If you have further requirements, please elaborate some more on the issue. It would be best if you open a support ticket and send us your mark-up and the related code-behind. Thus, we will be able to further analyze the project and provide a proper approach.

Regards,
Eyup
the Telerik team

[Mark]

Ok.  Thank you very much, that worked perfectly.  Now, how would you go about placing the value of the selected item into another textbox on the grid as soon as the combobox has been used?  This is proving much more difficult than expected.

[Princy]

Hi Mark,

With reference to this documentation, when using DropDownColumn in Edit mode, you can save the selected value in a Session variable and then set that value for the label in ItemTemplate.Here is the sample code.
C#:

void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
 if (e.Item is GridEditableItem && e.Item.IsInEditMode)
 {
   GridEditableItem item = (GridEditableItem)e.Item;
   RadComboBox combo = (RadComboBox)item["GridDropDownColumn"].Controls[0];
  //populating the combobox
   if (Session["updatedValue"] != null)
    {
       combo.SelectedValue = Session["updatedValue"].ToString();
    }
 }
   if (e.Item is GridDataItem && !e.Item.IsInEditMode && Page.IsPostBack)
    {
      GridDataItem item = e.Item as GridDataItem;
      TextBox txt = (TextBox)item.FindControl("TextBox1");
      txt.Text = Session["updatedValue"].ToString();
    }
}

Thanks,
Princy.