BatchUpdate in webgrid Issue when using SQL DataSource

sample4170 — Tue, 19 Aug 2014 09:51:06 GMT

Hi,

I am having a webgrid with SQL Datasource which allows BatchUpdate. I've written code behind using the samples given with the product.

Now, my issue is this: When a single row is updated, it affects the Physical DB and is reflected when refreshed, properly. But, when a set of rows are affected, in the code behind, the values are sent to the SQL Update Parameters correctly but the Physical DB is updated to have the last row change being applied to all those corresponding rows.

For eg., I am changing 2 rows' with column "ratio" = 76 and 85 respectively and update it. The code behind passes the value properly and the grid is showing the same. Once I press refresh, the DB shows BOTH those two rows to have "ratio" = 85.

My SQL update command is as usual normal: "Update table_name set ratio=@Ratio where ID=@Id";

SQL Update Parameters: @Ratio, @Id

SQL Update Parameter Values: ["Ratio"].DefaultValue = newValue;

["Id"].DefaultValue = newValue; in switch according to column name;

This all, I have given in OnBatchUpdate function and foreach PendingChanges; SQLDS.Update() is called for time. Is there anything wrong with this code? If it is taking the latest Default value, then the Key field should also be pointing to the latest row alone, meaning only one row is affected, right?

Sample:

Id Ratio Override

1 90 true

2 100 true

After Update, my Physical DB is like this:

1 100 true

2 100 true

foreach row

"Id".defaultvalue = keyValue;

foreach column_changed_data

tmp_ratio = newvalue if column = "Ratio"

tmp_override = newValue if column = "Override"

end loop;

if override = "true"

"Ratio".Defaultvalue = tmp_ratio

"Override".DefaultValue = tmp_override

else

"Override".DefaultValue = tmp_override

SQL.update();

endloop;

I really appreciate the help. Thanks!

BatchUpdate (Deleting / Updating) and Review Problems

Attila — Tue, 05 Jan 2010 08:41:45 GMT

Hello

I can Insert, Update and Delete records normally with BatchUpdate set to false... but I can't delete or update when it is set to true. It returns an alert with the message (for example):

WebGrid failed to update 2 out of 2 changes due to errors. Please review and correct your changes.

The following records were not updated:
-Record '14037 06-01-2010 10:10:00<4206' : Unable to find the record '14037 06-01-2010 10:10:00<4206' in the datasource.
-Record '14037 13-01-2010 10:10:00<4206' : Unable to find the record '14037 13-01-2010 10:10:00<4206' in the datasource.

The weird thing is the "<" between date and 4206... The same error returns when trying to delete. Only Inserting records with batchupdate returns no error.

Other related issue:

I cant review changes because an alert saying "WebGrid instance can't be found. Please make sure you launch this form from WebGrid UI" appears. My webgrid is inside a javascript generated WebDesktopWindow

        function CreateWindow() {
            var wnd = dm.GetWindow('testing');
            if (wnd == null) {
                wnd = new window.parent.WebDesktopWindow();
                wnd.Text = 'Just for testing';
                wnd.Name = 'testing';
                wnd.AllowMinimize = "Yes";
                wnd.AllowMaximize = "Yes";
                wnd.AllowResize = "Yes";
                wnd.ContentURL = "Testing/ShowTesting.aspx";
                wnd.ContentMode = "UseIFrame";
                dm.Windows.Add(wnd);
                wnd.Show();
                wnd.ResizeTo(800, 600);
                wnd.MoveToCenterDesktop();
                wnd.BringToFront();
            }
            else {
                wnd.Activate();
            }
        }

My page is too extensive to upload as sample, I just would like an opinion on what it might be. I'll try to send a sample later. By the way... it is almost the same as this sample.

Oh...! About the version: I've updated using the Update Manager, but it returned an error. I've tried to update again and no error returned. Image as attachment.

TIA.

Edit: On FireFox it doesnt event terminate "Submitting all changes to server..."

Intersoft Community - BatchUpdate

BatchUpdate in webgrid Issue when using SQL DataSource

BatchUpdate (Deleting / Updating) and Review Problems