register.aspx.cs

visual stdio 2005

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.IO;
using System.Data.OleDb;

   
public partial class Register : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {
        
       
    }
    protected void btnReister_Click(object sender, EventArgs e)
    {
        string StrCoon = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("BDB/BookStore.mdb");
        OleDbConnection cnA=new OleDbConnection ();
        cnA.ConnectionString = StrCoon;
        cnA .Open ();

        string UserName=this.tbUsername .Text ;
        string Password=this.tbPassword .Text ;
        string  Email=this.tbemail .Text ;
        string strsql=" SELECT *from userinfo where username='"+UserName+"'";
        OleDbCommand cmA= new OleDbCommand (strsql ,cnA );
        OleDbDataReader drA = cmA.ExecuteReader();
        if (drA.Read())
        {
            Response.Write("<script>alert('您的用户名已注册过，请直接登陆')</script>");
            cnA.Close();
            //Response.Redirect("Default.aspx");
        }
        else
        {    Response.Write("<script>alert('注册成功，请登录')</script>");
            string sqlinsert = " INSERT INTO [userinfo] ([username], [password], [email]) VALUES ('" + UserName + "','" + Password + "','" + Email + "')";
            OleDbCommand ccma = new OleDbCommand(sqlinsert, cnA);
            ccma.ExecuteNonQuery();
            Session["name"] =UserName;
            Response.Redirect("Default.aspx");
            cnA.Close();
        }  
       
        }
    }