default.aspx.cs

一个实现新闻基本功能（文章添加、删改、列表、后台管理

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string strConnection = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source="+ Server.MapPath("DB_51aspx\\Data.mdb");
        //创建数据库连接对象
        OleDbConnection myconn = new OleDbConnection(strConnection);
        //打开数据库连接(edit by 51aspx.com)
        myconn.Open();
        //创建查询语句
        string sql = "select * from News";

        //创建数据库命令
        OleDbCommand mycmd = new OleDbCommand(sql, myconn);
        OleDbDataReader result = mycmd.ExecuteReader();
        newslist.DataSource = result;
        newslist.DataBind();
        
    }

}