[Solved] GridDropDown column in edit mode

[Alyssa]

hi
how to bind a GridDropDown column in edit mode using a value from datatable.

[Princy]

Hi Alyssa,

Please try the following code snippet.

ASPX:

<telerik:GridDropDownColumn HeaderText="ShipCity" UniqueName="ShipCity" DataField="ShipCity"
    ListTextField="ShipCity" ListValueField="ShipCity" DataSourceID="SqlDataSource1">
</telerik:GridDropDownColumn>

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    //Populate in EditMode
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
        GridEditableItem edititem = (GridEditableItem)e.Item;
        GridEditManager editMan = edititem.EditManager;
        GridDropDownListColumnEditor editor = (GridDropDownListColumnEditor)(editMan.GetColumnEditor("ShipCity"));
        RadComboBox rComboBox = editor.ComboBoxControl;
        string selectedVal = DataBinder.Eval(edititem.DataItem, "ShipCity").ToString();
        DataTable table = GetRelatedRecords("SELECT ShipCity FROM [Orders]");
        editor.DataSource = table;
        rComboBox.DataSource = table;
        rComboBox.DataTextField = "ShipCity";
        rComboBox.DataValueField = "ShipCity";
        rComboBox.DataBind();
        rComboBox.SelectedValue = selectedVal;
    }
}

public static DataTable GetRelatedRecords(string query)
{
    SqlConnection conn = new SqlConnection(ConnString);
    SqlDataAdapter adapter = new SqlDataAdapter();
    adapter.SelectCommand = new SqlCommand(query, conn);
    DataTable myDataTable = new DataTable();
    conn.Open();
    try
    {
        adapter.Fill(myDataTable);
    }
    finally
    {
        conn.Close();
    }
    return myDataTable;
}

Hope this helps.Let me know if any concern.
Thanks,
Princy