Dynamic RadGrid with DropDownColumn

[Allen]

I am creating a Dynamically built RadGrid. I have to do so because I am generating columns based on how many dates my sql query returns. I am placing the specific dates as header column groups. Under each date I am trying to create a dropdowncolumn that has a different datasource than the radGrid.
The problem is creating it dynamically. I thought about using an item template but how could I place a dropdown in the item template for each drop down that i need to create, which is two per date.  
How do i bind the datasource for the DropDownColumn from code behind when the entire grid is dynamically built.


for (int t = 0; t < datecount; t++)
        {
            int utacount = Convert.ToInt32(getDrill.Rows[t][3].ToString());

            for (int p = 0; p < datecount; p++)
            {

                GridDropDownColumn ddc = new GridDropDownColumn();

                int b = p + 1;

                ddc.UniqueName = "ddc" + p + s;
                if (p - 1 < utacount)
                {
                    string name = "uta" + p + s;
                    ddc.ColumnGroupName = name;
                    //ddc.DataField = "strStatus";
                    //ddc.ListTextField = "strStatus";
                    ////GridEditableItem editedItem = ddc as GridEditableItem;
                    ////GridEditManager editman = editedItem.EditManager;
                    ////GridDropDownColumnEditor editor = editman.GetColumnEditor(name) as GridDropDownColumnEditor;
                    ////editor.DataSource = getDrill;
                    ////editor.DataBind();

                }
                grid.MasterTableView.Columns.Add(ddc);
            }

            s++;
        }

[Allen]

I have tried onItemDataBound event as well but it requires Arguments and i am not sure how to send those from code behind.

I tried

grid.ItemDataBound = grid_itemDataBound();

I am not sure how to send the arguments that the event requires when i give the grid this

[Viktor Tachev]

Hi Allen,

In order to use the ItemDataBound event to populate the data in the DropDownList you need to attach a handler for the event.

RadGrid grid = new RadGrid();

grid.ItemDataBound += grid_ItemDataBound;

In the handler you could set the DataSource for the dropdown control. You could use a GridDropDownColumn or a GridTemplateColumn in your scenario. Note that when creating template columns in RadGrid programmatically you need to use the approach described in this article. If you need additional information on how to customize a GridDropDownColumn it is available in this article.

For convenience I am attaching a sample project illustrating how you could set the data source for a dropdown control in the ItemDataBound handler of RadGrid.

Regards,
Viktor Tachev
Telerik

[Gajanan]

Dear all,
My requirement is Bind the grid dynamic , and add the controls like Text Box And rad Como box at run time by Item value.
so far have done the control adding and now my grid is ready to take values from user , 
but when user selected value from rad combo box (dynamic added control in grid), and click the save button i cannot find the Rad Combo box 
pls suggest me the way how to get the values for dynamically added controls in Rad-grid on button click.
below are the steps i followed
1. Added Grid in Aspx. with Autogenerated Column = true
2. On Item created event added dynamic controls in Grid. 
3. bind the data to ad combo box (dynamic added control in grid) 
4. on save Button i have to save the selected values from rad combo box (dynamic added control in grid), to data base
in above step 1 to 3 are done , but step 4 making me trouble .

below is code for button click.
protected void btnSaveAll_Click(object sender, EventArgs e)
{
    Questionnaire MyQue = Questionnaire.getQuestionnaire(mQuestionnaireid); 
    ArrayList ColumnLst = GetColumnList();
                Dictionary<string,string> RowSplitValue = new Dictionary<string,string>();
                foreach (GridEditableItem Item in rgPivotQuestionnaireResult.MasterTableView.Items)
                {
                    foreach (GridColumn Column in rgPivotQuestionnaireResult.MasterTableView.RenderColumns)
                    {
                        if (ColumnLst.Contains(Column.UniqueName))
                        {
                            //RowSplitValue = new Dictionary<string, string>(Item.SavedOldValues[Column.UniqueName]);
                            if (Item[Column].Controls.Count > 0)
                            {
                                Control ItemControle= new Control();
                                ItemControle = Item[Column].Controls[0];
                                if (ItemControle is TextBox)
                                {
                                    TextBox TxtBx = (TextBox)Item[Column].Controls[0];
                                }
                                if (Item[Column].Controls.Count > 1)
                                {
                                    ItemControle = Item[Column].Controls[1];
                                    if (ItemControle is RadComboBox)
                                    {
                                        RadComboBox RCB = (RadComboBox)Item[Column].Controls[1];
                                          MyQue .Answervalue = RCB.SelectedValue;
                                    }
                                }
                            }
                        }
                    }
                }
   MyQue .Save();
}

[Viktor Tachev]

Hi Gajanan,

If you would like to customize the default editor for a column you should handle the CreateColumnEditor event for RadGrid. In the handler you can replace the default ColumnEditor with a different one. The approach is described in the following article.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/data-editing/grid-editors/custom-editors-extending-auto-generated-editors

Regards,
Viktor Tachev
Telerik