Intersoft Community - WebGrid Enterprise - GetCell doesn't work with Hierarchical Grid

GetCell doesn't work with Hierarchical Grid

Michael — Wed, 04 Nov 2009 08:09:54 GMT

In the meantime, I've opened another thread: GetChanges() problem if the rows are grouped

GetCell doesn't work with Hierarchical Grid

Glayaar — Mon, 02 Nov 2009 23:35:20 GMT

Sorry for the late reply, it seems in the WebGrid1_OnAcceptAllChanges client side event handler you are invoking this line:

grd.XmlHttp.Asynchronous = false;grd.Refresh();
grd.XmlHttp.Asynchronous = true;

Those lines will collapse the other group which will cause the issue, our suggestion is to move those line after the iteration of deleted row changes.

By moving those lines after the deleted row changes iteration the JS issue does not occur.

GetCell doesn't work with Hierarchical Grid

Michael — Mon, 19 Oct 2009 02:58:06 GMT

Hi Glenn

Please have a look on my last post.

Can you reproduce this issue.

Regards

Michael

GetCell doesn't work with Hierarchical Grid

Michael — Mon, 12 Oct 2009 12:47:34 GMT

Hi Glenn

I still have a problem if the rows are groupiert. 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)

GetCell doesn't work with Hierarchical Grid

Glayaar — Mon, 12 Oct 2009 02:26:58 GMT

Invisible column will not be rendered, so it will not be accessible from client side function. However, we could use hidden data member property on a visble cell to hold the hidden column value. Here is a snippet to set the hidden column description value in the key column in the PrepareDateBindind server side event:

WebGrid1.RootTable.Columns.GetNamedItem("description").Visible = false;
WebGrid1.RootTable.Columns.GetNamedItem("key").HiddenDataMember = "description";

During onAcceptAllChanges client side function you will need to access the cell element and retirve the description attribute:

var parentMod = grd.Tables["parent"].GetChanges("Modified");
for (i = 0; i < parentMod.length; i++)
{   
    parentMod[i].Row.GetCell("key").CellElement.getAttribute("description");
}

GetCell doesn't work with Hierarchical Grid

Michael — Sun, 11 Oct 2009 09:28:30 GMT

Hi Glenn

Yes you are right but it doesn't work if <Column> is not visible.

That's my problem.

GetCell doesn't work with Hierarchical Grid

Glayaar — Fri, 09 Oct 2009 00:22:44 GMT

In hierarchical table, the code

grd.Tables["<Table>"].GetChanges("Deleted")[i].Row.GetCell("<Column>").Value

will work. Attached is the sample code for the HierarchicalGrid, the sample will print out all the modified key value when Accept All Changes is invoked.

GetCell doesn't work with Hierarchical Grid

Michael — Thu, 08 Oct 2009 08:18:06 GMT

This code works fine in flat grid:

grd.GetChanges("Deleted")[i].Row.GetCell("<Column>").Value

But in Hierarchical Grid the following code doesn't work:

grd.Tables["<Table>"].GetChanges("Deleted")[i].Row.GetCell("<Column>").Value grd.Tables.<Table>.GetChanges("Deleted")[i].Row.GetCell("<Column>").Value

How can i get changes for each table in Hierarchical Grid?

Best regards

Michael