using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using APNSoft.WebControls;

public partial class TreeView_PopulateDatabase : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        //Define SQL query
        string SqlQuery = @"SELECT * FROM Items ORDER BY id";

        //Get DataTable (MS Access Database)
        DataTable myDataSource = DataBase.GetDataTableOleDb(SqlQuery, "~/TreeView/DataBases/dbItems.mdb");

        //Bind DataTable to the TreeView
        myTreeView.DataSource = myDataSource;
        myTreeView.DataBind();


        //Set 1st element opened (always)
        TreeViewElement myTreeViewElement = myTreeView.Elements[0];
        if (myTreeViewElement != null) myTreeViewElement.opened = true;

    }
}