user_register.aspx.cs

B2B网上商城

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.SqlClient;
using System.Configuration;

public partial class User_Register : System.Web.UI.Page
{
    public DBConnection conn = new DBConnection();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button2_Click(object sender, System.EventArgs e)
    {
        //普通加密
        //获得要加密的字段，并转化为Byte[]数组
        /*byte[] data=System.Text .Encoding .Unicode .GetBytes (TextBox2.Text .ToCharArray ());
        //建立加密服务
        System.Security .Cryptography .MD5 md5=new System.Security .Cryptography.MD5CryptoServiceProvider ();
        //加密Byte[]数组
        byte[] result=md5.ComputeHash (data);
        //将加密后的数组转化为字段
        string sResult=System.Text.Encoding .Unicode .GetString (result);*/
        //显示普通加密
        //Label31.Text ="MD5普通加密："+sResult.ToString ()+"<br>";

        //作为密码方式加密
        string EnPswdStr = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox2.Text.ToString(), "MD5");
        String username, truename, password, sex, qq, idcard, homepage, phone, address, postalcode, email, question, answer, checkcode, sql;
        SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);//数据库连接的类
        username = TextBox1.Text;
        truename = TextBox7.Text;
        password = EnPswdStr;
        sex = Radio.SelectedItem.Value;
        qq = TextBox8.Text;
        idcard = TextBox9.Text;
        homepage = TextBox10.Text;
        phone = TextBox11.Text;
        address = TextBox12.Text;
        postalcode = TextBox15.Text;
        email = TextBox4.Text;
        question = TextBox13.Text;
        answer = TextBox14.Text;
        checkcode = TextBox6.Text;
        sql = "select * from Users where UserName='" + username + "'";
        SqlDataReader dr = conn.ExecuteReader(sql);//返回结果集
        while (dr.Read())
        {
            Response.Write("<script language='JavaScript'>");
            Response.Write("alert('此会员名已存在！请重新输入一个！')");
            Response.Write("</script>");
            TextBox1.Text = "";
            TextBox6.Text = "";
            return;
        }
        dr.Close();
        if (Session["CheckCode"].ToString() != checkcode)
        {
            Response.Write("<script language='JavaScript'>");
            Response.Write("alert('输入的验证码有误！请重新输入！')");
            Response.Write("</script>");
            return;
        }
        sql = "Insert into Users(UserName,TrueName,PassWord,Sex,QQ,IDCard,HomePage,Phone,Address,Email,Question,Answer) values('" + username + "','" + truename + "','" + password + "','" + sex + "','" + qq + "','" + idcard + "','" + homepage + "','" + phone + "','" + address + "','" + email + "','" + question + "','" + answer + "')";
        /*SqlCommand command=new SqlCommand (sql,connection);//构造执行数据库命令 
        connection.Open();//打开数据库
        command.ExecuteNonQuery();//执行语句
        connection.Close();*/
        conn.Updata(sql);
        Response.Write("<script language='JavaScript'>");
        Response.Write("alert('注册成功，欢迎加入我们！');");
        Response.Write("window.open('User_Login.aspx');</script>");
    }
}