Display selected child TreeView node with parent in another TreeView using C# and VB.Net in ASP.Net

Hi vsaklani,

I have created sample that full-fill your requirement.

HTML

<table>
    <tr>
        <td>
            <asp:TreeView ID="TreeView1" runat="server" ImageSet="XPFileExplorer" NodeIndent="15"
                OnSelectedNodeChanged="TreeView1_SelectedNodeChanged">
                <HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
                <NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="2px"
                    NodeSpacing="0px" VerticalPadding="2px"></NodeStyle>
                <ParentNodeStyle Font-Bold="False" />
                <SelectedNodeStyle BackColor="#B5B5B5" Font-Underline="False" HorizontalPadding="0px"
                    VerticalPadding="0px" />
            </asp:TreeView>
        </td>
        <td>
            <asp:TreeView ID="TreeView2" runat="server" ImageSet="XPFileExplorer" NodeIndent="15">
                <HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
                <NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="2px"
                    NodeSpacing="0px" VerticalPadding="2px"></NodeStyle>
                <ParentNodeStyle Font-Bold="False" />
                <SelectedNodeStyle BackColor="#B5B5B5" Font-Underline="False" HorizontalPadding="0px"
                    VerticalPadding="0px" />
            </asp:TreeView>
        </td>
    </tr>
</table>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.PopulateTreeView(this.GetData("SELECT Id, Name FROM VehicleTypes"), 0, null);
    }
}

private void PopulateTreeView(DataTable dtParent, int parentId, TreeNode treeNode)
{
    foreach (DataRow row in dtParent.Rows)
    {
        TreeNode child = new TreeNode { Text = row["Name"].ToString(), Value = row["Id"].ToString() };
        if (parentId == 0)
        {
            TreeView1.Nodes.Add(child);
            PopulateTreeView(this.GetData("SELECT Id, Name FROM VehicleSubTypes WHERE VehicleTypeId = " + child.Value), int.Parse(child.Value), child);
        }
        else
        {
            treeNode.ChildNodes.Add(child);
        }
    }
}

private DataTable GetData(string query)
{
    DataTable dt = new DataTable();
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(query))
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                sda.Fill(dt);
            }
        }
        return dt;
    }
}

protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
    string parent = this.TreeView1.SelectedNode.Parent.Text;
    int parentId = Convert.ToInt32(this.TreeView1.SelectedNode.Parent.Value);
    string child = this.TreeView1.SelectedNode.Text;
    int childId = Convert.ToInt32(this.TreeView1.SelectedNode.Value);
    TreeView2.Nodes.Clear();
    TreeView2.Nodes.Add(new TreeNode(parent, parentId.ToString()));
    TreeView2.Nodes[0].ChildNodes.Add(new TreeNode(child, childId.ToString()));
}

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Me.PopulateTreeView(Me.GetData("SELECT Id, Name FROM VehicleTypes"), 0, Nothing)
    End If
End Sub

Private Sub PopulateTreeView(dtParent As DataTable, parentId As Integer, treeNode As TreeNode)
    For Each row As DataRow In dtParent.Rows
        Dim child As New TreeNode() With { _
         .Text = row("Name").ToString(), _
         .Value = row("Id").ToString() _
        }
        If parentId = 0 Then
            TreeView1.Nodes.Add(child)
            PopulateTreeView(Me.GetData("SELECT Id, Name FROM VehicleSubTypes WHERE VehicleTypeId = " + child.Value), Integer.Parse(child.Value), child)
        Else
            treeNode.ChildNodes.Add(child)
        End If
    Next
End Sub

Private Function GetData(query As String) As DataTable
    Dim dt As New DataTable()
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As New SqlConnection(constr)
        Using cmd As New SqlCommand(query)
            Using sda As New SqlDataAdapter()
                cmd.CommandType = CommandType.Text
                cmd.Connection = con
                sda.SelectCommand = cmd
                sda.Fill(dt)
            End Using
        End Using
        Return dt
    End Using
End Function

Protected Sub TreeView1_SelectedNodeChanged(sender As Object, e As EventArgs)
    Dim parent As String = Me.TreeView1.SelectedNode.Parent.Text
    Dim parentId As Integer = Convert.ToInt32(Me.TreeView1.SelectedNode.Parent.Value)
    Dim child As String = Me.TreeView1.SelectedNode.Text
    Dim childId As Integer = Convert.ToInt32(Me.TreeView1.SelectedNode.Value)
    TreeView2.Nodes.Clear()
    TreeView2.Nodes.Add(New TreeNode(parent, parentId.ToString()))
    TreeView2.Nodes(0).ChildNodes.Add(New TreeNode(child, childId.ToString()))
End Sub

Screenshot