adduser.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class AddUser : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    //检测用户名是否存在
    public int CheckUser()
    {
        SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        int intCount = 0;
        if (txtLoginName.Text == "")
        {
            Response.Write("<script language='javascript'>alert('会员登录名不能为空！');</script>");
             intCount = 5;
            return intCount;
        }
        else
        {
            string sqlstr = "select * from tb_Member where MemberName='" + this.txtLoginName.Text + "'";
            sqlconn.Open();
            SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
            intCount = Convert.ToInt32(sqlcom.ExecuteScalar());
            sqlconn.Close();
        }
        return intCount;
    }
    protected void btnTest_Click(object sender, EventArgs e)
    {
        int intCount = CheckUser();//调用方法检测用户名是否存在
        if (intCount == 5)
        { return; }
        if (intCount != 0)
        {
            Response.Write("<script language='javascript'>alert('该会员已经注册过');</script>");
            return;
        }
        else
        {
            Response.Write("<script language='javascript'>alert('您可以进行正常注册');</script>");
        }
       
      
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
       
    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {

      
    }
   //注册
    protected void Button2_Click(object sender, EventArgs e)
    {
        int intCount = CheckUser();//调用方法检测用户名是否存在
        if (intCount != 0)
        {
            Response.Write("<script language='javascript'>alert('该会员已经注册过');</script>");
            return;
        }
        string sqlstr = "insert into tb_Member "
            + "values('" + txtLoginName.Text + "','" + ddlSex.SelectedValue
            + "','" + txtPwd.Text + "','" + txtQuePwd.Text
            + "','" + txtAnsPwd.Text + "','" + txtEmail.Text + "')";
        SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand(sqlstr, sqlconn);
        sqlcom.ExecuteNonQuery();
        sqlconn.Close();
        Session["username"] = txtLoginName.Text.Trim();//将用户名存储在Session中
        Response.Redirect("Login.aspx");

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        txtLoginName.Text = "";
        txtPwd.Text = "";
        txtQuePwd.Text = "";
        txtSurePassword.Text = "";
        txtEmail.Text = "";
        txtLoginName.Focus();
    }
}