Hi,
I had to implement custom delete using Delete button. But I am getting an error, can anyone help me on this. Here is the code.
@using Infragistics.Web.Mvc @using Microsoft.AspNetCore.Http @model IQueryable<RateManagement.Models.RateIdentification> <title>Rate Identification</title> <style type="text/css"> input.button-style { margin-top: 10px; } span.ui-iggrid-headertext { white-space: normal; text-overflow: ellipsis; word-break: break-word; font-size: 10pt !important; } .ui-iggrid-header { font-size: 10pt !important; } .ui-iggrid-footer { font-size: 10pt !important; } .ui-iggrid .ui-iggrid-tablebody td { font-size: 10pt; } .ui-iggrid .ui-iggrid-addrow td { font-size: 10pt; } .ui-iggrid .ui-iggrid-toolbar { font-size: 10pt; } .igx-grid__td span { white-space: nowrap !important; text-overflow: ellipsis !important; overflow: hidden !important; } .ui-iggrid tbody td { border-left: 1px solid #dadada; border-right: 1px solid #dadada; } /* .ui-igcombo-wrapper { width: 300px !important; font-size:12px !important; }*/ </style> <div style="padding:10px;"> @( Html.Infragistics() .Grid(Model) .ID("Grid") .Height("800px") .Width("100%") .DefaultColumnWidth("150px") .AutoGenerateColumns(false) .AutoGenerateLayouts(false) .PrimaryKey("PrimaryKey") .AutoCommit(false) .MergeUnboundColumns(true) .RenderCheckboxes(true) .Columns(column => { column.For(x => x.PrimaryKey).HeaderText("").Width("0px").Hidden(true); column.For(x => x.RateIdentification1).HeaderText("Rate Identification").Width("150px"); column.For(x => x.RateType).HeaderText("Rate Type").Width("70px"); column.For(x => x.AllocationPercentFlag).HeaderText("Allocation Percent Flag").Width("150px"); column.For(x => x.Otavalue).HeaderText("OTA Value").Width("100px").DataType("number"); }) .Features(feature => { feature.Updating() .StartEditTriggers(GridStartEditTriggers.DblClick) .EnableAddRow(false) .EnableDeleteRow(false) .EditMode(GridEditMode.Row) .ShowDoneCancelButtons(false) .EnableDataDirtyException(false) .ColumnSettings(cs => { cs.ColumnSetting().ColumnKey("PrimaryKey"); cs.ColumnSetting().ColumnKey("RateIdentification1"); cs.ColumnSetting().ColumnKey("RateType").EditorType(ColumnEditorType.Text); cs.ColumnSetting().ColumnKey("AllocationPercentFlag").EditorType(ColumnEditorType.Text); cs.ColumnSetting().ColumnKey("Otavalue").EditorType(ColumnEditorType.Numeric); }); feature.RowSelectors(); feature.Selection().Mode(SelectionMode.Row).MultipleSelection(true).AllowMultipleRangeSelection(true); feature.ColumnFixing() .ShowFixButtons(false) .FixingDirection(ColumnFixingDirection.Left) .ColumnSettings(cs => { cs.ColumnSetting().ColumnKey("RateIdentification1").AllowFixing(true); cs.ColumnSetting().ColumnKey("RateType").AllowFixing(false); cs.ColumnSetting().ColumnKey("AllocationPercentFlag").AllowFixing(false); cs.ColumnSetting().ColumnKey("Otavalue").AllowFixing(false); }); feature.Sorting().Type(OpType.Remote); feature.Paging().Type(OpType.Local); feature.Filtering().Type(OpType.Remote).Mode(FilterMode.Advanced).ColumnSettings(cs => { cs.ColumnSetting().ColumnKey("RateIdentification1").AllowFiltering(true); cs.ColumnSetting().ColumnKey("RateType").AllowFiltering(false); }); }) .DataSourceUrl(Url.Action("GetRateIdentification")) .UpdateUrl(Url.Action("SaveRateIdentification")) .DataBind() .Render() ) <div id="addingOptions" class="explorer2 adding-Options col-lg-12 d-flex flex-wrap flex-lg-nowrap mt-5 justify-content-between"> <div class="addNewRow addNewRow-option d-flex flex-wrap gap-2"> <label for="RowsToadd">Rows to Add</label> <input id="RowsToadd" maxlength="2" type="text" value="1" style="width:30px" onkeypress='javascript:return isNumber(event)' /> <input id="addRow" type="button" value="Add New Row" class="ButtonClass shadow-sm btn btn-primary border" /> <input id="selectRow" type="button" value="Select All Row" class="ButtonClass shadow-sm btn btn-primary border" /> <input id="copyRow" type="button" value="Copy Rows" class="ButtonClass shadow-sm btn btn-primary border" /> <input id="exportRow" type="button" value="Export" class="ButtonClass shadow-sm btn btn-primary border" /> @* <input type="button" id="saveChanges" class="changes-btn ButtonClass1 shadow-sm h-auto btn btn-success" value="Save Changes" />*@ <input id="saveRow" type="button" value="Save Changes" class="ButtonClass shadow-sm btn btn-primary border" disabled="true" /> <input type="button" id="undo" class="ButtonClass shadow-sm btn btn-primary border" value="Cancel Changes" /> @* <input type="button" id="redo" class="ButtonClass shadow-sm btn btn-primary border" value="Redo" />*@ <input id="deleteRow" type="button" value="Delete Rows" class="ButtonClass shadow-sm btn btn-primary border" /> <input id="cancelRow" type="button" value="Cancel Changes" class="ButtonClass1" onclick="CancelChanges()" /> </div> </div> </div> <script> var updates, lookupSecurity = [], loadingIndicator; let newRowID = null; function HandleGridCellUpdatedStart(evt, ui) { console.log(newRowID); if (ui.rowID != newRowID && ui.columnKey == "RateIdentification1") { //if not adding a row and the partner Name is trying to be updated, return right away return false; } } function editRowEnded(evt, ui) { if (ui.rowID == newRowID) { newRowID = null; } } function dataBound(evt, ui) { //alert('bound'); } $("#exportRow11").click(function () { //alert('hi'); $.ig.GridExcelExporter.exportGrid($("#Grid"), { fileName: 'CarType' }, { // The keys of the columns that will not be exported columnsToSkip: ["PrimaryKey"], }); }); $("#exportRow").on("click", function () { var currentdate = new Date(); var datetime = currentdate.getDate() + "/" + (currentdate.getMonth() + 1) + "/" + currentdate.getFullYear() + ":" + currentdate.getHours() + ":" + currentdate.getMinutes() + ":" + currentdate.getSeconds(); $.ig.GridExcelExporter.exportGrid($("#Grid"), { fileName: "CarType_" + datetime, // The keys of the columns that will not be exported columnsToSkip: ["PrimaryKey"] }, { cellExporting: function (e, args) { if (args.cellValue != null && args.cellValue instanceof Date) { var date = args.cellValue; date.setDate(date.getUTCDate()); date.setHours(date.getUTCHours()); args.xlRow.cells(args.columnIndex).value(date); } }, }); }); var isClicked = false; $("#Grid").on("iggridrowselectorsrowselectorclicked", function (evt, ui) { // Handle event if (!isClicked) { isClicked = true; setTimeout(() => { isClicked = false; }, 300); return; } }); $("#Grid").on("iggridupdatingdatadirty", function (event, ui) { $("#Grid").igGrid("commit"); updates = null; }); function selectedRowsCellsValue() { var rowId; var rows = $("#Grid").igGridSelection("selectedRows"); $.each(rows, function (ix, el) { rowId = el.element.attr("data-id"); var cellValue = $("#Grid").igGrid("getCellValue", rowId, "RateIdentification1"); alert(cellValue); }); } $(document).delegate("#Grid", "focusin", function (e) { if ($("#pasteHelper").length > 0) { return; } var container = $(document.body); var containerDiv = $("<div></div>") .css({ "position": "fixed", "top": -10000, "left": -10000 }); //create textarea for handling paste event. Text area will be transparent. var textArea = $("<textarea id='pasteHelper'></textarea>") .css({ "opacity": 0, "overflow": "hidden" }) .appendTo(containerDiv); containerDiv.appendTo(container); textArea.on("paste", pasteHandler); }).on('keydown', function (evnt) { //handle grid's keydown event var ctrl = evnt.ctrlKey, key = evnt.keyCode; if (ctrl && key == 86 || evnt.shiftKey && key == 45) // Ctrl-V || Shift-Ins { //on paste (Ctrl+V) move focus to textarea $("#pasteHelper").focus(); } }); //paste event handler for the textArea. function pasteHandler(event) { var data; //get clipboard data - from window.cliboardData for IE or from the original event's argumets. if (window.clipboardData) { window.event.returnValue = false; data = window.clipboardData.getData("text"); } else { data = event.originalEvent.clipboardData.getData('text/plain'); } //process the clipboard data var processedData = ProcessData(data); //alert(processedData); AddRecords(processedData); } function ProcessData(data) { var pasteData = data.split("\n"); for (var i = 0; i < pasteData.length; i++) { pasteData[i] = pasteData[i].split("\t"); // Check if last row is a dummy row if (pasteData[pasteData.length - 1].length == 1 && pasteData[pasteData.length - 1][0] == "") { pasteData.pop(); } //remove empty data if (pasteData.length == 1 && pasteData[0].length == 1 && (pasteData[0][0] == "" || pasteData[0][0] == "\r")) { pasteData.pop(); } } return pasteData; } function AddRecords(processedData) { var columns = getVisibleColumns(); //alert(currentCell); var fRowID; $('#saveRow').prop('disabled', false); for (var i = 0; i < processedData.length; i++) { var curentDataRow = processedData[i]; var rowData = {}; for (var j = 0; j < columns.length; j++) { var currentCell = curentDataRow[j]; var colKey = columns[j].key; if (colKey == "CreatedDate" || colKey == "CreatedEmployee" || colKey == "LastChangedDate" || colKey == "LastChangedDate") { currentCell = '' } rowData[colKey] = currentCell; } $("#Grid").igGridUpdating("addRow", rowData); } } function getVisibleColumns() { var visibleCols = []; var columns = $("#Grid").igGrid("option", "columns"); $(columns).each(function () { //if (this.hidden !== true) { visibleCols.push(this); //} }); return visibleCols; } //Bind after initialization $(document).delegate("#Grid", "iggridupdatingeditcellstarting", function (evt, ui) { cellToCompareVal = ui.owner.grid.getCellValue(ui.rowID, "CreatedDate"); // alert($(ui.owner.grid.getCellValue(ui.rowID, "CreatedDate")).length); if ((ui.columnKey == "RateIdentification1") && typeof (cellToCompareVal) !== "undefined" && $(ui.owner.grid.getCellValue(ui.rowID, "CreatedDate")).length > 0) { $('#saveRow').prop('disabled', false); return false; } } ); // ********************************************** $(document).on("iggridupdatingeditcellstarting", "#Grid", function (evt, ui) { // alert(ui.rowID); var regex = new RegExp(`^[A-Z0-9]{1,12}\\|[A-Z0-9]{1,4}\\|[0-9]{2}\\/[0-9]{2}\\/[0-9]{4}$`); // if the regex check returns true - the record has compsite key with the following format: ############|####|####-##-## // meaning that this is not a newly added row, since the composite key of newly added rows do not contain a date format at the end if (regex.test(ui.rowID) && (ui.columnKey == "RateIdentification1")) { $('#saveRow').prop('disabled', false); return false; } }); function isNumber(evt) { var iKeyCode = (evt.which) ? evt.which : evt.keyCode if (iKeyCode != 46 && iKeyCode > 31 && (iKeyCode < 48 || iKeyCode > 57)) return false; return true; } $("#saveRow").bind({ click: function (e) { alert('save'); $("#Grid").igGridUpdating("endEdit", true, true); $("#Grid").igGrid("saveChanges", function success() { $('#txtMessage').css('background-color', 'LightBlue').css('color', 'DarkBlue').css('font-weight', 'bold').css('font-family', 'Courier New'); $("#Grid").igGrid("dataBind"); }, function error(jqXHR, textStatus, errorThrown) { //alert(JSON.parse(jqXHR.responseText).ErrorMessage); if (JSON.parse(jqXHR.responseText).ErrorMessage.contains("All")) { $('#txtMessage').css('background-color', 'LightBlue').css('color', 'DarkBlue').css('font-weight', 'bold').css('font-family', 'Courier New'); $("#Grid").igGrid("dataBind"); } else { $('#txtMessage').css('background-color', 'DarkRed').css('color', 'White').css('font-weight', 'bold').css('font-family', 'Courier New'); } txtMessage.value = JSON.parse(jqXHR.responseText).ErrorMessage; }); } }); function toggleAction(isSaved) { // actionToggled = true; this.event.stopPropagation(); $("#Grid").igGridUpdating("endEdit", isSaved, true); //actionToggled = false; } function CancelChanges() { //alert('hi'); $("#Grid").igGrid("rollback"); $("#Grid").igGrid("commit"); // $("#gridAccountCarType").igGrid("dataSourceObject", returnData).igGrid("dataBind"); $("#Grid").igGrid("dataBind"); txtMessage.value = ""; $('#txtMessage').css('background-color', 'LightBlue').css('color', 'DarkBlue').css('font-weight', 'bold').css('font-family', 'Courier New'); } // process events of buttons $("#deleteRow").igButton({ labelText: $("#deleteRow").val(), click: function (e) { var rowId; var checkstr = confirm('Are you sure you want to delete row(s)?'); if (checkstr == true) { $('#saveRow').prop('disabled', false); var rows = $('#Grid').igGridSelection('selectedRows'); console.log(rows); $.each(rows, function (ix, el) { rowId = el.element.attr("data-id"); console.log(rowId); $("#Grid").igGridUpdating("deleteRow", rowId); console.log('completed'); }); } else { alert('false'); return false; } } }); //$.each(rows, function (ix, el) { // rowId = el.element.attr("data-id"); // //alert(rowId); //} // //var rowIndex = $("#rowSelect").igNumericEditor("option", "value"), // // tr = $("#gridAccountCarType").igGrid("rowAt", parseInt(rowIndex - 1)), pkValue; // // //alert(rowIndex); // //if (!tr) return; // //pkValue = parseInt($(tr).attr("data-id")); // //alert(rowId); // $("#gridAccountCarType").igGridUpdating("deleteRow", 1); //} // } //}); $("#cancelRow").on('igbuttonclick', function (e, args) { updates = $.extend({}, grid.data('igGrid').pendingTransactions()); $.each(updates, function (index, transaction) { grid.igGrid("rollback", transaction.rowId, true); }); //$("#redo").igButton("option", "disabled", false); //$("#undo").igButton("disable"); //$("#saveChanges").igButton("disable"); return false; } ); //$("#cancelRow").igButton({ // labelText: $("#cancelRow").val(), // click: function (e) { // $('#saveRow').prop('disabled', true); // var ds = new $.igGrid.DataSource({ // dataSource: gridObject // }); // // alert(ds); // $("#Grid").igGrid("option", "dataSource", ds); // //$("#gridAccountCarType").igGrid("dataSourceObject", returnData).igGrid("dataBind"); // } //}); $("#selectRow").igButton({ labelText: $("#selectRow").val(), click: function (e) { var $grid = $("#Grid"); var rows = $grid.igGrid("allRows"); var rowId; if ($("#selectRow").val() == "Select All Row") { document.getElementById("selectRow").value = "Unselect All Row"; // Loop through each row in the grid. $.each(rows, function (index, row) { $grid.igGridSelection('selectRow', index); }); } else if ($("#selectRow").val() == "Unselect All Row") { document.getElementById("selectRow").value = "Select All Row"; // Loop through each row in the grid. $('#Grid').igGridSelection('clearSelection'); } } }); $("#unselectRow").igButton({ labelText: $("#unselectRow").val(), click: function (e) { $('#Grid').igGridSelection('clearSelection'); var $grid = $("#Grid"); var rows = $grid.igGrid("allRows"); var rowId; // Loop through each row in the grid. $.each(rows, function (index, row) { rowId = $(row).attr("data-id"); }); } }); $("#copyRow").igButton({ labelText: $("#copyRow").val(), click: function (e) { $('#saveRow').prop('disabled', false); var rows = $('#Grid').igGridSelection('selectedRows'); let i = 0; $.each(rows, function (ix, el) { rowId = el.element.attr("data-id"); let pk = $("#Grid").data('igGrid').dataSource._data.length + 1 + i; var rowObj = { "PrimaryKey": pk, "RateIdentification1": $("#Grid").igGrid("getCellValue", rowId, "RateIdentification1"), "RateType": $("#Grid").igGrid("getCellValue", rowId, "RateType"), "AllocationPercentFlag": $("#Grid").igGrid("getCellValue", rowId, "AllocationPercentFlag"), "Otavalue": $("#Grid").igGrid("getCellValue", rowId, "Otavalue"), }; i = i + 1; $("#Grid").igGridUpdating("addRow", rowObj); }); } }); $("#addRow").igButton({ labelText: $("#addRow").val(), click: function (e) { $('#saveRow').prop('disabled', false); if (RowsToadd.value == "") { RowsToadd.value = 1; } else if (RowsToadd.value > 50) { RowsToadd.value = 50; } for (var i = 0; i < RowsToadd.value; i++) { let pk = $("#Grid").data('igGrid').dataSource._data.length + 1 + i; var rowObj = { "PrimaryKey": pk, "RateIdentification1": '', "RateType": '', "AllocationPercentFlag": '', "Otavalue": '', }; $("#Grid").igGridUpdating("addRow", rowObj); } } }); $(document).on("iggridrowselectorsrowselectorclicked", "#Grid", function (evt, ui) { // gets the keys of the columns which are set to be read only var readOnlyColumnsKeys = $("#Grid").igGridUpdating('option', 'columnSettings').filter(setting => setting.readOnly).map(setting => setting.columnKey); // gets the currently selected record // please keep in mind that ui.rowKey is a string, so if your primary keys are numbers you should convert it to number as in the following line var record = $("#Grid").igGrid("findRecordByKey", +ui.rowKey); // creates an array of objects that contain the key of the column that is read only and the value var readOnlyColumnsKeysAndValues = []; readOnlyColumnsKeys.forEach(key => { readOnlyColumnsKeysAndValues.push({ columnKey: key, value: record[key] }); }); // creates a Nested Blocks Template var template = '{{each ${items}}}' + '<tr><td><b>${items.columnKey}:</b></td>' + '<td>${items.value}</td></tr>' + '{{/each}}'; var result = $.ig.tmpl(template, { items: readOnlyColumnsKeysAndValues }); // $('#resultTable').html(result); // $("#dialog").igDialog("open"); }); $(document).on("iggridupdatingeditrowended", "#Grid", function (evt, ui) { var editedRowElement = $("#Grid").igGrid("rowById", ui.rowID); var allRows = $("#Grid").igGrid("rows"); var editedRowElementIndex = allRows.index(editedRowElement); // alert('ggg'); $("#Grid").igGridUpdating("updateRow", ui.rowID, { Index: editedRowElementIndex }); //$("#gridAccountCarType").igGridUpdating("addRow", ui.rowID, {Index: editedRowElementIndex}); }); </script>
public partial class RateIdentification :{ public int PrimaryKey { get; set; } public string RateIdentification1 { get; set; } public string RateType { get; set; } public string AllocationPercentFlag { get; set; } public short Otavalue { get; set; } }
{"PrimaryKey":10001,"RateIdentification1":"19U","RateType":"F","AllocationPercentFlag":"N","Otavalue":0}{"PrimaryKey":10002,"RateIdentification1":"22U","RateType":"F","AllocationPercentFlag":"N","Otavalue":0}
I am getting at Delete Row button click- Uncaught Error: The specified record or property was not found. Verify the criteria for your search and adjust them if necessary.
Hello Indra,
Thank you for the provided code and descriptive information.
I have been looking into your question and since the described scenario refers to the delete button that you implement and the function to delete rows, my focus was on the grid, the implementation of the delete button and the function that is executed on click event.
With the igGrid everything seems to be as expected and as it should be implemented, the same applies to the creation of the delete button. On the other hand, after trying your code I was also able to reproduce the described behavior and not being able to delete a row from the grid. What I assumed and changed in the code is the taking of the id of the row (primary key) and instead of the attribute of the element for each iterated row I took its id directly with the el.id property.
rowId = el.element.attr("data-id");
rowId = el.id;
What I suggest is to change this logic of taking the row id. After that everything worked as expected and now I am able to delete rows form the igGrid.
$("#deleteRow").igButton({ labelText: $("#deleteRow").val(), click: function (e) { var rowId; var checkstr = confirm('Are you sure you want to delete row(s)?'); if (checkstr == true) { var rows = $('#Grid').igGridSelection('selectedRows'); $.each(rows, function (ix, el) { rowId = el.id; $("#Grid").igGridUpdating("deleteRow", rowId); }); } else { alert('false'); return false; } } });
The described scenario could be observed here:
In addition, I have prepared small sample illustrating this behavior which could be found attached here. Please test it on your side and let me know how it behaves.
4188.igGridDeleteButton.zip
If you require any further assistance on the matter, please let me know.
Regards,
Georgi Anastasov
Entry Level Software Developer
Infragistics
Yes after changing to id it worked. Will do further and get back to you if any issue.
This rowId = el.id did not get any error, but could not delete the row in the backend. Because I am generating the Primary key on the fly and not retrieving from the db table. I need RateIdetification1 key to delete the row from the table.
I used something like this
rowId=el.id; var cellValue = $("#Grid").igGrid("getCellValue", rowId, "RateIdentification1"); console.log(cellValue); $("#Grid").igGridUpdating("deleteRow", cellCarTypeValue);
The specified record or property was not found. Verify the criteria for your search and adjust them if necessary.
Got the above error.
Thanks
Indra
What I understand from the information provided is that you have a function to add and delete rows, and when adding, you generate dynamically primary keys, then you immediately delete this line after adding, or you do not delete it immediately, but after a while when selecting and deleting with a button, provided me more information about it.
However, with only these provided functions there is no way to get to the source of this behavior, I would ask you to provide a sample with all the code from the view to initialize the grid, which properties and events you handle and the other functions you use, since this example of yours is about your custom logic that you use.
In order to ensure that the described scenario is addressed correctly, I will need some additional information regarding your scenario. Could you please answer the following questions:
This information is going to be highly appreciated and will help me in my further investigation.
As a first approach, what I could give you as a guideline for now is after you add the rows in the grid and you have success from the api and you have also added the rows in the database, it is good to rebind the grid so that the new rows are bound in the igGrid and are visualized in it with the correct values from the database. Then you could try your previous approach to deleting a row.
The second approach that I could give you as a guideline is, as you said yourself, the row key (rowID) by which the given row is deleted was the primary key when adding, and not the value of the cell itself, which is always the row key (rowID). To delete a row from the igGrid, the row key (rowID) of this row is required, in fact the exact cell value that is in the column marked as primary key during the initialization of the igGrid. Make sure that you delete the given row by its row key (rowID), which is the value from the cell of the primary key column, and not delete it by another value.
However, keep I mind that having a working sample on my side, which I can debug, is going to be very helpful in finding the root cause of this behavior.
Thank you for your cooperation.
Hope you are doing fine. I having some issue i.e. I added row and then deleted the row immediately. I have primary key which is generating dynamically. So while adding I had no issue. But while deleting, the row key is the primary key and not actual cell value. I need the cell value to delete the row. Please suggest me how to resolve this. Here is the code snippet.
this is addrow
$(rowsSelect).each(function () { var rowId = $(this).closest('tr').attr('data-id'); var currentRow = $(this).closest("tr"); let date = new Date(); let dateTimeNow = toString(date.getFullYear(), 4) + '_' + toString(date.getMonth() + 1, 2) + '_' + toString(date.getDate(), 2) + '__' + toString(date.getHours(), 2) + '_' + toString(date.getMinutes(), 2) + '_' + toString(date.getSeconds(), 2) + '_' + toString(date.getMilliseconds(), 3); let pk = $("#Grid").igGrid("getCellValue", rowId, "PrimaryKey") + "|" + i + dateTimeNow var rowObj = { "PrimaryKey": pk, "RateIdentification1": $(this).closest('tr').attr('data-id'), "RateType": currentRow.find("td:eq(0)").text(), }; i = i + 1; $("#Grid").igGridUpdating("addRow", rowObj); });
My Delete
$("#deleteRow").igButton({ labelText: $("#deleteRow").val(), click: function (e) { var checkstr = confirm('Are you sure you want to delete row(s)?'); if (checkstr === true) { //check if there is an array to delete all selected wors if (rowKeys.length > 0) { $.each(rowKeys, function (ix, el) { //make sure before delete to clear the selection $("#Grid").igGridSelection("clearSelection"); $("#Grid").igGridUpdating("deleteRow", el); $('#saveRow').prop('hidden', false); $('#cancelRow').prop('hidden', false); }); } else if (rowKey !== '') { //check if there is only one row $("#Grid").igGridSelection("clearSelection"); $("#Grid").igGridUpdating("deleteRow", rowKey); $('#saveRow').prop('hidden', false); $('#cancelRow').prop('hidden', false); } else { //else there is no selected rows just the button is clicked alert('No rows selected!'); } rowKeys = []; rowKey = ''; } else {
return false; } } });
save row:
$("#saveRow").bind({ click: function (e) { $("#Grid").igGridUpdating("endEdit", true, true); $("#Grid").igGrid("saveChanges", function success() {
}, function error(jqXHR, textStatus, errorThrown) { //alert(JSON.parse(jqXHR.responseText).ErrorMessage); if (JSON.parse(jqXHR.responseText).ErrorMessage.contains("Success")) { $('#txtMessage').css('background-color', 'LightBlue').css('color', 'Gray').css('font-weight', 'bold').css('font-family', 'Courier New'); // hide the buttons debugger; $("#Grid").igGrid("commit"); $('#saveRow').prop('hidden', true); $('#cancelRow').prop('hidden', true); $("#Grid").igGrid("allTransactions").pop(); var rows = $("#Grid").igGrid("allRows"); } else { $('#txtMessage').css('background-color', 'DarkRed').css('color', 'White').css('font-weight', 'bold').css('font-family', 'Courier New'); } txtMessage.value = JSON.parse(jqXHR.responseText).ErrorMessage; }); }
});
Please let me know if you need anything. I am not doing the re-bind once api returns the success. Is that the problem?
What I wanted to point out and clarify is that it is recommended that the primary key that is set to the PrimaryKey property of the grid is the same primary key with which you identify the records in your database. Thus, when you delete a row in the grid, you will delete it with the deleteRow method to which you pass the rowId, which is actually the primary key of the grid, thus you will delete a row from the grid and you will be able to delete it using the same primary key from the database too.
Maybe that's why you experienced this described behavior of the grid because your primary key was set on another property from your model and not the essential one that corresponds to the primary key from the database.
However, I'm glad you were able to find a solution.
Thank you for using Infragistics components and for your cooperation.
Solved my problem