Thanks man its workig but it is not showing the "+" and child rows.

 I am returning the List<TicketBO> instead of IEnumerable and my parent datasources are like in screen shots.

below datasets are sample Datasouce out puts.

Parent datasouce

PKTicketId    TicketTitle    FKRelatedTicketId    TicketDescription
4345              tt1               Null                         td1
4451              tt2               Null                         td2

4697              tt3l              Null                         td3

4910              tt4               Null                         td4

child datasource

PKTicketId    TicketTitle    FKRelatedTicketId    TicketDescription
4403               tt                  4345                            td
4449               tt                  4451    
4450               tt                  4451   
4709               tt                  4697    
4710               tt                  4697    
4911               tt                  4910   
4912               tt                  4910                           

Please check if you have typed correctly all column names (case sensitive). For example the foreign key column is FKRelatedTicketId in your business object but is lower case in the DataRelation definition:

<ig:DataRelation ChildColumns="fkrelatedticketid" ChildDataViewID="SqlDataSource2_DefaultView"
        ParentColumns="Pkticketid" ParentDataViewID="SqlDataSource1_DefaultView" />

Yes I have changed it.This is my  WebHierarchicalDataSource.

<ig:WebHierarchicalDataSource ID="whdsTicket" runat="server">
    <DataRelations>
      <ig:DataRelation ChildColumns="FkRelatedTicketId" ChildDataViewID="Related_View"
        ParentColumns="PkTicketid" ParentDataViewID="Ticket_View" />
    </DataRelations>
    <DataViews>
      <ig:DataView ID="Ticket_View" DataMember="DefaultView" DataSourceID="odsTicket" />
      <ig:DataView ID="Related_View" DataMember="DefaultView" DataSourceID="ObjectDataSource1" />
    </DataViews>
  </ig:WebHierarchicalDataSource>

This is another grid I am making self relation. when I run this I am getting No Data To Display message. I have created a test table in northwid for sample project  and my datasource query is "SELECT PKID,FKID,Name,Description from Test".

