ASPxTreeList.DataSource Property

Gets or sets the ASPxTreeList’s data source.

Namespace: DevExpress.Web.ASPxTreeList

Assembly: DevExpress.Web.ASPxTreeList.v24.1.dll

NuGet Package: DevExpress.Web

Declaration

C#

public override object DataSource { get; set; }

VB.NET

Public Overrides Property DataSource As Object

Property Value

Type	Description
Object	An object which represents the data source from which the ASPxTreeList retrieves its data.

Example

To bind an ASPxTreeList control to data created at runtime, handle the Page_Init or Page_Load event. In the event handler, assign a data source to the tree list’s DataSource property and call the DataBind() method:

ASPX

<dx:ASPxTreeList ID="ASPxTreeList1" runat="server"></dx:ASPxTreeList>

C#

using DevExpress.Web.ASPxTreeList;
using DevExpress.Web.Internal;
using System;
using System.Data;
using System.Data.OleDb;
using System.Web;

public partial class _Default : System.Web.UI.Page {

    protected override void Page_Init(EventArgs e) {
        InitTreeList(ASPxTreeList1);
        ASPxTreeList1.DataBind();
    }

    private void InitTreeList(ASPxTreeList tl) {
        tl.SettingsSelection.AllowSelectAll = true;
        tl.SettingsSelection.Enabled = true;
        tl.KeyFieldName = "ID";
        tl.ParentFieldName = "ParentID";
        tl.DataSource = CreateDataTable(CreateDataAdapter());
    }

    OleDbDataAdapter CreateDataAdapter() {
        string connectionString =
        @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Databases\Departments.mdb";
        OleDbConnection myConnection = new OleDbConnection(connectionString);
        string query =
        "SELECT [ID], [ParentID], [Department], [Budget], [Location] FROM [Departments]";
        return new OleDbDataAdapter(query, myConnection);
    }

    DataTable CreateDataTable(OleDbDataAdapter myAdapter) {
        DataTable dt = new DataTable();
        DataSet testData = new DataSet();
        myAdapter.Fill(testData);
        return testData.Tables[0];
    }
}

VB.NET

Imports DevExpress.Web.ASPxTreeList
Imports DevExpress.Web.Internal
Imports System
Imports System.Data
Imports System.Data.OleDb
Imports System.Web

Public Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Overrides Sub Page_Init(ByVal e As EventArgs) Handles Me.Init
        InitTreeList(ASPxTreeList1)
        ASPxTreeList1.DataBind()
    End Sub

    Private Sub InitTreeList(ByVal tl As ASPxTreeList)
        tl.SettingsSelection.AllowSelectAll = True
        tl.SettingsSelection.Enabled = True
        tl.KeyFieldName = "ID"
        tl.ParentFieldName = "ParentID"
        tl.DataSource = CreateDataTable(CreateDataAdapter())
    End Sub

    Private Function CreateDataAdapter() As OleDbDataAdapter
        Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Databases\Departments.mdb"
        Dim myConnection As OleDbConnection = New OleDbConnection(connectionString)
        Dim query As String = "SELECT [ID], [ParentID], [Department], [Budget], [Location] FROM [Departments]"
        Return New OleDbDataAdapter(query, myConnection)
    End Function

    Private Function CreateDataTable(ByVal myAdapter As OleDbDataAdapter) As DataTable
        Dim dt As DataTable = New DataTable()
        Dim testData As DataSet = New DataSet()
        myAdapter.Fill(testData)
        Return testData.Tables(0)
    End Function
End Class

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the DataSource property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

asp-net-web-forms-popup-use-one-popup-for-entire-application/CS/T501713/WebForm2.aspx.cs#L39

    (sender as ASPxTreeList).ParentFieldName = "Parent";
    (sender as ASPxTreeList).DataSource = Enumerable.Range(0, 10).Select(i => new { Id = i, Name = "Name" + i, Parent = i % 3 }).ToList();
};

VB.NET

asp-net-web-forms-popup-use-one-popup-for-entire-application/VB/T501713/WebForm2.aspx.vb#L37

    TryCast(sender, ASPxTreeList).ParentFieldName = "Parent"
    TryCast(sender, ASPxTreeList).DataSource = Enumerable.Range(0, 10).[Select](Function(i) New With {.Id = i, .Name = "Name" & i, .Parent = i Mod 3}).ToList()
End Sub