readnews.aspx.cs

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

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 ReadNews : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        int newsid = Convert.ToInt32(Request.QueryString["id"].ToString());

        string strConnection = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("DB_51aspx\\Data.mdb");
        //创建数据库连接对象
        OleDbConnection myconn = new OleDbConnection(strConnection);
        //打开数据库连接
        myconn.Open();
        string sql = "select A.Title,A.Content,A.AddTime,A.Author,A.ReadCishu, B.BigClassName from News A ,BigClass B Where B.BigClassID = A.BigClassID And A.ID =" + newsid;

        //创建数据库命令
        OleDbCommand mycmd = new OleDbCommand(sql, myconn);
        OleDbDataReader dr = mycmd.ExecuteReader();
        if (dr.Read())
        {
            lbl_class.Text = dr["BigClassName"].ToString();
            lbl_content.Text = dr["Content"].ToString();
            lbl_title.Text = dr["Title"].ToString();
            lbl_info.Text = "作者：" + dr["Author"].ToString() + "     时间：" + dr["AddTime"].ToString() + "阅读：" + dr["ReadCishu"].ToString() + "次";
        }
        int n = Convert.ToInt32(dr["ReadCishu"].ToString())+1;
        myconn.Close();
        UpdateNews(newsid,n);
    }
    protected void UpdateNews(int id, int n)
    {
        string strConnection = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("DB_51aspx\\Data.mdb");
        //创建数据库连接对象
        OleDbConnection myconn = new OleDbConnection(strConnection);
        //打开数据库连接
        myconn.Open();
        string sql = "Update News Set ReadCishu=" + n + " Where ID = " + id;
        //创建数据库命令
        OleDbCommand mycmd = new OleDbCommand(sql, myconn);
        mycmd.ExecuteNonQuery();
    }
}