NewUser.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Security;
namespace MyPetShop
{
    public partial class NewUser : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            DB db = new DB();
            SqlConnection con = db.GetCon();//连接数据库
            con.Open();//打开连接
            //SqlConnection con = new SqlConnection();
            //con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\MyPetShop.mdf;Integrated Security=True;User Instance=True";
            //con.Open ();
            SqlCommand cmd=new SqlCommand("select UserName from UserInf",con);
            SqlDataReader sdr=cmd.ExecuteReader();
            int i=0;
            while(sdr.Read())
            {
                if (txtName.Text.Equals(sdr["UserName"]))
                {
                    i = 1; break;
                }
                else
                {
                    i = 0; continue;
                }
            }
            sdr.Close();
            if(i==1)
                Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('该用户已经注册!');</script>");
            if(i==0)
            {
                 if (txtCode.Text.ToUpper() == Session["validateNum"].ToString())
                 {
                     SqlCommand cmd1=new SqlCommand("insert into UserInf(UserName,UserPwd,UserQes,UserAns,UserEmail) values('"+txtName.Text.ToString()+"','"+txtPwd.Text.ToString()+"','"+txtQue.Text.ToString()+"','"+txtAns.Text.ToString()+"','"+txtEmail.Text.ToString()+"')",con);
                     cmd1.ExecuteNonQuery();
                     Page.ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('恭喜你，注册成功！');</script>");
                     txtName.Text = "";
                     txtPwd.Text = "";
                     txtpwdq.Text = "";
                     txtQue.Text = "";
                     txtAns.Text = "";
                     txtEmail.Text = "";
                     txtCode.Text = "";
                     //Response.Redirect("~/Login.aspx");
                 }
            }