Intersoft Community - WebGrid Enterprise - Update webgrid data from outside the webgrid

Update webgrid data from outside the webgrid

Hans — Thu, 12 Jul 2012 21:50:20 GMT

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.

Update webgrid data from outside the webgrid

UPratap@dow.com — Thu, 12 Jul 2012 02:23:00 GMT

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

Update webgrid data from outside the webgrid

Hans — Wed, 11 Jul 2012 22:26:20 GMT

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.

Update webgrid data from outside the webgrid

UPratap@dow.com — Tue, 10 Jul 2012 04:44:03 GMT

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?

Update webgrid data from outside the webgrid

Hans — Mon, 09 Jul 2012 03:17:18 GMT

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.

Update webgrid data from outside the webgrid

UPratap@dow.com — Fri, 06 Jul 2012 15:51:33 GMT

Hello,

I have a drop-down list outside the webgrid. The webgrid has two columns -

a) Decision (edittype = dropdownlist)

b) Checkbox Column

Scenario: The users want to check multiple check boxes in the grid, then use the drop-down list (which is outside the webgrid) to make a selection, click on a button next to the drop-down.

Expectation : The Decision column will show the value selected from the dropdown. And refreshes the data in the webgrid.

What is happening : The data is updated at the back-end in the database, but the grid is not showing the refreshed data. On rt clicking + Refresh, the new data is shown.

What I want - Is there a way to refresh the webgrid on the button click event once the data is written back to the database? I tried WebGrid1.ClientAction.Refresh in btn_Click event but its not refreshing the grid. i also tried WebGrid1.ClientAction.InvokeScript("ISGetObject('" + WebGrid1.ClientID + "').Refresh();") but it doesnt work.