Intersoft Solutions - Community - WebGrid Enterprise - WebGridTable.Rows Client Side Bug?

Ask Question

Start Discussion

Add to My Favorites

Alert Me

RSS

Adrian CunninghamMember

Posted: May 10, 2010 1:23 PM

Hi,

I have a hierarchical table structure in my WebGrid where there is one RootTable and one ChildTable. I want to iterate through all rows of my child table to look for certain "StatusID" column values and if found set the WebGrid to automatically refresh after a set period of time, when I will perform the check again.

The code I have written is as follows:

        var grid = ISGetObject("grdEDMPortfolios");
        
        var childRows = grid.RootTable.ChildTables[0].Rows;
        for(var i = 0; i < childRows.length; i++)
        {
            alert(childRows[i].GetCells().GetNamedItem("StatusID").Value);
        }

This does not work however since the "ChildTables[0].Rows" property never returns the child rows as described in your WebGrid documentation, it always returns null.

Is this a bug? And how do I do this without have to iterate though each RootTable row then having to get each child row which seems like overkill.

Regards,

Adrian.

Quote

All Replies

Yudi Member

Posted: May 10, 2010 5:54 PM in response to Adrian Cunningham

I’d like to suggest you a better way to get the child row by using GetChildRows object based on defined relations.
Example:

...
var childRows = row.GetChildRows("Orders");
...

For more detail information about the application of GetChildRows, please refer to Client_ProgrammaticUI_Hierarchical.aspx WebGrid sample file that can be found in WebGridSamples project (start > All Programs > Intersoft WebUI Studio 2009 R2 SP1 > WebUI Studio for ASP.NET > WebGrid 7 > C# Samples).

Hope this helps.

Quote

Adrian CunninghamMember

Posted: May 10, 2010 6:00 PM in response to Yudi

Yudi,

Thanks of the response. I've worked around the issue of the ".Rows" property of the WebGridTable always being null (seems kind of pointless to document this property if it doesn't actually work) but my solution is similar to yours in that I have to iterate through all the RootTable rows and call GetChildRows() methods.

        for(var i = 0; i < totalRows; i++)
        {
            var childRows = grid.RootTable.GetRow(i).GetChildRows();
            for(var j = 0; j < childRows.length; j++)
            {
                if(childRows[j].GetCells().GetNamedItem("StatusID").Value != 352 && // Completed
                   childRows[j].GetCells().GetNamedItem("StatusID").Value != 353 && // Failed 
                   childRows[j].GetCells().GetNamedItem("StatusID").Value != 354)   // Peril not found.
                { 
                    window.setTimeout("WebGrid_RefreshGrid('grdEDMPortfolios');", 15000);
                    return;
                }
            }
        }

Regards,

Adrian.

Quote

Yudi Member

Posted: May 11, 2010 9:40 AM in response to Adrian Cunningham

Glad to hear that the information helps.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

Quote