help.aspx.cs

用c#实现的BBS论坛。主要提供了三种角色：游客（没有注册的用户）、已经注册的用户和后台管理员。当游客进入论坛之后

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

public partial class BackDesk_Help : System.Web.UI.Page
{
    DataCon myCon = new DataCon();
    DataOperate sqlBind = new DataOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        FormsAuthentication.SignOut();//清除验证信息
        HttpContext.Current.Session.Clear();//清除Session的内容
        HttpContext.Current.Session.Abandon();//取消当前会话
    }
    protected void lbtnAboutUs_Click(object sender, EventArgs e)
    {
        SqlConnection sqlconn = myCon.getCon();
        sqlconn.Open();
        string sqlstr = "select HelpContent from tb_Help where HelpName='关于我们'";
        SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet mydataset = new DataSet();
        mydataadapter.Fill(mydataset, "tb_Help");
        DataRowView rowview = mydataset.Tables["tb_Help"].DefaultView[0];
        Label1.Text = Convert.ToString(rowview["HelpContent"]);
        sqlconn.Close();
    }
    protected void lbtnBBS_Click(object sender, EventArgs e)
    {
        SqlConnection sqlconn = myCon.getCon();
        sqlconn.Open();
        string sqlstr = "select HelpContent from tb_Help where HelpName='论坛简介'";
        SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet mydataset = new DataSet();
        mydataadapter.Fill(mydataset, "tb_Help");
        DataRowView rowview = mydataset.Tables["tb_Help"].DefaultView[0];
        Label1.Text = Convert.ToString(rowview["HelpContent"]);
        sqlconn.Close();
    }
    protected void lbtnHold_Click(object sender, EventArgs e)
    {
        SqlConnection sqlconn = myCon.getCon();
        sqlconn.Open();
        string sqlstr = "select HelpContent from tb_Help where HelpName='技术支持'";
        SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet mydataset = new DataSet();
        mydataadapter.Fill(mydataset, "tb_Help");
        DataRowView rowview = mydataset.Tables["tb_Help"].DefaultView[0];
        Label1.Text = Convert.ToString(rowview["HelpContent"]);
        sqlconn.Close();
    }
    protected void lbtnNET_Click(object sender, EventArgs e)
    {
        SqlConnection sqlconn = myCon.getCon();
        sqlconn.Open();
        string sqlstr = "select HelpContent from tb_Help where HelpName='关于.NET'";
        SqlDataAdapter mydataadapter = new SqlDataAdapter(sqlstr, sqlconn);
        DataSet mydataset = new DataSet();
        mydataadapter.Fill(mydataset, "tb_Help");
        DataRowView rowview = mydataset.Tables["tb_Help"].DefaultView[0];
        Label1.Text = Convert.ToString(rowview["HelpContent"]);
        sqlconn.Close();
    }
}