Foreign Key column editor help

[Bob]

I have a grid in which I set up a foreignkey column. The grid displays properly and shows the value in the column.

However, when I click in the cell to edit it, the dropdown displays the wrongly selected value and it also doesn't drop down... like it is disabled perhaps. 

I am using Ajax binding so I can do batch editing, if that makes and difference.

Any ideas?

I'm not sure if even this will fix the issue, because I need the drop down list to be filtered based on another field in the row of the grid. I didn't see any examples of this. Some type of ajax binding for the dropdown list is probably needed, but I'm not sure how to do that in this situation.

thanks,
BOb

[Unik]

Check in your Views/Shared/EditorTemplates if you have GridForeignKey.ascx.

It's the template and I upgrade from previous version and it was'nt there.

You can find it in program files/telerik etc...

For filtered i think nothing was built in for that.

Hope this help

[Daniel]

Hello,

Yes the GridForeignKey editor template is required when using the ForeignKey Column feature.
I attached a project which implements two cases:

1. Grid in Batch editing mode which uses a ForeignKey Column.
2. Grid in Batch editing mode with a ForeignKey Column which is filtered based on another field.
   
   

Don't hesitate to ask if you have any questions.

All the best,
Daniel
the Telerik team

[Bob]

Thanks... that helps much. Questions/issues.

1. How would I support more than 1 fk column in the grid when I am filtering the pick lists? This same code seems to be hit (selector returns an element) no matter which fk cell I am editing. I tried a few things but couldn't figure it out. 

2. Is there a way for me to attach a data- value to the dropdown list and access it in this JS so I can send it with the ajax request?

3. When the onedit fires for an added row the dataItem doesn't seem to contain the entered value in the field I need to get the filter value from. 

BOb

[Bob]

1. Ok, I figured out how to get the id of the dropdown list using $(".t-dropdown input", e.cell).attr("id"). So problem solved there.

2. Still would like to know how to do this. I can use HtmlAttributes but that gets added to the td rather than the input. I guess I could figure out how to drill up to the td and get it. Basically it is a parameter I want to pass to the action method. 

3. This seems to be working fine now. Not sure what was going on.

BOb

[Daniel]

Hi Bob,

The DropDownList is create dynamically, on-demand . Therefore,  there is no way to add a value to it that can be retrieved later. The table cell element could be used for that purpose. It can be retrieved directly from the OnEdit event argument's cell property.

Kind regards,
Daniel
the Telerik team

[Bob]

Thanks... that works perfectly.

BOb

[Rajesh]

Hi Daniel,

I have a related, though different issue. I need to trap the OnChange event for the drop down list itself (which is created when i try to edit a column bound using the ForeignKey method).

ForeignKeyColumn.OnChange --> I need to enable/disable certain cells in the row depending on the value selected by the user.

[Cris]

Hi Daniel,

In the attached project (in JustForeignColumnKey view) the rows are marked as dirty (red indicator) even you do not change the cell value (click on Category Id column and then leave the cell without changing anything).
Is there a way to prevent this behaviour ?

Thank you,
Cristian

[Daniel]

Hi,

The dirty indicator is added because the value returned from the DropDownList is string and the one in the model is number. In order to avoid this you could handle the OnSave event and parse the string back to a number when the ForeignKey field is edited e.g.

function Save(e) {
    if (e.values.CategoryID) {
        e.values.CategoryID =  parseInt(e.values.CategoryID);
    }
}

Regards,
Daniel
the Telerik team

[JORGE]

I´m sorry if I can´t help you. Could you help me please?
I´m trying with ForeignKey grid, but don´t work. Have you some example functional?
I´m following the example on the Telerik site, but don´t run whit me.

Tks a lot.

[Daniel]

Hello Jorge,

You can check the example attached to this thread. 

Regards,
Daniel
the Telerik team

[Martin Moesby]

Nothing happens, when I try to retrieve the attached example ?

[Martin Moesby]

Nevermind, apparently something was of with either the network I was on, or the computer i was using - file fethed and examined.

Thx