Intersoft Community - WebGrid Enterprise - Batch Update mode not returning rows from previous page using PendingChanges property

Batch Update mode not returning rows from previous page using PendingChanges property

yudi — Thu, 08 Apr 2010 03:30:10 GMT

I enclosed one simple sample of WebGrid that shows how to sending data from client to server by invoking AddInput() method. The sample shows how to pass keyValue of “WebGrid1.GetChanges()[0].Row.KeyValue” to server. In server side event, OnBatchUpdate event, the keyValue is obtained and showed in alert action.

Please try to run the sample on your end and let us know whether it helps or not.

Batch Update mode not returning rows from previous page using PendingChanges property

dhavalv — Wed, 07 Apr 2010 10:24:51 GMT

var grid = ISGetObject("WebGrid1");
grid.GetChanges()[0].Row.NewProperty = grid.GetChanges()[index].Row.GetCells().GetNamedItem("[ColumnName]")

Doing the above action during the OnBeforeRequest client side event does not help. I need to have access to the entire corresponding WebGridRow object on Server side when doing Batch Update.

FYI: When i do your above specified code and try to access the .NewProperty before the BatchUpdate event is triggered for the server side update, it still gives me NULL.

Please help

Batch Update mode not returning rows from previous page using PendingChanges property

yudi — Mon, 29 Mar 2010 04:04:02 GMT

When you go to page 2, the .Row collection of WebGridRowChange object from changes that made in page 1 is available, but when you start to access each cell data of the corresponding row it will returns null. The reason why the cell data of row change in page 1 is no longer exist is because the element is also no longer exist, in this case is the row itself (assuming current page is page 2).

In order to keep the .Row collection of WebGridRowChange object from other page, you’ll need to do this manually by assigning a new property with the .Row collection before move to other page.

The code snippet below shows how to add a new property that can be used to store your own collection, in this case is the .Row collection.

var grid = ISGetObject("WebGrid1");
grid.GetChanges()[0].Row.NewProperty = grid.GetChanges()[index].Row.GetCells().GetNamedItem("[ColumnName]");

The “NewProperty is used to store Cell object of “ColumnName” column. You’ll need to do the assignment while the element still exist means before move to the other page.

Hope this helps.

Batch Update mode not returning rows from previous page using PendingChanges property

dhavalv — Fri, 26 Mar 2010 06:21:21 GMT

Hello,

Thanks for your reply. I cannot disable the paging feature as there are close to 5000 records in my grid, which I cannot show in a single page.

For your other question, I need to access each cell data of the row that has been modified. I was hoping to use the ".Row" property of the WebGridRowChange class, as that would allow me to implement batch update to my existing code with having to do any changes.

Kindly let me know a fix for this. Thanks

Batch Update mode not returning rows from previous page using PendingChanges property

yudi — Fri, 26 Mar 2010 03:55:56 GMT

I was able to repro the problem. It is not because the AllowAutoDataCaching being disabled, but caused by the paging feature. Please try to disable the paging feature and you’ll see that the problem no longer persists.

Could you please let me know in detail which properties of WebGridRowChange.Row object that you wish to access?

Batch Update mode not returning rows from previous page using PendingChanges property

dhavalv — Thu, 25 Mar 2010 14:48:10 GMT

Hello,

I am using Batch mode and using Automatic Paging, with AutoCaching=False in WebGrid 7. When I make some changes in Page 1 and go to Page 2 and make some more changes and then "Accept All Changes" from Page 2. Then on the Batch_Update event, the WebGridRowChange object, does not return the Row using the WebGridRowChange.Row property when the changes are from Page 1. I am getting the WebGridRowChange.Data property, but I need the WebGridRow object. Can you please help me out.

Is it because AutoCaching is switched OFF.

Thanks

Dhaval