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
264
Webtree HierarchicalDataSource "Where" Clause...
posted

Okay.  I cannot figure this out.  I have a TreeView bound to a WebHierarchicalDataSource.  Everything works as it is supposed to until I put in a where clause in the SQL datasource that  "populates" the WHDS.

 Anyone have any ideas??

Parents
No Data
Reply
  • 28464
    posted

    Hello,

    This certainly sounds weird. I did try to reproduce the problem, unfortunately to no avail (I am using version 2008.3). Even if I used WHERE clause in my statement, WHDS and UltraWebTree worked fine. I believe the best solution in this case would be to isolate the issue in a small subset of your project and send it directly to our dedicated Developer Support department.

    Here is one of the setups I tried:

    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
    <%@ Register assembly="Infragistics35.WebUI.UltraWebNavigator.v8.3, Version=8.3.20083.1009, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebNavigator" tagprefix="ignav" %>


    <%@ Register assembly="Infragistics35.Web.v8.3, Version=8.3.20083.1009, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.Web.UI.DataSourceControls" tagprefix="ig" %>


    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title></title>
    </head>
    <body>
        <form id="form1" runat="server">
        <asp:ScriptManager runat="server" ID="ScriptManager1"></asp:ScriptManager>
       
        <script type="text/javascript">



        </script>  
     
        <ignav:UltraWebTree ID="UltraWebTree1" runat="server"
            DataSourceID="WebHierarchicalDataSource1" DefaultImage="" HiliteClass=""
            HoverClass="" Indentation="20">
            <DataBindings>
                <ignav:NodeBinding DataMember="AccessDataSource1_DefaultView" />
                <ignav:NodeBinding DataMember="AccessDataSource1_DefaultView"
                    TextField="LastName" />
                <ignav:NodeBinding DataMember="AccessDataSource2_DefaultView"
                    TextField="LastName" />
            </DataBindings>
        </ignav:UltraWebTree>
       
     
        <ig:WebHierarchicalDataSource ID="WebHierarchicalDataSource1" runat="server">
            <DataRelations>
                <ig:DataRelation ChildColumns="ReportsTo"
                    ChildDataViewID="AccessDataSource2_DefaultView" ParentColumns="EmployeeID"
                    ParentDataViewID="AccessDataSource1_DefaultView" />
            </DataRelations>
            <DataViews>
                <ig:DataView ID="AccessDataSource1_DefaultView" DataMember="DefaultView"
                    DataSourceID="AccessDataSource1" />
                <ig:DataView ID="AccessDataSource2_DefaultView" DataMember="DefaultView"
                    DataSourceID="AccessDataSource2" />
            </DataViews>
        </ig:WebHierarchicalDataSource>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server"
            DataFile="~/App_Data/Nwind.mdb"
            SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [ReportsTo] FROM [Employees]">
        </asp:AccessDataSource>
        <asp:AccessDataSource ID="AccessDataSource2" runat="server"
            DataFile="~/App_Data/Nwind.mdb"
            SelectCommand="SELECT [EmployeeID], [LastName], [ReportsTo] FROM [Employees] WHERE EmployeeID < 50">
        </asp:AccessDataSource>
       
     
        </form>
    </body>
    </html>
     

Children