Can you please check this sample code and let me now my mistakes.

 <igtbl:UltraWebGrid ID="UltraWebGrid2" runat="server" DataSourceID="WebHierarchicalDataSource2"
    Height="115px" Width="961px" DataKeyField="PKID">
    <Bands>
      <igtbl:UltraGridBand AddButtonCaption="ObjectDataSource3_DefaultView" BaseTableName="ObjectDataSource3_DefaultView"
        Key="ObjectDataSource3_DefaultView">
        <Columns>
          <igtbl:UltraGridColumn BaseColumnName="PKID" DataType="System.Int32" IsBound="True"
            Key="PKID">
            <Header Caption="PKID">
            </Header>
          </igtbl:UltraGridColumn>
          <igtbl:UltraGridColumn Key="FKID" IsBound="True" BaseColumnName="FKID">
            <Header Caption="FKID">
              <RowLayoutColumnInfo OriginX="1"></RowLayoutColumnInfo>
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="1"></RowLayoutColumnInfo>
            </Footer>
          </igtbl:UltraGridColumn>
          <igtbl:UltraGridColumn Key="Name" IsBound="True" BaseColumnName="Name">
            <Header Caption="Name">
              <RowLayoutColumnInfo OriginX="2"></RowLayoutColumnInfo>
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="2"></RowLayoutColumnInfo>
            </Footer>
          </igtbl:UltraGridColumn>
          <igtbl:UltraGridColumn Key="Description" IsBound="True" BaseColumnName="Description">
            <Header Caption="Description">
              <RowLayoutColumnInfo OriginX="3"></RowLayoutColumnInfo>
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="3"></RowLayoutColumnInfo>
            </Footer>
          </igtbl:UltraGridColumn>
        </Columns>
        <AddNewRow View="NotSet" Visible="NotSet">
        </AddNewRow>
      </igtbl:UltraGridBand>
      <igtbl:UltraGridBand DataKeyField="FKID" Key="FKID">
        <AddNewRow Visible="NotSet" View="NotSet">
        </AddNewRow>
        <Columns>
          <igtbl:UltraGridColumn BaseColumnName="FKID" DataType="System.Int32" IsBound="True"
            Key="FKID">
            <Header Caption="OrderID">
            </Header>
          </igtbl:UltraGridColumn>
          <igtbl:UltraGridColumn BaseColumnName="PKID" DataType="System.Int32" IsBound="True"
            Key="PKID">
            <Header Caption="PKID">
              <RowLayoutColumnInfo OriginX="2" />
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="2" />
            </Footer>
          </igtbl:UltraGridColumn>
          <igtbl:UltraGridColumn BaseColumnName="Description" DataType="System.Int16" IsBound="True"
            Key="Description">
            <Header Caption="Description">
              <RowLayoutColumnInfo OriginX="2" />
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="2" />
            </Footer>
          </igtbl:UltraGridColumn>
        </Columns>
      </igtbl:UltraGridBand>
    </Bands>
    <DisplayLayout AllowColSizingDefault="Free" AllowColumnMovingDefault="OnServer" AllowDeleteDefault="Yes"
      AutoGenerateColumns="false" AllowSortingDefault="OnClient" AllowUpdateDefault="Yes"
      BorderCollapseDefault="Separate" HeaderClickActionDefault="SortMulti" Name="UltraWebGrid1"
      RowHeightDefault="20px" RowSelectorsDefault="No" SelectTypeRowDefault="Extended"
      StationaryMargins="Header" StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed"
      Version="4.00" ViewType="OutlookGroupBy">
      <FrameStyle BackColor="Window" BorderColor="InactiveCaption" BorderStyle="Solid"
        BorderWidth="1px" Font-Names="Microsoft Sans Serif" Font-Size="8.25pt" Height="115px"
        Width="961px">
      </FrameStyle>
      <Pager MinimumPagesForDisplay="2">
        <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
          <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
        </PagerStyle>
      </Pager>
      <EditCellStyleDefault BorderStyle="None" BorderWidth="0px">
      </EditCellStyleDefault>
      <FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
        <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
      </FooterStyleDefault>
      <HeaderStyleDefault BackColor="LightGray" BorderStyle="Solid" HorizontalAlign="Left">
        <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
      </HeaderStyleDefault>
      <RowStyleDefault BackColor="Window" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"
        Font-Names="Microsoft Sans Serif" Font-Size="8.25pt">
        <Padding Left="3px" />
        <BorderDetails ColorLeft="Window" ColorTop="Window" />
      </RowStyleDefault>
      <GroupByRowStyleDefault BackColor="Control" BorderColor="Window">
      </GroupByRowStyleDefault>
      <GroupByBox>
        <BoxStyle BackColor="ActiveBorder" BorderColor="Window">
        </BoxStyle>
      </GroupByBox>
      <AddNewBox Hidden="False">
        <BoxStyle BackColor="Window" BorderColor="InactiveCaption" BorderStyle="Solid" BorderWidth="1px">
          <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px" />
        </BoxStyle>
      </AddNewBox>
      <ActivationObject BorderColor="" BorderWidth="">
      </ActivationObject>
      <FilterOptionsDefault>
        <FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"
          CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px"
          Height="300px" Width="200px">
          <Padding Left="2px" />
        </FilterDropDownStyle>
        <FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
        </FilterHighlightRowStyle>
        <FilterOperandDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid"
          BorderWidth="1px" CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"
          Font-Size="11px">
          <Padding Left="2px" />
        </FilterOperandDropDownStyle>
      </FilterOptionsDefault>
    </DisplayLayout>
  </igtbl:UltraWebGrid>
  <asp:ObjectDataSource ID="ObjectDataSource3" runat="server" SelectMethod="GetAllTest"
    TypeName="TestDB"></asp:ObjectDataSource>
 
  <br />
  <ig:WebHierarchicalDataSource ID="WebHierarchicalDataSource2" runat="server">
    <DataRelations>
      <ig:DataRelation ChildColumns="FKID" ChildDataViewID="ObjectDataSource3_DefaultView"
        ParentColumns="PKID" ParentDataViewID="ObjectDataSource3_DefaultView" />
    </DataRelations>
    <DataViews>
      <ig:DataView ID="ObjectDataSource3_DefaultView" DataMember="DefaultView" DataSourceID="ObjectDataSource3" />
    </DataViews>
  </ig:WebHierarchicalDataSource>

Are you sure that your object data source is correctly setup, does the UltraGrid display any data if bound directly to ObjectDataSource3?

Thaks a lot for your suggestions. I think the second approach with CustomHierarchicalDataSource will do the job.

Hi Kostas,

I'm not familiar with the IronSpeed Designer, is it possible to configure it not to call Page.DataBind()?

If that's not an option then I can suggest you two workarounds:

1. override Page.DataBind:

    public override void DataBind()
    {
        try
        {
            base.DataBind();
        }
        catch (NullReferenceException)
        {
        }
    }

2. Derive from WebHierarchicalDataSource and override DataBind to do nothing:

    public class CustomHierarchicalDataSource : WebHierarchicalDataSource
    {
        public override void DataBind()
        {
           
        }
    }

Then use CustomHierarchicalDataSource instead of WebHierarchicalDataSource.

Hope that helps for now. We are going to fix that in future versions and hotfixes of the control.

Hi, I have read all previous posts and i think i face the same issue with WebHierarchicalDataSource.

I have a self referencing data table in SqlServer 2005. I placed an SqlDataSource, a HierarchicalDataSource and an UltraWebMenu in an empty page. Everything works fine. The problem appears when i call this.DataBind() in the page load event. Then page childcontrols databinding is performed in a specific order. When the HierarchicalDataSource.DataBind() is called a null reference exception is thrown. If instead of this.DataBind(), when i call UltraWebMenu.DataBind() everything works fine again.

The reason this is an issue for me is because i use IronSpeed Designer for the project i currently work on. ISD internally calls Page.DataBind() in the Page.OnLoad event. Is there a workaround to this?

 I am currently using 8.3.20083.2021 version of asp .net controls.

Thanks in advance, Kostas.

 I have posted issue on Infragistics. Issue id:CAS-11530-1G9RQT.

I have attached the sample project also can you fix that sample project.

 Null.NullInteger is -99999