You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

16 lines
743 B

<%@ Page Language="C#" Debug="true" %>
<%@ Import Namespace="obout_ASPTreeView_2_NET" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script type="text/C#" runat="server">
void Page_Load(object sender, EventArgs e)
{
obout_ASPTreeView_2_NET.Tree oTree = new obout_ASPTreeView_2_NET.Tree();
OleDbConnection oConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/categories.mdb"));
oConn.Open();
// get all the categories from the database
string sQuery = "SELECT CategoryID, ParentID, CategoryText, Description, DateAdded, PriceRange, [Level], Icon FROM Categories ORDER BY [Level] ASC";
OleDbCommand oCommand = new OleDbCommand(sQuery);