register.aspx.cs

网上书店 含用户注册

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Web;
using System.IO;
using System.Web.Security;
using System.Web.SessionState;
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 _Default : System.Web.UI.Page 
{
    string filename;//定义一个字符串变量表示上传文件的名称
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {
        if (args.Value.Length >= 6)//验证密码长度是否大于6位
        {
            args.IsValid = true;
        }
        else
        {
            args.IsValid = false;
        }
    }

    protected void tijiao_Click(object sender, EventArgs e)//“提交”按钮的单击事件
    {
        string sql1 = "select count(*) from tbluser where userName='" + TextBox1.Text + "'";
        int i = int.Parse(Class1.SelOne(sql1));
        if (i == 0)
        {
          
            string xingbie;
            if (boy.Checked)
            {
                xingbie = "男";
            }
            else
            {
                xingbie = "女";
            }


           //上传个人照片
            filename = FileUpload1.FileName.ToString();
            string filepath = Server.MapPath("image");
            FileUpload1.SaveAs(filepath + "\\" + filename);
             
            //数据库中插入一条新语句
            string sql = "insert into tbluser (userName,userPwd,trueName,address,telephone,Email,sex,userType,userImage) values ('" + TextBox1.Text + "','" + TextBox2.Text + " ','" + TextBox4.Text + " ',' " + TextBox5.Text + "','" + TextBox6.Text + " ',' " + TextBox7.Text + " ','" + xingbie + "','" + 0 + "','" + filename + "')";
            Class1.ExecSql(sql);
            Response.Write("<script language='javascript'>alert('提交成功');</script>");
            Response.Redirect("login.aspx");
        }
        else
        {
            Response.Write("<script language='javascript'>alert('对不起，用户名不可用');</script>");
        }
       
    }
    protected void report_Click(object sender, EventArgs e)//“重置”按钮的单击事件
    {
        TextBox1.Text =" ";
        TextBox2.Text =" ";
        TextBox3.Text =" ";
        TextBox4.Text =" ";
        TextBox5.Text =" ";
        TextBox6.Text =" ";
        TextBox7.Text =" ";
        boy.Checked = true;
        girl.Checked = false;
    }
    protected void jiance_Click(object sender, EventArgs e)//检测用户名是否已存在
    {
        string sql = "select count(*) from tbluser where userName='"+TextBox1.Text+"'";
        int i = int.Parse(Class1.SelOne(sql));
        if (i == 0)
        {
            Response.Write("<script language='javascript'>alert('恭喜你，用户名可用');</script>");
        }
        else
        {
            Response.Write("<script language='javascript'>alert('对不起，用户名不可用');</script>");
        }
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {

    }
}