[Solved] ForeignKey in Grid as DropDownList - Selection Problem

[Maciel]

I have a grid with a foreignKey control as DropDownList

columns.ForeignKey((o => o.Id), (IEnumerable)ViewData["Id"], "Id", "Text");

the grid editing mode is InCell

When I click in a grid and select the value for the first time, doesn't work, afterwards is works fine.

The similar case happened hear, but in WinForms:
http://www.telerik.com/community/forums/winforms/dropdownlist-and-listcontrol/first-selection-attempt-for-raddropdownlist-fails-afterwards-is-works-fine.aspx

I tried to find a solution, but nothing until now.

Thanks for your help.

[Petur Subev]

Hello Maciel,

I am not sure what exactly is the problem. Could you please elaborate what exactly goes wrong and if possible provide a small demo project so we can check the problem on our side and search for a solution?

Regards,
Petur Subev
the Telerik team

[Maciel]

Here it is.

I find a problem and a parcial solution.

The problem is when the Bound column with the property hidden(true) was added before the ForeignKey column.

When you change the order, adding the hidden Bound column after the ForeignKey column was worked fine.

Thanks for your support.

[Petur Subev]

Hello again Miciel,

Thank you for sending a sample project. I reproduced the problem you experience and it seems it is somehow related to the hidden column defined before the ForeignKey column. 
If you define your columns so the hidden one is not the first everything seems to be working fine.
e.g.

.Columns(columns =>
{
    columns.ForeignKey((o => o.Id), (IEnumerable)ViewData["Id"], "Id", "Text");
    columns.Command(commands =>
    {
        commands.Delete().ButtonType(GridButtonType.Text);
    });
    columns.Bound(o => o.Key).Hidden(true);
})

I will inform our Dev team for that issue. Also I updated your telerik points as a small sign of our appreciation.

Regards,
Petur Subev
the Telerik team

[Patrick]

We have the same issue.

I have downloaded the test project of Maciel and if you take out the Command column you have the same weird behavior.

<%= this.Html.Telerik().Grid<TelerikMvcApplication1.Models.ClassTest>()

    .Name("Test")

    .DataKeys(keys => { keys.Add(p => p.Id); })

    .ToolBar(commands =>

        {

            commands.Insert().ButtonType(GridButtonType.Text);

        })

    .DataBinding(dataBinding => dataBinding.Ajax()

        .Select("Select", "Home"))

    .Columns(columns =>

        {

 

            columns.ForeignKey((o => o.Id), (IEnumerable)ViewData["Id"], "Id", "Text");

 

        })

    .Pageable(p => p.PageSize(10))

    .Editable(editing => editing.Mode(GridEditMode.InCell))

    .KeyboardNavigation()

%>




We have the same problem. We would like to use the ForeignKey without COMMAND and having the FK in the first column. How can we fix that?

[Patrick]

Here is a third bug with this ForeignKey control:

If you set with HtmlAttributes a class you will have to double select like if you had a hidden field or if you doesn't have command in the row. very weird:

    <%= this.Html.Telerik().Grid<TelerikMvcApplication1.Models.ClassTest>()
        .Name("Test")
        .DataKeys(keys => { keys.Add(p => p.Id); })
        .ToolBar(commands =>
            {
                commands.Insert().ButtonType(GridButtonType.Text);
            })
        .DataBinding(dataBinding => dataBinding.Ajax()
            .Select("Select", "Home"))
        .Columns(columns =>
            {
 
                columns.ForeignKey((o => o.Item), (IEnumerable)ViewData["Id"], "Id", "Text").HtmlAttributes(new { @class="myCustomClass"});
                columns.Bound(o => o.Key).Hidden(true);
                columns.Command(commands =>
                {
                    commands.Delete().ButtonType(GridButtonType.Text);
                });
            })
        .Pageable(p => p.PageSize(10))
        .Editable(editing => editing.Mode(GridEditMode.InCell))
        .KeyboardNavigation()
    %>