UltraWebTree Question | Infragistics Forums

Rumen Stankov"]That was a good one :) If you can share the solution it would be great.

Sure. My problem was that I was trying to display something like this:

Alberts, Bob

Anderson, Fred

but I was getting this instead

Alberts, Bob

Anderson, Fred

In the data relation section below I was originally using the EmployeeID as the Parent and Child Columns, but what I needed to do was use the Letter:

<body>

<div>

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

<ignav:UltraWebTree ID="UltraWebTree1" runat="server" DataSourceID="WebHierarchicalDataSource1"

DefaultImage="ig_treeOfficeFolder.gif" HilieClass="" HoverClass=""

Indentation="20" BorderColor="#E2F2FC" Width="300px"

DefaultSelectedImage="ig_treeOfficeFolder.gif" >

<ignav:NodeBinding DataMember="DataSource1_DefaultView" TextField="Letter" />

<ignav:NodeBinding DataMember="DataSource2_DefaultView" TextField="Name" />

</DataBindings>

</Images>

</NodeStyle>

</SelectedNodeStyle>

</ignav:UltraWebTree>

</div>

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

<whds:DataRelation ChildColumns="Letter"

ChildDataViewID="DataSource2_DefaultView"

ParentColumns="Letter"

ParentDataViewID="DataSource1_DefaultView" />

</DataRelations>

<whds:DataView ID="DataSource1_DefaultView" DataMember="DefaultView" />

<whds:DataView ID="DataSource2_DefaultView" DataMember="DefaultView" />

</DataViews>

</whds:WebHierarchicalDataSource>

</form>

</body>

Then in the code behind, instead of selecting the employeeid, I just needed to select the Letter instead:

protected void PopulateTree(object sender, EventArgs e)

{

// open database connection

string strConnection = string.Empty; SqlConnection sqlConn;

strConnection =

System.Configuration.ConfigurationManager.ConnectionStrings["CorporateConnectionString"].ConnectionString;

sqlConn = new SqlConnection(strConnection);

sqlConn.Open();

// Retrieve data from database with sql query.

// Use a forward-only datareader because forward only processing is all that is required.

// Create a new datatable and load it with contents in datareader.

// Finally set the datasource of the dataview to the datatable.

// Repeat for second dataview

string strSQL1;

strSQL1 = "select distinct left(Last_Name,1) as Letter from corporate..person_tbl order by 1";

SqlCommand cmdSQL1 = new SqlCommand(strSQL1, sqlConn);

SqlDataReader drSQL1 = cmdSQL1.ExecuteReader();

//drSQL1.Read(); When reading here, the A's are skipped

DataTable dt1 = new DataTable();

dt1.Load(drSQL1);

drSQL1.Close();

DataSource1_DefaultView.DataSource = dt1;

string strSQL2 = string.Empty;

strSQL2 = "Select left(Last_Name,1) as Letter, Name from Corporate..Person_TBL";

SqlCommand cmdSQL2 = new SqlCommand(strSQL2, sqlConn);

SqlDataReader drSQL2 = cmdSQL2.ExecuteReader();

DataTable dt2 = new DataTable();

dt2.Load(drSQL2);

drSQL2.Close();

DataSource2_DefaultView.DataSource = dt2;

sqlConn.Close();

}

That seemed to do the trick! My next task is to do this same thing using the asp.net treeview control. I want to see what the difference in loading time is between the two.

Rich