register.aspx.cs

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

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

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 register : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
            
    }
    /// <summary>
    /// 检查是否已注册
    /// </summary>
    void check_registered()
    {
        string strSql1 = "select * from users where fname='"+Request.Form["fname"].Trim().ToString()+"'";
        string strConn1 = ConfigurationManager.ConnectionStrings["sq_chaletshopConnectionString"].ToString();
        SqlConnection conn1= new SqlConnection(strConn1);
        SqlCommand sqlcom1 = new SqlCommand(strSql1, conn1);
        conn1.Open();
        SqlDataReader reader = sqlcom1.ExecuteReader();
        if (reader.Read())
        {
            Response.Write("<script language='javascript'>alert('用户名已被注册!');</script>");
            Response.Write("<script language='javascript'>window.history.go(-1);</script>");
        }
        conn1.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        check_registered();
        //获取各个表单的值
        string fname = this.fname.Text.Trim();
        string sex;
        if (sex_0.Checked)
            sex = sex_0.Text;
        else
            sex = sex_1.Text;
        string address = this.address.Text.Trim();
        string age = this.age.Text.Trim();
        string ID2 = this.ID2.Text.Trim();
        string phone = this.phone.Text.Trim();
        string fax = this.fax.Text.Trim();
        string email = this.email.Text.Trim();
        string password = this.password.Text.Trim();
        string strTime = DateTime.Now.ToShortDateString(); //取得日期
        //构造sql插入语句
        string sqlstr = "insert into users(fname,sex,address,age,ID2,phone,fax,email,password,Regtime) values(";
        sqlstr += "'" + fname + "','" + sex + "','" + address + "','" + age + "','" + ID2 +  "','" + phone + "','" + fax + "','" + email + "','" + password + "','" + strTime + "')";
        //将各个表单值存储到数据库
        try
        {