admin_useradd.aspx.cs

非常完整的新闻发布系统

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

namespace WebNews.admin
{
	/// <summary>
	/// admin_useradd 的摘要说明。
	/// </summary>
	public class admin_useradd : System.Web.UI.Page
	{
		protected System.Data.SqlClient.SqlConnection SqlConnection1;//添加数据库的操作对象
		protected System.Data.SqlClient.SqlDataAdapter SqlDataAdapter1;
		protected System.Data.DataSet DataSet1;
		protected System.Data.SqlClient.SqlCommand SqlCommand1;
		protected System.Data.SqlClient.SqlDataReader SqlDataReader1;

		protected System.Web.UI.WebControls.Button Submit;
		protected System.Web.UI.WebControls.TextBox Remarks;
		protected System.Web.UI.WebControls.DropDownList UserClass1;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator5;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.TextBox Password2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator Requiredfieldvalidator4;
		protected System.Web.UI.WebControls.TextBox Password1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator;
		protected System.Web.UI.WebControls.TextBox Username1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.Label myLabel;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		}

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

		}
		#endregion

		private void Submit_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid )
			{
				SqlConnection1 = new SqlConnection(ConfigurationSettings.AppSettings["dsn"]);
				SqlCommand1=new SqlCommand("sp_addAdminValidate",SqlConnection1); 
				SqlCommand1.CommandType=CommandType.StoredProcedure;
				SqlCommand1.Parameters.Add("@username",SqlDbType.Char,40);
				SqlCommand1.Parameters["@username"].Value =Username1.Text.Trim();
				try
				{
					SqlConnection1.Open();
					SqlDataReader1=SqlCommand1.ExecuteReader();	
					if(SqlDataReader1.Read()==true)   
					{
						myLabel.Text="已有此管理员，请重新输入姓名！！" ;
						SqlDataReader1.Close();
					}
					else
					{
						SqlDataReader1.Close();
						SqlCommand1=new SqlCommand("sp_addAdmin",SqlConnection1); 
						SqlCommand1.CommandType=CommandType.StoredProcedure;
						SqlCommand1.Parameters.Add("@username", SqlDbType.Char,40);
						SqlCommand1.Parameters["@username"].Value =Username1.Text.Trim();
						SqlCommand1.Parameters.Add("@password",SqlDbType.Char,40);
						SqlCommand1.Parameters["@password"].Value = Password1.Text.Trim();
						SqlCommand1.Parameters.Add("@userclass",SqlDbType.Char,20);
						SqlCommand1.Parameters["@userclass"].Value = UserClass1.SelectedItem.Text.Trim();
						SqlCommand1.Parameters.Add("@remark",SqlDbType.NChar,200);
						SqlCommand1.Parameters["@remark"].Value = Remarks.Text.Trim();
						try
						{
							int i=SqlCommand1.ExecuteNonQuery();
							if(i>0)
							{
								myLabel.Text="添加管理员成功！";
							}						
						}
						catch (SqlException e1)
						{
							myLabel.Text ="数据库操作错误："+e1.Message;
						}
					}
				}
				catch (SqlException e1)
				{
					myLabel.Text ="数据库操作错误："+e1.Message;
				}
				finally
				{
					SqlDataReader1.Close();
					SqlConnection1.Close();
				}
			}
		}

	}
}