Hello,

Thank you for using Infragistics forums!

The exception you receive is usually caused by improperly configured primary keys. Judging by the code you sent this is either caused by a mismatch between the PrimaryKey property and the key of the column it's supposed to be represented by (please, ensure nameof(LuItemType.ItemTypeId) returns "ItemTypeId" as that's the key for the column specified in the column collection) or by the PK not being resolvable by the schema generated for the model (it is generated from the column definitions). It could be helpful if you paste your GetGridData method so I can better understand what part of the entity the grid binds to. In any case these column definitions will expect an array of objects each having a property called "ItemTypeId" of type string. You can quickly check if the PK resolves correctly by using your browser's developer tools and inspecting one of the grid's rows. Each of them should have a data-id attribute with the same value as the record's ItemTypeId property.

I hope this helps!

Best regards,

Stamen Stoychev

So I've tried to get Martin's solution working as follows:

<script type="text/javascript">

$("#saveChanges").bind({
click: function () {
$("#grid1").igGrid("saveChanges");
}
});

fillProductNameLookup(lookupProductList);

function fillProductNameLookup(objectToFill) {
var colSettings = $("#grid1").igGridUpdating("option", "columnSettings");
var colSetting;
for (var i = 0; i < colSettings.length; i++) {
colSetting = colSettings[i];
if (colSetting.columnKey === "InspectionPeriodId") {
if (colSetting.editorType && colSetting.editorType === "combo") {
var ds = colSetting.editorOptions.dataSource;
var textKey = colSetting.editorOptions.textKey;
var valueKey = colSetting.editorOptions.valueKey;
var item;
for (var j = 0; i < ds.length; i++) {
item = ds[i];
objectToFill[item[valueKey]] = item[textKey];
}
}
break;
}
}
}

var lookupProductList = {};

fillProductNameLookup(lookupProductList);

function lookupProductName(productNumber) {
return lookupProductList[productNumber];
}
</script>

The problem I'm having though is that fillProductNameLookup(lookupProductList) is trying to run before the grid is initialised.  Currently I'm not using the loader (I'm using the CDN), but even if I was I don't know how I'd force this code to run after the mvc wrapper has completed?  Is there a "grid initialized" event I can wrap the fillProductNameLookup(lookupProductList) call in?

The column then gets its data as follows:

column.For(x => x.InspectionPeriodId).HeaderText("InspectionPeriod").FormatterFunction("lookupProductName");

Hi Stamen

I've tried to wire that in (as per code below), but it's not working because the datasource for the combo column is still empty at this point.  I've put a break point in my GetComboData() and it isn't called until the combo is dropped down for the first time.  Is there something I need to do to get it to eager load the data?  I tried adding a DataBind call in the comboEditorOptions but that didn't help.  Do you have an example of this that I could look at?

@(Html.Infragistics()
.Grid(Model)
.ID("grid1")
.PrimaryKey(nameof(LuItemType.ItemTypeId))
.UpdateUrl(Url.Action("UpdatingSaveChanges", "ItemType"))
.AutoGenerateLayouts(false)
.AutoCommit(true)
.Columns(column =>
{
column.For(x => x.ItemTypeId).HeaderText("ItemTypeId").DataType("number").Hidden(true);
column.For(x => x.ItemDesc).HeaderText("Description").DataType("string");
column.For(x => x.SafeWorkingLoad).HeaderText("SWL").DataType("string");
column.For(x => x.InspectionPeriodId).HeaderText("InspectionPeriod")/*.FormatterFunction("lookupProductName")*/;
})
.Width("600px")
.Height("500px")
.Features(features =>
{
features.Updating()
.EditMode(GridEditMode.Row)
.EnableDeleteRow(true)
.EnableAddRow(true)
.ColumnSettings(settings =>
{
settings.ColumnSetting().ColumnKey(nameof(LuItemType.ItemDesc))
.EditorType(ColumnEditorType.Text).Required(true).Validation(true);
settings.ColumnSetting().ColumnKey(nameof(LuItemType.SafeWorkingLoad))
.EditorType(ColumnEditorType.Text).Required(true).Validation(true);
settings.ColumnSetting().ColumnKey(nameof(LuItemType.InspectionPeriodId))
.EditorType(ColumnEditorType.Combo)
.ComboEditorOptions(options =>
{
options.DataSourceUrl(Url.Action("GetComboData", "ItemType"))
.TextKey(nameof(LuInspectionPeriod.InspectionDesc))
.ValueKey(nameof(LuInspectionPeriod.InspectionPeriodId))
.EnableClearButton(true)
.Mode(ComboMode.DropDown);
})
.Required(true).Validation(true);

});

features.Sorting().ColumnSettings(sorting =>
{
sorting.ColumnSetting().ColumnKey(nameof(LuItemType.ItemDesc))
.CurrentSortDirection("ascending").AllowSorting(true);
});

})
.AddClientEvent("rendered", "fillList()")
.DataSourceUrl(Url.Action("GetGridData", "ItemType"))
.DataBind()
.Render())
<br />
<input type="button" class="btn btn-success" id="saveChanges" value="Save Changes" />

<script type="text/javascript">

$("#saveChanges").bind({
click: function () {
$("#grid1").igGrid("saveChanges");
}
});

function fillList() {
fillProductNameLookup(lookupProductList);
}

// from https://ko.infragistics.com/community/forums/p/72892/370474.aspx#370474
function fillProductNameLookup(objectToFill) {
var colSettings = $("#grid1").igGridUpdating("option", "columnSettings");
var colSetting;
for (var i = 0; i < colSettings.length; i++) {
colSetting = colSettings[i];
if (colSetting.columnKey === "InspectionPeriodId") {
if (colSetting.editorType && colSetting.editorType === "combo") {
var ds = colSetting.editorOptions.dataSource;
var textKey = colSetting.editorOptions.textKey;
var valueKey = colSetting.editorOptions.valueKey;
var item;
for (var j = 0; i < ds.length; i++) {
item = ds[i];
objectToFill[item[valueKey]] = item[textKey];
}
}
break;
}
}
}

var lookupProductList = {};

function lookupProductName(productNumber) {
return lookupProductList[productNumber];
}
</script>

Sorry, there's a typo above, the client event is now set up as .AddClientEvent("rendered", "fillList") but still doesn't work.