I'm trying to use a combo in a grid as follows:
@(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.ItemDesc).HeaderText("Description").DataType("string"); column.For(x => x.SafeWorkingLoad).HeaderText("SWL").DataType("string"); column.For(x => x.InspectionPeriodId).HeaderText("InspectionPeriod"); }) .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.InspectionPeriodDesc)) .ValueKey(nameof(LuInspectionPeriod.InspectionPeriodId)) .Mode(ComboMode.DropDown); }) .Required(true).Validation(true); });
}) .DataSourceUrl(Url.Action("GetGridData", "ItemType")) .DataBind() .Render())
However, the combo isn't loaded with any data, so I'm seeing the Id of the row rather than the text description, and when I try to drop the list there's no data in it.The data source method is as follows:
public class ItemType : LookUpController<LuItemType> {
... SNIP ...
[ComboDataSourceAction] public ActionResult GetComboData() {return View(RsContext.LuInspectionPeriod.AsQueryable()); }
}
And the entity class looks like:
public partial class LuInspectionPeriod { public LuInspectionPeriod() { LiftingItem = new HashSet<LiftingItem>(); LuItemType = new HashSet<LuItemType>(); }
[Required] public int InspectionPeriodId { get; set; } [Required] public string InspectionDesc { get; set; } [Required] public int? InspectionPeriodDays { get; set; } [Required] public int? InspectionPeriodMonths { get; set; }
public virtual ICollection<LiftingItem> LiftingItem { get; set; } public virtual ICollection<LuItemType> LuItemType { get; set; } }
When I click on a the cell with the combo I get this error in the console:
jquery.js:9566 GET https://localhost:44307/ItemType/GetComboData?textKey=InspectionPeriodId&valueKey=InspectionPeriodId&toLower=1&_=1492017867793 500 (Internal Server Error)
Is there anything obviously wrong with how I've set this up?
In light of the answer on another question I've just added a column for the primary key column as follows:
@(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("string").Hidden(false); 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"); }) .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)) .Mode(ComboMode.DropDown); }) .Required(true).Validation(true); });
It's still not working, i.e. I can't edit the cells of any existing rows, and I can't drop the combo on the Add row, but I am getting a different error now:
Uncaught Error: The specified record or property was not found. Verify the criteria for your search and adjust them if necessary. at $.(anonymous function).(anonymous function)._getLatestValues (https://cdn-xat $.(anonymous function).(anonymous function)._getLatestValues (https://localhost:44307/lib/jquery-ui/jquery-ui.js:144:25) at $.(anonymous function).(anonymous function)._startEditForRow (https://cdn-na.infragistics.com/igniteui/2016.2/xxx/xxx/js/infragistics.lob.js:493:29009) at $.(anonymous function).(anonymous function)._startEditForRow (https://localhost:44307/lib/jquery-ui/jquery-ui.js:144:25) at $.(anonymous function).(anonymous function)._startEditForElement (https://cdn-na.infragistics.com/igniteui/2016.2/xxx/xxx/js/infragistics.lob.js:493:26680) at $.(anonymous function).(anonymous function)._startEditForElement (https://localhost:44307/lib/jquery-ui/jquery-ui.js:144:25) at $.(anonymous function).(anonymous function)._clickTrigger (https://cdn-na.infragistics.com/igniteui/2016.2/xxx/xxx/js/infragistics.lob.js:493:13512) at $.(anonymous function).(anonymous function)._clickTrigger (https://localhost:44307/lib/jquery-ui/jquery-ui.js:144:25) at HTMLTableCellElement.proxy (https://localhost:44307/lib/jquery/dist/jquery.js:496:14) at HTMLDivElement.dispatch (https://localhost:44307/lib/jquery/dist/jquery.js:5206:27)
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
Hi Stamen
Yes that definitely helped. So, the grid was stuck in read only mode because I'd incorrectly set the DataType of ItemTypeId to "string" rather than "number" (I'd actually originally set it to "int", which I keep accidentally doing, then changed to string to try and fix that).
Then I tried changing the GetComboData method to return a List<LuInspectionPeriod> rather than a Queryable and that fixed the data issue and the combo's list now contains data.
So, having solved that I'm still seeing the grid displaying the Id rather than the text InspectionDesc of the LuInspectionPeriod, despite now having set the TextKey to retrieve the description. Am I right in thinking this is the expected behaviour, because all the stuff with the combo only effects the cell when it is in edit mode? I'm used to the wingrid control that work differently to that.
I've seen this answer from Martin which suggests that's the case: https://www.infragistics.com/community/forums/p/72892/370474.aspx#370474? Is that still the recommended approach for showing the description field when the cell is not in edit mode? Is there an example of that using the Html Wrapper syntax?
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 = {};
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");