GridView - Inline edit mode change value of cell not in edit mode

Hello,

As far as I see in your code, you are implementing a Data Item template. Would you please send me your ASPxGridView markup and code behind for further research? Also, clarify whether the "VP" is used as a key field. This will help me provide you with further recommendations.

Thanks,
Stanley

Hello,

Here is a snippet
VP is not a key!

[C#]
        settings.Columns.Add(columnSettings =>  
        {  
            columnSettings.Caption = "Zg. Meja";  
            columnSettings.FieldName = "ZgornjaMeja";  
            columnSettings.Width = 80;  
            columnSettings.ColumnType = MVCxGridViewColumnType.SpinEdit;  
            columnSettings.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;  
            columnSettings.CellStyle.HorizontalAlign = HorizontalAlign.Center;  
            columnSettings.EditorProperties().SpinEdit(p =>  
            {  
                p.NumberType = SpinEditNumberType.Integer;  
                p.FocusedStyle.BackColor = System.Drawing.Color.Yellow;  
                p.Style.HorizontalAlign = HorizontalAlign.Center;  
                p.SpinButtons.Visible = false;  
                p.SpinButtons.ClientVisible = false;  
                p.ValueChangedDelay = 0;  
  
                p.ClientSideEvents.NumberChanged = "SpinEdit_OnNumberChanged";  
                p.ShowOutOfRangeWarning = true;  
  
                //p.ValidationSettings.ErrorTextPosition = ErrorTextPosition.Bottom;  
                p.ValidationSettings.Display = Display.Dynamic;  
                p.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.Text;  
                p.ValidationSettings.SetFocusOnError = true;  
                p.ValidationSettings.ValidateOnLeave = true;  
            });  
        });

Hope this helps!

Thanks

Thank you for the clarification. You can find the whole list of batch editing client API methods here: ASPxClientGridViewBatchEditApi Members. So, you can use the GetCellValue or GetCellValueByKey method to get a cell's value. If you know the key field value, then use the second method. Otherwise, you will have to loop through rows to find the necessary cell's visible index. For example:

[JavaScript]
var rowCount = grid.GetVisibleRowsOnPage();  
            for (var i = 0; i < rowCount; i++) {  
                var myValue = grid.batchEditApi.GetCellValue(i, "VP");  
                //your code  
            }

Thanks,
Stanley

Thank you Stanley for your time.

I figure this out about an hour ago, and then I hit the wall again.
This would only work if I don't use paging ( SettingsPager.Mode is set to ShowAllRecords).

Otherwise it will only loop through the current page.
Last hour was spent trying to find the solution to loop through all rows?

Could you also provide the solution for this?

Thanks

Hello,
Thank you for the clarification. You are right, it is not possible to set values of hidden rows. I suggest you consider using one of the following approaches:

1. Use the "ShowAllRecords" mode as you mentioned earlier. If you do not have too many records in your data source, you should not face performance issues.
2. Adjust the SettingsPager.PageSize property so that the required rows are rendered in the browser.
3. Handle the client-side BeginCallback event handler, catch the callback request for batch updating, calculate the necessary values, and add them to the EventArgs customArgs collection. For example:

[JavaScript]
function onBeginCallback(s, e) {  
    if (e.command == ASPxClientGridViewCallbackCommand.UpdateEdit) {  
        //calculations  
        e.CustomArgs["yourValue"] = yourValue;  
    }  
}

[C#]
[ValidateInput(false)]  
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues<EditableProduct, int> updateValues, string yourValue) {  
    ...  
}

4. Get the required data from GridView's data source and then manually implement all CRUD commands on the server side in the corresponding action method for batch editing.

Thanks,
Stanley