note.aspx.cs

来自「ajax 三层软件开发实例,三层软件开发实例」· CS 代码 · 共 29 行

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 System.Data.OleDb;

public partial class UI_note : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/myPage.mdb");
        OleDbConnection oleDbCon = new OleDbConnection(strConnection);
        oleDbCon.Open();
        OleDbCommand oleDbCom = new OleDbCommand("select * from blogNote", oleDbCon);
        OleDbDataAdapter oleDa = new OleDbDataAdapter(oleDbCom);
        DataSet ds = new DataSet();
        oleDa.Fill(ds);
        this.Repeater1.DataSource = ds.Tables[0].DefaultView;
        this.Repeater1.DataBind();
        oleDbCon.Close();
    }
}