Intersoft Community - WebGrid Enterprise - Automatically Accept Batch Update

Automatically Accept Batch Update

Hans — Wed, 01 Aug 2012 06:28:02 GMT

Hello,

Basically the type of data source and method parameter doesn’t take any affect to my code. Could you provide a simple sample that replicate your issue? So i can help you investigate this issue further more.

I made a another simple to demonstrate how to delete multiple row using button and or context menu. In this sample, I use batch update to True.
I use AcceptAllChanges() function to apply all changes without click “Accept All Changes” button in WebGrid.

Here this snippet code in WebButton’s OnClientClick client side event:

function WebButton1_OnClientClick(controlId, parameter) {    var WebButton1 = ISGetObject(controlId);    var WebGrid1 = ISGetObject("WebGrid1");
    var checkedRows = WebGrid1.RootTable.GetCheckedRows();
    for (var i = 0; i < checkedRows.length; i++) {
        WebGrid1.RootTable.ToRowObject(checkedRows[i]).Delete();
    }
    WebGrid1.AcceptAllChanges();
    return true;
}

And I set a validation in WebGrid’s OnAddPendingChanges() client side event:

function WebGrid1_OnAddPendingChanges(controlId, table, rowChange) {
    var WebGrid1 = ISGetObject("WebGrid1");
    if (rowChange.RowState == "Deleted") {
        window.setTimeout(function () { WebGrid1.AcceptAllChanges(); }, 10);
    }
    return true;
}

Please have review on my sample. Thank you.

Regards,
Hans.

Automatically Accept Batch Update

adajani@najiasystems.com — Tue, 31 Jul 2012 12:30:16 GMT

- Same webgrid as above.

- I'm binding to an ObjectDataSource.

- Creating the columns dynamically in Server Side InitializeLayout event (I have 80+ columns).

- My delete method takes two paramters.

- No checkboxes

I want to be able to select as many columns (1 or more), right click to Delete from the ContextMenu or from an outside button on the page somewhere and delete all selected rows.

Automatically Accept Batch Update

Hans — Tue, 31 Jul 2012 05:58:51 GMT

Hello,

That supposedly doesn’t affect my code.

Could you provide me more information about your code/your scenario that you want to achieve?
Or could you provide me a simple sample that replicate your issue?

Perhaps I can help you to investigate your issue on my end.

Thank you.

Regards,
Hans.

Automatically Accept Batch Update

adajani@najiasystems.com — Mon, 30 Jul 2012 11:14:46 GMT

Hans,

I tried implementing the attached, but it did not work. The only difference I see in our code is I have 2 paramters for my delete function in my object data source. Does that affect it?

I can step through the JS code in my debugger and everything seems to work just fine, but the wor never gets deleted from the grid. I refresh the page to see if the changes go through but it doesn't. I also tried adding a refreshGrid() call, but that also didn't work.

Please advise. Thanks.

Automatically Accept Batch Update

Hans — Mon, 30 Jul 2012 03:52:35 GMT

Hello,

I made a simple sample that perhaps similar with your scenario.
I bind WebGrid to access data source control (Northwind.mdb and Shippers table).

I attached my sample. Please have review on my sample and let me hear your response.

Thank you.

Regards,
Hans.

Automatically Accept Batch Update

adajani@najiasystems.com — Fri, 27 Jul 2012 10:16:59 GMT

Yes I do.

How can I delete multiple rows without using Batch Update using "Delete Selection" ?

Automatically Accept Batch Update

Hans — Thu, 26 Jul 2012 23:59:17 GMT

Hello,

I’m glad to hear that you have achieved your goal.
Should you have further question, please do not hesitate to contact us.

Thank you.

Regards,
Hans.

Automatically Accept Batch Update

adajani@najiasystems.com — Thu, 26 Jul 2012 10:59:52 GMT

Hi Hans,

Thanks for the reply. This is not quite what I was going for, but I understand now what I am trying to achieve is not possible. My end goal was to be able to delete multiple rows at the same time without having to click "Accept Changes".

Now I set Batch Update to FALSE, and have a delete method specified in my ObjectDataSource. If I select multiple rows, and choose "Delete Selection", it only deletes one row. I'd like to be able to delete all selected.

Thanks.

Automatically Accept Batch Update

Hans — Mon, 23 Jul 2012 23:34:32 GMT

Hello,

Thank you for your code.

I’ve made a simple sample using your code. However, I don’t get any prompt when I try to apply changes.
I bind WebGrid with access data source control (Northwind.mdb database & Shippers table).

Please have a review on my sample & video, then let me hear your response.

Regards,
Hans.

Automatically Accept Batch Update

adajani@najiasystems.com — Mon, 23 Jul 2012 19:58:56 GMT

Hi,

I'd like to make the grid automatically accept batch update changes. My code is below. From the settings, it seems that it should, but it doens't. I always get the prompt in the status bar to accept pending changes. Everything deletes fine when I accept changes.

<ISWebGrid:WebGrid ID="myGrid" runat="server" Height="560px" Width="100%" UseDefaultStyle="true" EnableWebResources="Always"
                           DataSourceID="odsAccountLineList" CustomSchemaRetrieval="UseWebGrid">
            <RootTable GridLineStyle="NotSet" DataKeyField="account_line_id">
            </RootTable>
            <LayoutSettings DisplayDetailsOnUnhandledError="true"
                            InProgressUIBehavior="ChangeCursorToHourGlass" StatusBarVisible="true"
                            NewRowLostFocusAction="AlwaysUpdate"
			                RowLostFocusAction="AlwaysUpdate" 
                            AllowColumnMove="Yes"
			                AllowFilter="No" 
                            AllowGrouping="No" 
                            AllowSelectColumns="Yes" 
                            AllowSorting="No"
			                GroupByBoxVisible="false" 
                            AutoHeight="false" 
                            AutoWidth="true" 
                            PagingMode="None"
                            AllowEdit="Yes" 
                            AllowDelete="Yes"
                            AllowMultipleSelection="Yes"
                            UseRelativePositioning="true"
                            AllowBatchUpdate="true">
                <BatchUpdateSettings 
                    AutomaticObjectUpdate="true" 
                    AllowReviewChanges="false" 
                    AllowUndoChanges="false" 
                    NotifyOnLostFocus="false" 
                    PromptOnUndoAllChanges="false" 
                    PromptUnsavedChanges="false" />
                <AlternatingRowStyle CustomRules="text-overflow: ellipsis; overflow-x: hidden" BackColor="LightGray" Wrap="false" Font-Size="8pt" Font-Names="Arial Monospaced"></AlternatingRowStyle>
                <RowStyle CustomRules="text-overflow: ellipsis; overflow-x: hidden" BackColor="White" Font-Size="8pt" Wrap="false" Font-Names="Arial Monospaced"></RowStyle>
                <ClientSideEvents OnRowContextMenu="myGrid_OnRowContextMenu" OnColumnContextMenu="myGrid_OnColumnContextMenu" 
                    OnAfterInitialize="myGrid_OnAfterInitialize"/>
		    </LayoutSettings>
        </ISWebGrid:WebGrid>

Thanks.