Hello,

Thank you for the question and I apologize for the inconvenience.

I’ve made a simple sample that maybe similar with your current scenario. I bind the WebGrid to Northwind.mdb database and Shippers table.
In my sample, you could update CompanyName column’s value, based on WebCombo’s value.

I use SetText() method to update the selected row's cells (CompanyName) value.
And I use Update() method to update the selected row object.
I also set PersistRowChecker property of WebGrid to “True”. This makes the row checker is not being cleared during postback.

Here’s the example java script code how to update selected row in WebGrid:

var i = 0;var intervalObj;
function WebButton1_OnClientClick(controlId, parameter) {
    var WebButton1 = ISGetObject(controlId);
    var WebCombo1 = ISGetObject("WebCombo1");
    var WebGrid1 = ISGetObject("WebGrid1");
    var comboValue = WebCombo1.Value; // Get WebCombo Value
    var checkedRows = WebGrid1.RootTable.GetCheckedRows();
    if (checkedRows.length > 0) {
        intervalObj = setInterval(function () {
            if (!WebGrid1.IsInProgress) {
                if (i < checkedRows.length) {
                    var checkedRow = WebGrid1.RootTable.GetCheckedRows()[i];
                    var selectedRow = WebGrid1.RootTable.ToRowObject(checkedRow);
                    var cells = selectedRow.GetCells();
                    if (selectedRow.KeyValue != '') {
                        // update the selected row's cells value
                        cells.GetNamedItem("CompanyName").SetText(comboValue, true);
                        // update the selected row object
                        selectedRow.Update();
                    }
                    i++;
                }
                if (i >= checkedRows.length) {
                    clearInterval(intervalObj);
                    intervalObj = null;
                    i = 0;
                }
            }
        }, 5);
    }
    return true;
}

Please have a review on my sample as well and let me hear your response.

Thank you.

Regards,
Hans.

Hans,

Thanks for the code. I have made some changes to the code and it works fine (except for one small issue that I am facing).

function saveDecision() {
        var grid = ISGetObject("WebGrid1");
        var ddl = document.getElementById("<%= ddlDecision.ClientID %>");
        var checkedRows = grid.RootTable.GetCheckedRows();
        var ddlValue = ddl.options[ddl.selectedIndex].value;
        if (checkedRows.length > 0) {
            if (!grid.IsInProgress) {
                for (i = 0; i < checkedRows.length; i++) {
                    var checkedRow = grid.RootTable.GetCheckedRows()[i];
                    var selectedRow = grid.RootTable.ToRowObject(checkedRow);
                    var cells = selectedRow.GetCells();
                    if (selectedRow.KeyValue != '') {
                        // update the selected row's cells value
                        cells.GetNamedItem("Decision").SetText(ddlValue, true);
                        // update the selected row object
                        selectedRow.Update();
                    }
                }
                if (i >= checkedRows.length) {
                    i = 0;
                }
            }
        }
        return true;
    }

 I have removed the setInterval function from the code. I am not sure why do we need it. Please let me know what is the purpose of this function.

Also, though it is working fine, I am finding that a pop-up window opens in the grid that states "Are you sure you want to navigate away from the page?....." <attachment - error.jpg>

Please let me know how to take this out?

Hi,

Thank you for your reply and I’m sorry for the late response.

The setInterval() method calls a function or evaluates an expression at specified intervals (in milliseconds).
The setInterval() method will continue calling the function until clearInterval() is called, or the window is closed.
Or you could find more information about this method from another website.

If I remove the setInterval() method (from my sample), it can only apply changes in one row.
You could try to remove the setInterval() method (from my sample) and see the effect.

I apologize for the inconvenience.
I try to remove the setInterval() method. But unfortunately, I can’t replicate your issue on my end.

Could you tell me the step by step how to reproduce this issue?
Or if you don’t mind, could you provide me simple sample that replicate this issue?

Thank you.

Regards,
Hans.

Thanks Hans! I was able to solve the issue. I have used your code and made PromptUnsavedChanges="false" to make it work. 

Is there a way to change the Batch Update settings property at run time in javascript? Please let me know.

btw, I am marking your solution as the correct approach. It works absolutely grt! :) Thanks for the solution.

-Udayan

Hi,

I’m glad to hear that you’ve found a workaround for this issue.

Yes, there is a way to change the Batch Update through client side event (javascript).
For example, perhaps you could use OnUndoallChanges() or OnAcceptAllChanges().
You could see more information about our WebGrid’s client side event in our documentation.

Should you have further question, please do not hesitate to contact us.
I would be happy to help you again.

Regards,
Hans.