Hy all

Im not sure, im here in the right forum. But i try it.

I have bound a igtbl:UltraWebGrid to a SQL Data Source whit the fields ID(int), ParrentID(int) and a field called Kategorie as nVarChar(50). But i can't see any date in the UltraWebGrid. Just the text: "No Data To Display". I have read other trades here, but i cant find de Property ParrentID for set it to null.

I hav used the Designer to create the UltraWebGrid.

Pleas can someelse say me, the Root node in the Table has in the Field ParrentID null or 0 ?

What is wrong in my little code?

Thanks a lot for help.

Greatings Dominik

<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" DataSourceID="WebHierarchicalDataSource1" Height="200px" Width="325px" DataKeyField="ID">

<bands>

<igtbl:UltraGridBand AddButtonCaption="SqlDataSourceKategorien_DefaultView" BaseTableName="SqlDataSourceKategorien_DefaultView" Key="SqlDataSourceKategorien_DefaultView" DataKeyField="ID">

<Columns>

<igtbl:UltraGridColumn BaseColumnName="ID" DataType="System.Int32" IsBound="True" Key="ID">

<Header Caption="ID">

</Header>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="Kategorie" IsBound="True" Key="Kategorie">

<Header Caption="Kategorie">

<RowLayoutColumnInfo OriginX="1" />

</Header>

<Footer>

<RowLayoutColumnInfo OriginX="1" />

</Footer>

</igtbl:UltraGridColumn>

</Columns>

<addnewrow view="NotSet" visible="NotSet">

</addnewrow>

</igtbl:UltraGridBand>

</bands>

<displaylayout allowcolsizingdefault="Free" allowcolumnmovingdefault="OnServer" allowdeletedefault="Yes" allowsortingdefault="OnClient" allowupdatedefault="Yes" bordercollapsedefault="Separate" headerclickactiondefault="SortMulti" name="UltraWebGrid1" rowheightdefault="20px" rowselectorsdefault="No" selecttyperowdefault="Extended" stationarymargins="Header" tablelayout="Fixed" version="4.00" viewtype="Hierarchical">

<framestyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid" borderwidth="1px" font-names="Microsoft Sans Serif" font-size="8.25pt" height="200px" width="325px">

</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>

<br />

<ig:WebHierarchicalDataSource ID="WebHierarchicalDataSource1" runat="server">

<datarelations>

<ig:DataRelation ChildColumns="ParrentID" ChildDataViewID="SqlDataSourceKategorien_DefaultView" ParentColumns="ID" ParentDataViewID="SqlDataSourceKategorien_DefaultView" />

</datarelations>

<dataviews>

<ig:DataView ID="SqlDataSourceKategorien_DefaultView" DataMember="DefaultView" DataSourceID="SqlDataSourceKategorien" />

</dataviews>

</ig:WebHierarchicalDataSource>