listsection.aspx.cs

来自「《征服Ajax》原书的例题源码」· CS 代码 · 共 46 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Text;
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 Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;


public partial class ListSection : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Database db = DatabaseFactory.CreateDatabase("DatabaseConnectionString");

        string sqlCommand = "SELECT id,name,[order] FROM section ORDER BY [order]";
        DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);

        StringBuilder readerData = new StringBuilder();

        using (IDataReader dataReader = db.ExecuteReader(dbCommand))
        {
            readerData.Append("<ul id=\"section_list\">");
            while (dataReader.Read())
            {
                readerData.Append("<li id=\"");
                readerData.Append("li_" + dataReader["id"]);
                readerData.Append("\">");
                readerData.Append(dataReader["name"]);
                readerData.Append("</li>");
            }
            readerData.Append("</ul>");
        }

        Response.Write(readerData.ToString());

    }
}