manager.aspx.cs

bolog

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


namespace MyBlog
{
	/// <summary>
	/// Manager 的摘要说明。
	/// </summary>
	public partial class Manager : System.Web.UI.Page
	{

			
		private void BindGrid(System.Web.UI.WebControls.DataGrid DataGrid, String strValue)
		{
			String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
			OleDbConnection cn = new OleDbConnection();
			cn.ConnectionString = strConn;

			OleDbDataAdapter myCommand = new OleDbDataAdapter(strValue, cn);
			DataSet ds = new DataSet();
			myCommand.Fill(ds, "webmanager");

			DataGrid.DataSource = ds.Tables["webmanager"].DefaultView;
			DataGrid.DataBind();
			
		}
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{
				if((bool)Session["pwd"] == false)
					Response.Redirect("codeReq.aspx");
				String strValue = "select * from webmanager ";
				BindGrid(managerDataGrid, strValue);
			}
		}

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

		}
		#endregion

		protected void Add_Click(object sender, System.EventArgs e)
		{
			String insertCmd = "insert into webmanager(projectName, projectUrl) values(@projectName, @projectUrl)";
			String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
			OleDbConnection cn = new OleDbConnection();
			cn.ConnectionString = strConn;
			OleDbCommand myCommand = new OleDbCommand(insertCmd, cn);
			myCommand.Parameters.Add(new OleDbParameter("@projectName", OleDbType.VarChar, 50));
			myCommand.Parameters["@projectName"].Value = projectName.Text;
			myCommand.Parameters.Add(new OleDbParameter("@projectUrl", OleDbType.VarChar, 100));
			myCommand.Parameters["@projectUrl"].Value = projectUrl.Text;
			cn.Open();
			try
			{
				myCommand.ExecuteNonQuery();
				Message.Text = "添加成功";
			}
			catch(System.Data.OleDb.OleDbException)
			{
				Message.Text ="出错了";
			}
			cn.Close();
			String strValue = "select * from webmanager ";
			BindGrid(managerDataGrid, strValue);

		}

		private void managerDataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			try
			{
				String deleteCmd = "delete from webmanager where managerID = @managerID";
				String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
				OleDbConnection cn = new OleDbConnection();
				cn.ConnectionString = strConn;
				OleDbCommand myCommand = new OleDbCommand(deleteCmd, cn);
				myCommand.Parameters.Add(new OleDbParameter("@managerID", OleDbType.VarChar, 38));
				myCommand.Parameters["@managerID"].Value = managerDataGrid.DataKeys[e.Item.ItemIndex].ToString();
				cn.Open();
				try
				{
					myCommand.ExecuteNonQuery();
					Message.Text = "删除成功";
				}
				catch(System.Data.OleDb.OleDbException)
				{
					Message.Text ="出错了";
				}
				cn.Close();
				String strValue = "select * from webmanager ";
				BindGrid(managerDataGrid, strValue);
			}
			catch(System.Data.OleDb.OleDbException)
			{
				Message.Text ="出错了";
			}
		}

		protected void btSave_Click(object sender, System.EventArgs e)
		{
			String updateCmd = "update code set code = @code";
			String strConn = ConfigurationSettings.AppSettings["webblog"] + Server.MapPath("WebBlog.mdb");
			OleDbConnection cn = new OleDbConnection();
			cn.ConnectionString = strConn;
			OleDbCommand myCommand = new OleDbCommand(updateCmd, cn);
			myCommand.Parameters.Add(new OleDbParameter("@code", OleDbType.VarChar, 50));
			myCommand.Parameters["@code"].Value = tbPwd.Text;
			cn.Open();
			try
			{
				myCommand.ExecuteNonQuery();
				Label1.Text = "修改成功";
				//Response.Redirect("index.aspx");
			}
			catch(System.Data.OleDb.OleDbException)
			{
				Message.Text ="出错了";
			}
			cn.Close();
		}

	}
}