newsdetails.aspx.cs

C#+ACCESS在线选课系统的设计与实现

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 studnet_NewsDetails : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            newdatabinder();
        }
    }
    private void newdatabinder()
//查看新闻内容函数方法
    {
        string str;
        str = Request.QueryString["qid"].ToString();
        OleDbConnection  con = db.con();
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select  * from  News    where qid=@qid", con);

        cmd.Parameters.Add("@qid", SqlDbType.VarChar);
        cmd.Parameters["@qid"].Value = str;
        OleDbDataReader sdr = cmd.ExecuteReader();
        if (sdr.Read())
        {
            this.label1.Text = "问题标题：" + sdr["Nname"].ToString() + "<br>" + "发表时间：" + sdr["Ntime"].ToString();
            this.labelnewsdetail.Text = "问题内容：" + sdr["Ncount"].ToString();


        }
    }
}