Help with ultragrid

ross13
ross13 used Ask the Experts™
on
I have an ultragrid that I am trying to populate from a data set in vb. I have two tables that I would like the user to be able to view (OrderHead, OrderDetail).

I would like the user to be able to click on the order header line and the detail from the order detail table to show (plus sign). I have tried the following but does not seem to work. Any help would be appreciated.


 rel_orderHead = New DataRelation("tmpDS", tmpDS.Tables("OrderHead").Columns("Order No"), _
 tmpDS.Tables("OrderDetail").Columns("Order No"))
 tmpDS.Relations.Add(rel_orderHead)

ugdEpiCustom1.SetDataBinding(tmpDS, "OrderHead")

ugdEpiCustom1.DataSource = tmpDS

The ultra grid shows the order header table information but not the detail.

Thanks

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Image of order head record (screen shot) uploaded
ultragrid.bmp
Hi,

In grid's DisplayLayout, ViewType="Hierarchical" should be there.
Do you have that only or different?
Hi,

I think you have ViewType as OutlookGroupBy. It should be Hierarchical like below

<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server">
        <DisplayLayout ViewType="OutlookGroupBy"></DisplayLayout>
</igtbl:UltraWebGrid>

Open in new window

oops....  Sorry. Previous one is wrong. use like below

<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server">
        <DisplayLayout ViewType="Hierarchical"></DisplayLayout>
</igtbl:UltraWebGrid>

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial