reg.aspx.cs

这是asp.net的校友录程序

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.OleDb;

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

		private ArrayList alYear;
		private ArrayList alMonth;
		private ArrayList alDay;
		int i;

		//数据库操作相关变量
		string strConn;
		string strSQL;
		OleDbConnection cn;
		OleDbCommand cmd;
		protected System.Web.UI.WebControls.Calendar Cal1;

		
		OleDbDataReader dr;
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				step1.Visible=true;
				step2.Visible=false;
				step3.Visible=false;
				step4.Visible=false;

				alYear=new ArrayList();				
				alMonth=new ArrayList();				
				alDay=new ArrayList();				

				for(i=1972;i<1989;i++)
					alYear.Add(i.ToString());

				for(i=1;i<=12;i++)
					alMonth.Add(i.ToString());

				for(i=1;i<32;i++)
					alDay.Add(i.ToString());

				ddlYear.DataSource=alYear;
				ddlYear.DataBind();

				ddlMonth.DataSource=alMonth;
				ddlMonth.DataBind();

				ddlDay.DataSource=alDay;
				ddlDay.DataBind();				
			}


			
			
		}


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

		}
		#endregion

		protected void btnAgree_Click(object sender, System.EventArgs e)
		{
			step1.Visible=false;
			step2.Visible=true;
			step3.Visible=false;
			step4.Visible=false;
		}


		protected void btnNext_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid)
			{
				strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("txl.aspx");
				cn=new OleDbConnection(strConn);
				strSQL="select u_id from userinfo where u_account='"+txtAccount.Text.ToString()+"'";
				//strSQL="select u_id from userinfo where u_account='juw'";
				cn.Open();
				cmd=new OleDbCommand(strSQL,cn);
				dr=cmd.ExecuteReader();
				if(dr.Read())
				{
					lblStep2.Text="您输入的用户名已经存在，请您选择一个其他的名字！";
					cn.Close();
					
					//txtAccount.Text="";
				}
				else
				{
					cn.Close();
					lblPwd.Text=txtUpwd.Text.ToString();
					step1.Visible=false;
					step2.Visible=false;
					step3.Visible=true;
					step4.Visible=false;

				}
			}			
		}


		protected void btnOK_Click(object sender, System.EventArgs e)
		{

					if(Page.IsValid)
					{

						step1.Visible=false;
						step2.Visible=false;
						step3.Visible=false;
						step4.Visible=true;
						span1.InnerHtml="您输入的信息是："+"<br>";						
						span1.InnerHtml+="登录名："+txtAccount.Text.ToString()+"<br>";
						span1.InnerHtml+="姓名："+txtUname.Text.ToString()+"<br>";
						span1.InnerHtml+="性别："+rltSex.SelectedItem.Text.ToString()+"<br>";
						span1.InnerHtml+="生日："+ddlYear.SelectedItem.Text.ToString()+"年"+ddlMonth.SelectedItem.Text.ToString()+"月"+ddlDay.SelectedItem.Text.ToString()+"日"+"<br>";
						span1.InnerHtml+="工作单位："+txtUjob.Text.ToString()+"<br>";
						span1.InnerHtml+="商务电话："+txtUtel1.Text.ToString()+"<br>";
						span1.InnerHtml+="宅电："+txtUtel2.Text.ToString()+"<br>";
						span1.InnerHtml+="移动电话："+txtUtel3.Text.ToString()+"<br>";
						span1.InnerHtml+="寻呼机："+txtUpager.Text.ToString()+"<br>";
						span1.InnerHtml+="通讯地址："+txtUaddr.Text.ToString()+"<br>";
						span1.InnerHtml+="邮政编码："+txtUzip.Text.ToString()+"<br>";
						span1.InnerHtml+="E_mail："+txtUemail.Text.ToString()+"<br>";
						span1.InnerHtml+="ICQ："+txtUicq.Text.ToString()+"<br>";
						span1.InnerHtml+="Oicq："+txtUqq.Text.ToString()+"<br>";

					}	

		}


		public void btnSave_Click(object sender, System.EventArgs e)
		{

			if(Page.IsValid)
			{
				strSQL="INSERT INTO userinfo(u_name,u_account,u_pwd,u_sex,u_bth,u_regdate,u_tel1,u_tel2,u_tel3,u_addr,u_zip,u_email,u_job,u_icq,u_qq,u_grp) VALUES('";
				strSQL+=txtUname.Text.ToString()+"','";
				strSQL+=txtAccount.Text.ToString()+"','";
				strSQL+=lblPwd.Text.ToString()+"','";
				strSQL+=rltSex.SelectedItem.Text.ToString()+"','";
				strSQL+=ddlYear.SelectedItem.Text.ToString()+"-"+ddlMonth.SelectedItem.Text.ToString()+"-"+ddlDay.SelectedItem.Text.ToString()+"','";
				strSQL+=DateTime.Today.ToString()+"','";
				strSQL+=txtUtel1.Text.ToString()+"','";
				strSQL+=txtUtel2.Text.ToString()+"','";
				strSQL+=txtUtel3.Text.ToString()+"','";
				strSQL+=txtUaddr.Text.ToString()+"','";
				strSQL+=txtUzip.Text.ToString()+"','";
				strSQL+=txtUemail.Text.ToString()+"','";
				strSQL+=txtUjob.Text.ToString()+"','";
				strSQL+=txtUicq.Text.ToString()+"','";
				strSQL+=txtUqq.Text.ToString()+"',1)";
				

				strConn="provider=Microsoft.Jet.OLEDB.4.0;data source="+Server.MapPath("txl.aspx");
				cn=new  OleDbConnection(strConn);
				cmd=new OleDbCommand(strSQL,cn);
				cn.Open();
				cmd.ExecuteNonQuery();

				strSQL="select u_id from userinfo where u_account='"+txtAccount.Text.ToString()+"'";
				cmd=new OleDbCommand(strSQL,cn);				
				dr=cmd.ExecuteReader();
				while(dr.Read())
					Session["uid"]=dr["u_id"];
				dr.Close();
				cn.Close();
				//cn.Close();
                
				Page.Response.Redirect("welcome.aspx");

			}
			

		}


		protected void btnReturn_Click(object sender, System.EventArgs e)
		{
			step1.Visible=false;
			step2.Visible=false;
			step3.Visible=true;
			step4.Visible=false;
		
		}


		protected void Date_SelectIndexChanged(object sender,System.EventArgs e)
		{
			int[] numbers = {31,28, 31, 30, 31,30,31,31,30,31,30,31};
			if((Convert.ToInt32(ddlYear.SelectedItem.Text.ToString())%4)==0)
				numbers[1]=29;

			alDay=new ArrayList();
			for(i=1;i<=numbers[Convert.ToInt32(ddlMonth.SelectedItem.Text.ToString())-1];i++)
				alDay.Add(i.ToString());
			ddlDay.DataSource=alDay;
			ddlDay.DataBind();
		}




	}
}