Intersoft Community - WebGrid Enterprise - Get row count in SmartBatchUpdateScenario

Get row count in SmartBatchUpdateScenario

hermancordes@gmail.com — Thu, 08 Apr 2010 03:20:00 GMT

Nice solution, stupid I didn't realise this was an option too. Thanks!!

Get row count in SmartBatchUpdateScenario

Glayaar — Thu, 08 Apr 2010 00:48:29 GMT

I did not found any attachment in your post. However based on my test on your scenario, you could use the GetRowByKeyValue client side function to determine if the row your are going to add has already exist. The function will return null if the row does not exist.

Here is a snippet:

grid.RootTable.GetRowByKeyValue(KeyValue);

Get row count in SmartBatchUpdateScenario

hermancordes@gmail.com — Wed, 07 Apr 2010 03:30:48 GMT

Hi Glenn,

It actually concerns sample BatchUpdate1.aspx in the attached Batch.zip.

In your scenario, which event handler are you using in an attempt to cancel the row addition? In your scenario, does the message occur after each pending changes or after accept all changes occurs?

Let me describe the situation a little more. The webgrid is currently used in combination with a search box. The selected results (can be more than one), will be added to the 'container'/'selected results' webgrid. However, all results and record values will be added on clientside.

Because of clientside addition (user can't interact at this point), no eventhandler of the webgrid is used. The records will be added if the user makes the selection of search results final. So for me, this is a logical place to check the record already exists (correct me if I'm wrong).

If no check is applied or the check fails (as descriped in topic start), the WebGrid displays the message on the line where I call AddPendingChanges(). The message is: The pending changes already contain a record with key 'x'.

I hope this clearifies the situation and hope you'll have an idea of how to solve this problem.

Thanks in advance!

Get row count in SmartBatchUpdateScenario

Glayaar — Wed, 07 Apr 2010 00:10:39 GMT

In the provided sample BatchUpdate_Enterprise.aspx, I have tried the scenario you described, adding multiple row with duplicate KeyValue. However, internal WebGrid validation on every pending changes will already disallow such operation.

In your scenario, which event handler are you using in an attempt to cancel the row addition? In your scenario, does the message occur after each pending changes or after accept all changes occurs?

Get row count in SmartBatchUpdateScenario

hermancordes@gmail.com — Tue, 06 Apr 2010 06:02:12 GMT

Currently I'm working with a SmartBatchUpdateScenario. However, the possibility exists that a record gets added with a duplicate KeyValue. The WebGrid gives me a decent error message about that, but I'd like to detect that in advance and suppress the message. The message is not relevant for users in my case.

So my first solution to detect that case was to loop through all grid rows and check each keyvalue to the keyvalue of the record to be added. If a match is found, the record is not added. I'm encountering one problem hereby: the number of grid rows isn't returning the correct number of rows.

Concrete steps:

The first row in an empty grid that will be added checks the KeyValue exists. The number of rows is 0, so it doesn't exist and will be added.
The second row in a grid (with one row) will check the KeyValue exists. However, the number of rows is still 0, so the record gets added. Even if this record is the same as the first one.

I'm using the attachment from this thread: http://www.intersoftpt.com/Community/WebGrid/WebGrid-two-way-binding-issue/. Several ways to get the row count:

var grid = ISGetObject("WebGrid1");
alert(grid.TotalLoadedRows); // Doesn't change after record has been added at client side.
alert(grid.TotalRows);// Doesn't change after record has been added at client side.
alert(grid.RootTable.Rows); // Is null.
alert(grid.RootTable.Rows.length); // Throws error.

Questions:

Am I doing something wrong with this solution?
Should I be using another property to obtain rowcount in a SmartBatchUpdateScenario?
Is there another way to detect duplicate KeyValues in rows?

Thanks in advance.