[Solved] EditFormSettings FormTemplate RadComboBox DataSource definition

[Dmitri]

I have an edit form inside of a grid and i need to set the data source for the RadComboBox to be populated from a LINQ query that runs on page load. I cant figure out how to do this:

The LINQ statement used is: tudc.Users.Select(f => f.Team).Distinct().ToArray();

                        <EditFormSettings EditFormType="Template">
                        <FormTemplate>
                            <table id="ET" cellpadding="1" cellspacing="0" width="100%" border="0" rules="none" style="border-collapse: collapse; background: white;">
                                <tr class="EditFormHeader"><td colspan="2">User Details</td></tr>
                                <tr>
                                   <td class="FieldName">Last Name:</td><td><telerik:RadTextBox runat="server" Skin="Office2010Blue" ID="rtb_LastName" Text='<%# Bind("Name_Last") %>' /></td>
                                </tr><tr>
                                   <td class="FieldName">First Name:</td><td><telerik:RadTextBox runat="server" Skin="Office2010Blue" ID="rtb_FirstName" Text='<%# Bind("Name_First") %>' /></td>
                                </tr><tr>
                                   <td class="FieldName">Username:</td><td><telerik:RadTextBox runat="server" Skin="Office2010Blue" ID="rtb_Username" Text='<%# Bind("Username") %>' /></td>
                                </tr><tr>
                                   <td class="FieldName">Password:</td><td><telerik:RadTextBox runat="server" Skin="Office2010Blue" ID="rtb_Password" TextMode="Password" Text='<%# Bind("Username") %>' /></td
                                </tr><tr>
                                   <td class="FieldName">Type:</td><td><telerik:RadComboBox runat="server" Skin="Office2010Blue" ID="rcb_Type" SelectedValue='<%# Bind("Type") %>' DataSource='<%# (new string[] {"Team Lead", "EDA", "Hybrid", "Admin"}) %>' /></td>
                                </tr><tr>
                                   <td class="FieldName">Team:</td><td><telerik:RadComboBox runat="server" Skin="Office2010Blue" ID="rcb_Team" SelectedValue='<%# Bind("Team") %>' DataSource='<%#?!?!?!?! WHAT GOES HERE %>' /></td>
                                </tr>
                            </table>
                        </FormTemplate>
                        </EditFormSettings>

[Dmitri]

Nevermind i found the solution

[Lak]

Hi Dmitri,
I am having the same problem. Could you please send some sample code?
Thanks.

[Shinu]

Hi,

Please take a look into the following code snippet to populate the RadComboBox.

C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
        GridEditableItem EditableItem = (GridEditableItem)e.Item;
        RadComboBox combo = (RadComboBox)EditableItem.FindControl("ComboBoxID");
        //you can bind the RadComboBox here..
    }
}

Please elaborate the scenario if it doesn't help.

Thanks,
Shinu.

[Lak]

Thanks Shinu.
I have one more issue, i need to show/hide couple of html tr tags based on the value selected from RadComboBox in the SelectedIndexChanged event. How can i do that?
Below is my code and is not working. tRow1 is coming up as null. On the html side, i set the id and runat=server properties to all the tr tags. Please help!

GridEditableItem editedItem = (sender as RadComboBox).NamingContainer as GridEditableItem;

RadComboBox cbo1 = (sender as RadComboBox).Parent.FindControl("cbo1") as RadComboBox;
string strSelectedText = cbo1.Text.ToString().Trim().ToUpper();

TableRow tRow1 = editedItem.FindControl("trId1") as TableRow;

if (strSelectedText == "JOHN")
{
//hide html tr's
 tRow1.Visible = false;
}
else
 tRow1.Visible = true;

[Shinu]

HI,

Try the following code.
C#:

protected void RadComboBox1_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
 {
        RadComboBox combo = (RadComboBox)sender;
        GridEditableItem item = (GridEditableItem)combo.NamingContainer;
        TableRow tr = (TableRow)item.FindControl("tr1");
}

Thanks,
Shinu.