admin.aspx.cs

小型BBS 实现基本的论坛功能论坛风格参照了、CSDN论坛、LB论坛、动网论坛的风格,整个论坛的数据库结构设计一流,所以论坛运行速度一流,功能一流 数据库采用、SQL Server

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace Forum
{
	/// <summary>
	/// Admin 的摘要说明。
	/// </summary>
	public partial class Admin : System.Web.UI.Page
	{
		public SqlConnection MyConn;
		public SqlDataReader dr;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			Forum ForumDBO= new Forum();
			MyConn=ForumDBO.Open();
			if (ForumDBO.adminck()=="Wrong")
			{
				Response.Redirect("Exceptions.aspx?ms=9");
			}
			if(!Page.IsPostBack)
			{
				BindGrid();
			}
		}
		ICollection CreateTable()
		{
			string strSel = "select * from ForumInform order by id desc";
			DataSet ds = new DataSet();

			SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,MyConn);
			MyAdapter.Fill(ds,"main");

			return ds.Tables["main"].DefaultView;
		}
		public void BindGrid()
		{
			MyGrid.DataSource = CreateTable();
			MyGrid.DataBind();
		}
		public void DataGrid_EditCommand(Object sender,DataGridCommandEventArgs e)
		{
			string id2=e.Item.Cells[1].Text;
			string str ="select * from ForumInform where id="+id2;
			SqlCommand MyComm = new SqlCommand(str,MyConn);
			dr=MyComm.ExecuteReader();
			while(dr.Read())
			{
				td1.Text=dr["Beg"].ToString();
				td2.Text=dr["End"].ToString();
				td3.Text=dr["TopicDes"].ToString();
				td4.Text=dr["des"].ToString();
				td5.Text=dr["Flag"].ToString();
				td6.Text=dr["Toastmaster"].ToString();
			}
			dr.Close();
			MyGrid.EditItemIndex = (int)e.Item.ItemIndex;
			BindGrid();
		}


		public void DataGrid_CancelCommand(Object sender,DataGridCommandEventArgs e)
		{
			string id=e.Item.Cells[1].Text;
			string del="delete from ForumInform where id="+id;
			SqlCommand MyComm = new SqlCommand(del,MyConn);
			MyComm.ExecuteNonQuery();
			MyComm.CommandText=del;
			del="drop table a"+e.Item.Cells[2].Text+"Topic"+e.Item.Cells[3].Text;
			MyComm.CommandText=del;
			MyComm.ExecuteNonQuery();
			del="drop table a"+e.Item.Cells[2].Text+"Reply"+e.Item.Cells[3].Text;
			MyComm.CommandText=del;
			MyComm.ExecuteNonQuery();
			BindGrid();
		}


		public void DataGrid_UpdateCommand(Object sender,DataGridCommandEventArgs e)
		{

			string Beg = td1.Text.ToString().Replace("'","''");
			string End = td2.Text.ToString().Replace("'","''");
			string name = td3.Text.ToString().Replace("'","''");
			string des  = td4.Text.ToString().Replace("'","''");
			string logo = td5.Text.ToString().Replace("'","''");
			string Toastmaster  = td6.Text.ToString().Replace("'","''");
			string id=e.Item.Cells[1].Text;
			string strUpdate = "update ForumInform set Begin1="+Beg+",end1="+End+",TopicDes='"+name+"',Des='"+des+"',Toastmaster='"+Toastmaster+"' where  id="+id;
			SqlCommand MyComm = new SqlCommand(strUpdate,MyConn);
			MyComm.ExecuteNonQuery();	
			MyGrid.EditItemIndex = -1;
			BindGrid();

		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion
	}
}