Intersoft Community - WebGrid Enterprise - GetChanges() problem if the rows are grouped

GetChanges() problem if the rows are grouped

handy@intersoftpt.com — Fri, 06 Nov 2009 01:07:49 GMT

Hi Michael,

I am not sure about what you are doing. As i said before, i don't get any error when comment out this code grd.XmlHttp.Asynchronous = false; Therefore you got message box "Please wait..." because you called grid,Refresh(). If the progress has not been finished yet, of course that would be showed. To avoid this message box, i think you can use a timeout.

Regards,
Handy

GetChanges() problem if the rows are grouped

Michael — Wed, 04 Nov 2009 08:33:21 GMT

Hi Handy

Before deleting I want check if there row has dependencies.

Between loading the page and the batch update the dependencies might have changed. So i check on clientsideevent OnAcceptAllChanges if the user has selected a row with dependencies. If true then i undo Changes for this row.

I don't want that the user sees the error of the database.

Regards

Michael

GetChanges() problem if the rows are grouped

handy@intersoftpt.com — Tue, 03 Nov 2009 00:16:57 GMT

Hi Michel,

Hm, but i don't understand why you need to refresh the grid. When you accept pending changes, the grid should be automatically refreshed. So, it should be no problem for your application.

Regards,
Handy

GetChanges() problem if the rows are grouped

Michael — Thu, 29 Oct 2009 10:50:20 GMT

Hi Handy

In first column (R) dependencies (referential integrity) are shown. Has a row still dependencies, the row can not be deleted. So I check on client side, if the cell value is greater then 0. Since the dependencies might have changed, i refresh grid first. Because the refresh is asynchrom running, I had problems in the past (Application hangs -> Messagebox "Please wait..."). For this reason, I set XmlHttp.Asynchronous=false.

Regards

Michael

GetChanges() problem if the rows are grouped

handy@intersoftpt.com — Thu, 29 Oct 2009 04:39:25 GMT

Hi,

May i know your requirement? I don't quite understand your scenario and why your scenario must be like this so the error showed. If I comment out this code grd.XmlHttp.Asynchronous = false;, I can delete the second group without error.

Regards,
Handy

GetChanges() problem if the rows are grouped

Michael — Mon, 26 Oct 2009 09:19:05 GMT

I have a problem with GetChanges() if the rows are grouped. Please have a look on attached pictures and sample.

Following Code (DelChanges[i].Row.GetCell()) works in first group only!

Have I forgotten anything?

var DelChanges = grd.GetChanges("Deleted");
for (var i in DelChanges) {
    if (DelChanges[i].Row.GetCell("Dependencies").Value > 0) {
        if (DependenciesText.length > 0)
            MessageQuantity = 2;
        else
            MessageQuantity = 1;
        DependenciesText += "\n - " + DelChanges[i].Row.GetCell("CustomerID").Text + " | " + DelChanges[i].Row.GetCell("CompanyName").Text + " | " + DelChanges[i].Row.GetCell("ContactName").Text + " | " + DelChanges[i].Row.GetCell("ContactTitle").Text;
        DelChanges[i].Row.UndoChanges();
    }
}

Please try my sample.

Change ConnectionString and run sample
Delete a row in first group
Accept all Changes (-> Messagebox)
Delete a row in second group
Accept all Changes (-> Error)