Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1300
WebHierarchicalDataSource binding problems.
posted

I am having the problems while binding the UltraWebGrid with  WebHierarchicalDataSource. I have two ObjectDataSource returns list object. I am not able to bind. I am geting the "Object reference not set to an instance of an object." error.

I tried with SqlDataSource its working fine. Is it WebHierarchicalDataSource supports only SqlDataSourc. 

Please help out this. 

Here my code:

 

 

<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" DataSourceID="WebHierarchicalDataSource1">
    <Bands>
      <%-- BaseTableName and DataKeyField must both be specified to enable CRUD operations --%>
      <igtbl:UltraGridBand DataKeyField="PKTicketID">
        <AddNewRow Visible="NotSet" View="NotSet">
        </AddNewRow>
        <Columns>
          <igtbl:UltraGridColumn BaseColumnName="PKTicketID" DataType="System.Int64" IsBound="True"
            Key="PKTicketID">
            <Header Caption="PKTicketID">
              <RowLayoutColumnInfo OriginX="1" />
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="1" />
            </Footer>
          </igtbl:UltraGridColumn>
        </Columns>
      </igtbl:UltraGridBand>
      <igtbl:UltraGridBand DataKeyField="PKTicketID">
        <AddNewRow Visible="NotSet" View="NotSet">
        </AddNewRow>
        <Columns>
          <igtbl:UltraGridColumn BaseColumnName="PKTicketID" DataType="System.Int64" IsBound="True"
            Key="PKTicketID">
            <Header Caption="PKTicketID">
              <RowLayoutColumnInfo OriginX="1" />
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="1" />
            </Footer>
          </igtbl:UltraGridColumn>
          <igtbl:UltraGridColumn BaseColumnName="tickettitle" DataType="System.Int64" IsBound="True"
            Key="tickettitle">
            <Header Caption="tickettitle">
              <RowLayoutColumnInfo OriginX="1" />
            </Header>
            <Footer>
              <RowLayoutColumnInfo OriginX="1" />
            </Footer>
          </igtbl:UltraGridColumn>
        </Columns>
      </igtbl:UltraGridBand>
    </Bands>
    <DisplayLayout CompactRendering="False" AllowColSizingDefault="Free" AllowDeleteDefault="Yes"
      AutoGenerateColumns="false" AllowSortingDefault="Yes" AllowUpdateDefault="Yes"
      BorderCollapseDefault="Separate" HeaderClickActionDefault="SortMulti" Name="wgTicket"
      RowHeightDefault="20px" RowSelectorsDefault="No" SelectTypeRowDefault="Extended"
      SelectTypeCellDefault="Extended" Version="4.00" ViewType="Hierarchical" AllowColumnMovingDefault="OnClient"
      ScrollBarView="Horizontal" CellClickActionDefault="RowSelect" GridLinesDefault="None"
      HeaderTitleModeDefault="OnOverflow" TabDirection="BottomToTop" StationaryMargins="Header">
      <RowStyleDefault CssClass="normal" Width="100%">
      </RowStyleDefault>
      <RowAlternateStyleDefault CssClass="alternate">
      </RowAlternateStyleDefault>
      <GroupByBox BoxStyle-BackColor="#FFFFC0" BoxStyle-HorizontalAlign="Center" BoxStyle-Height="10px">
      </GroupByBox>
      <SelectedRowStyleDefault BackColor="LightGoldenrodYellow" ForeColor="Black" HorizontalAlign="Left"
        VerticalAlign="Middle">
      </SelectedRowStyleDefault>
      <HeaderStyleDefault CssClass="iheader">
      </HeaderStyleDefault>
      <FrameStyle Width="100%">
      </FrameStyle>
    </DisplayLayout>
  </igtbl:UltraWebGrid>

 

  <ig:WebHierarchicalDataSource ID="WebHierarchicalDataSource1" runat="server">
    <DataRelations>
      <ig:DataRelation ChildColumns="fkrelatedticketid" ChildDataViewID="SqlDataSource2_DefaultView"
        ParentColumns="Pkticketid" ParentDataViewID="SqlDataSource1_DefaultView" />
    </DataRelations>
    <DataViews>
      <ig:DataView ID="SqlDataSource1_DefaultView" DataMember="DefaultView" DataSourceID="odsTicket" />
      <ig:DataView ID="SqlDataSource2_DefaultView" DataMember="DefaultView" DataSourceID="odsRelated" />
    </DataViews>
  </ig:WebHierarchicalDataSource>

<asp:ObjectDataSource ID="odsTicket" runat="server" SelectMethod="GetAllPoolTicket"
    SortParameterName="SortExpression" TypeName="A1CRM.TicketBO">
 
  </asp:ObjectDataSource>

   <asp:ObjectDataSource ID="odsRelated" runat="server" SelectMethod="GetAllRelatedTicketsInPopUp"
    TypeName="A1CRM.TicketBO" SortParameterName="SortExpression">
    
  </asp:ObjectDataSource>

 

  • 3147
    posted

    Hi,

    it seems that the data relation is not correctly setup:

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

    ParentColumns should be "PKTicketID" instead of "Pkticketid".

    I hope that helps.