Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Auto Binding a TreeView control from a self referencing table

, 16 Apr 2007
A Custom TreeView Control that supports auto binding from a single self referencing table
autobindingtreeviewvb_src.zip
AutoBindingTreeViewVB_src
App_Code
Imports System
Imports System.Data
Imports System.Data.SqlClient

Partial Class DataBind
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            'Opens a connection to Database
            Dim oConn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ToString())
            oConn.Open()

            'Create Adapter and Fill Dataset
            Dim oAdapter As New SqlDataAdapter("SELECT * FROM SelfReferenceTable", oConn)
            Dim oDs As New DataSet
            oAdapter.Fill(oDs)

            'Close Connection
            oConn.Dispose()
            oConn = Nothing

            'Close Adapter
            oAdapter.Dispose()
            oAdapter = Nothing

            TestCtrl.DataFieldID = "ID"
            TestCtrl.DataFieldParentID = "ParentID"
            TestCtrl.DataTextField = "Text"
            TestCtrl.DataSource = oDs
            TestCtrl.DataBind()
        End If
    End Sub
End Class

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Bassam Saoud
Software Developer (Senior) Delcan Corporation
United States United States
Bassam Saoud is a software developer with more then 6+ years of experience. He has masters in Computer Science from American University of Technology and is currently doing Masters in Business Administration at Colorado Heights University. He started Programming with C++ and VB and now working with ASP.NET VB.NET/C#, SQL Server 2000/2005.
 
His interests are mainly politics, Basketball and Traveling.

| Advertise | Privacy | Mobile
Web03 | 2.8.140718.1 | Last Updated 16 Apr 2007
Article Copyright 2007 by Bassam Saoud
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid