Update more rows in one transaction (client side)

fabdellacorte — Tue, 01 Jun 2010 10:29:24 GMT

Thank you for the information

Update more rows in one transaction (client side)

Glayaar — Mon, 31 May 2010 22:54:16 GMT

In a multiple row update scenario, you will need to set some time before invoking another Update function call. Here is the snippet, using BindtoAccessDataSource.aspx provided sample, I add a client side function to update the first 3 row of data:

function EditRows()
{
    var grid = ISGetObject("WebGrid1");

    //Update first 3 row
    var maxLoop = 3;
    var idx = 0;

    var intervalObj = setInterval(function()
    {
        if (idx < maxLoop)
        {
            var selectedRow = grid.RootTable.GetRow(idx);
            var cells = selectedRow.GetCells();

            cells.GetNamedItem("ContactName").SetText(selectedRow.GetCell("ContactName").Text + " " + idx, true);
            cells.GetNamedItem("Region").SetText("Region #" + idx, true);

            selectedRow.Update(false);

            idx++;
        }
        else
        {
            clearInterval(intervalObj);
            intervalObj = null;
        }

    }, 500);
}

Another suggestion would be to use WebGrid BatchUpdate feature, by setting AllowBatchUpdate = "true" under LayoutSettings and invoking AcceptAllChanges after updating all the rows. Here is the snippet:

function EditRowsV2()
{
    var grid = ISGetObject("WebGrid1");

    //Update first 3 row
    for (var i = 0; i < 3; i++)
    {
        var selectedRow = grid.RootTable.GetRow(i);
        var cells = selectedRow.GetCells();

        cells.GetNamedItem("ContactName").SetText(selectedRow.GetCell("ContactName").Text + " " + i, true);
        cells.GetNamedItem("Region").SetText("Region #" + i, true);

        selectedRow.Update();
    }

    grid.AcceptAllChanges();
}

Update more rows in one transaction (client side)

fabdellacorte — Mon, 31 May 2010 10:35:50 GMT

Hi support,

in the client side by javascript, I have change more cell values of row for different rows and I need to do a bulk update of rows in asynchronous mode, is there a clue to do it ?

If I use the method row.Update(false) for the single row in the cycle 'for', only the first update works.

thanks in advance

regards

Fabrizio

Intersoft Community - WebGrid Enterprise - Update more rows in one transaction (client side)

Update more rows in one transaction (client side)

Update more rows in one transaction (client side)

Update more rows in one transaction (client side)