GridDropDownColumn Edit

[etu]

Hi,

I little bit confused,  the problem is that i have some users , i am binding these user to Grid with datatable.In edit mode i want to change the selected user's role.I mean, role column must be dropdowncolumn and when i bind grid, dropdowncolumn must show the user's current roles.But in edit mode this column must show all the avaliable role types that are stored in database.I hope, i can explain it.Thank you.

[Princy]

Hi,

You can use a GridDropDownColumn which will help you achieve the required scenario. In the normal mode of the grid, the GridDropDownColumn displays data just as a GridBoundColumn whereas in the edit mode of the grid, the column displays all the available options in a dropdownlist.
aspx:

<telerik:GridDropDownColumn DataSourceID="SqlDataSource1" DataField="Users" ListTextField="Users" ListValueField="Users" HeaderText="Users" UniqueName="Users" DropDownControlType="RadComboBox">
   </telerik:GridDropDownColumn>

For more Information on column types refer this help link.
Thanks
Princy.

[etu]

Hi,

But i dont have any SourceId, i am populating data with dataTable from code.
And i am binding it on PageLoad.That's why, i confused.i can populate it with datatable.when it is in edit mode, how can i populate dropdowncolumn with new datas.

Regards,
Etu

[etu]

I solved it :), thank you very much.

[SeRiAlKiL]

Can you please post how you solved it? I am working on a similar thing

Thank you

[etu]

Hi, sorry for late responding,

On ItemDataBound event i wrote this code.

if (e.Item is GridEditableItem && e.Item.IsInEditMode)
        {
            //first reference the edited grid item
            GridEditableItem editedItem = e.Item as GridEditableItem;
            GridEditManager editMan = editedItem.EditManager;

            //reference the column editor which holds the dropdown list instance in the edit form
            GridDropDownColumnEditor editor = editMan.GetColumnEditor("RoleName") as GridDropDownColumnEditor;


            string selectedValue = editor.SelectedValue;
            // change the data source for ContactTitle with custom code here

            DataTable table = DatabaseHelper.GetCorprateUserRoles(showAdmins);

            editor.DataSource = table;
            editor.DataBind();
            editor.SelectedValue = selectedValue;


         
        }

[SeRiAlKiL]

Really thanks! I'll work on it now

[Ali]

I am binding the GridDropDownColumn (GDDC) in the ItemDataBound Event and it is working perfect. The problem is that when the grid is in display mode ony (NOT in EDIT nor in INSERT) I cannot see any values in this column. The reason is ofcourse that I am binding the GDDC in edit mode only as specified in your code. Please see that I am not using DataSourceID in the GDDC markup. I need to bind it through code.

Any help would be appreciated.

Ali

[Princy]

Hello Ali,

The GridDropDownColumn is designed to be used mainly with DataTables in order to easily map and generate their dropdown items values using the DataField/ListValueField/DataSourceID/ListDataMember values of the column. If you want to bind the dropdowncolumn in normal mode, you can try binding the Literal present in the GridDropDownColumn during normal grid mode as shown below.
cs:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem && !e.Item.IsInEditMode)
        {
            GridDataItem item = (GridDataItem)e.Item;
            Literal litrl = (Literal)item["ColumnUniqueName"].Controls[0];
            litrl.Text = DataBinder.Eval(item.DataItem, "DataFieldName").ToString();
        }
   }

Another suggestion is that, for custom objects collections or when you want to change the source of the dropdowncolumn dynamically, you can consider replacing the GridDropDownColumn with template column holding a DropDownList in its edit template.

Thanks
Princy.