Intersoft Community - WebGrid Enterprise - Multiple issues and questions with AllowBatchUpdate

Multiple issues and questions with AllowBatchUpdate

handy@intersoftpt.com — Tue, 28 Feb 2012 22:28:49 GMT

For this case, can you create a simple runable sample that replicates this issue? We need this to help you analyze the issue.

Regards,
Handy

Multiple issues and questions with AllowBatchUpdate

davidpendry — Tue, 28 Feb 2012 07:45:21 GMT

Hi,

Yes, got the docs.. thanks.

>> So basically, you mean, in non batch update (AllowBatchUpdate=false), insert and update work correctly without return error?

Yes, thats correct, i have inserted dummy inserts and update commands in the sqlcommand and this has rectified it for now. We still cant get the grid to work exactly how we want it in batchupdate mode, as the isRowchecker column is being shown for all rows when the code is initially hiding them on render...., so
for every update and insert that is handled by the server, we are refreshing the page completely, not ideal, but at least its a half house...

David.

Multiple issues and questions with AllowBatchUpdate

handy@intersoftpt.com — Mon, 27 Feb 2012 23:58:16 GMT

Hello David,

So basically, you mean, in non batch update (AllowBatchUpdate=false), insert and update work correctly without return error?

When install our product, there should offline documentation included. Unfortunately, our support site does not have the online documentation. You need to download it manually.

Regards,
Handy

Multiple issues and questions with AllowBatchUpdate

davidpendry — Mon, 27 Feb 2012 06:04:27 GMT

Thanks for the feedback.. further questions below

>> I think the problem is not because it could not find your insert/update method. But it seems your method itself should the problem.
>> For simple case, try not to use batch update first. Just use regular simple insert, update and delete. See if your insert/update method are working in non batch-update scenario.

The grid works ok when its not in batch mode, as mentioned the batch update method fires correctly, but when it exits and goes back to the framework something else is (or isnt) happening that is bubbling up the error to the user. The delete works fine in batch mode, i will investigae calling dummy inserts/updates in the SQLDataSource..

>> Unless, you want to customize the style by yourself. In this case, you need to get the element of the status bar, and change the size (width and height) of the icon.

Ok, we will have to style it ourselves..

>>You can find it in our documentation "How-to: Add/Remove a menu in WebGrid's context menu ".

We dont download documentation, wheres the link to this page on your websites online help.. ?

Regards

David

Multiple issues and questions with AllowBatchUpdate

handy@intersoftpt.com — Sun, 26 Feb 2012 21:35:09 GMT

Hello David,

Please allow me to help you in answering your question.

1. We are binding to a SqlDataSource for the selects, but the updates and inserts are using custom objects.
The insert and updates are ok and work fine when the method onbatchupdate method is called, but the page then displays
"WebGrid failed to update 1 out of 1 changes due to errors.Please review and correct your changes"

The following records were not updatesd.
Record '69': Object Reference not set to an instance of an object".

The code seems to be looking for the insert and update statements in the SqlDataSource which do not exist. How can i stop this from happening.?

I think the problem is not because it could not find your insert/update method. But it seems your method itself should the problem.
For simple case, try not to use batch update first. Just use regular simple insert, update and delete. See if your insert/update method are working in non batch-update scenario.

2."Accept All Changes" button on the bottom of the grid is far far too small. How do i make this button appear larger and place it at the top of the grid..

It could not be moved to the top. Even though you can larger the size, the style would be bad.
We have design each of images in status bar have their own size.
Unless, you want to customize the style by yourself. In this case, you need to get the element of the status bar, and change the size (width and height) of the icon.

3.How do we remove "Paste Multiple rows from clipboard" in the context menu. Its buggy & not needed.

You can find it in our documentation "How-to: Add/Remove a menu in WebGrid's context menu ".

Regards,
Handy

Multiple issues and questions with AllowBatchUpdate

davidpendry — Fri, 24 Feb 2012 07:15:00 GMT

Hi,

The grid is set to BatchUpdateMode, but we have a feww issues with it.

We are binding to a SqlDataSource for the selects, but the updates and inserts are using custom objects.
The insert and updates are ok and work fine when the method onbatchupdate method is called, but the page then displays
"WebGrid failed to update 1 out of 1 changes due to errors.Please review and correct your changes"

The following records were not updatesd.
Record '69': Object Reference not set to an instance of an object".

The code seems to be looking for the insert and update statements in the SqlDataSource which do not exist. How can i stop this from happening.?

"Accept All Changes" button on the bottom of the grid is far far too small. How do i make this button appear larger and place it at the top of the grid..

How do we remove "Paste Multiple rows from clipboard" in the context menu. Its buggy & not needed.

Thanks.

David