登陸的button中 連接數(shù)據(jù)庫 conn.Open(); string str="select * from biao where name='"+TextBox1.Text+"' and password= '"+TextBox2.Text+"'"; sqlcommand comm=new sqlcommand(str,conn); sqldatareader dr=comm.executereader(); if(dr.read()) {response.write("<script> alert('恭喜成功登陸！‘)</script>");} else { 還是上邊那個(gè)改成 登陸失敗 } 登陸 string ConnStr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True"; SqlConnection conn = new SqlConnection(ConnStr); conn.Open(); SqlCommand mycomm = new SqlCommand("select * from Table3 ", conn); SqlDataReader m1; m1 = mycomm.ExecuteReader(); while (m1.Read()) { if ((TextBox1.Text.ToString() == m1[0].ToString()) && (TextBox2.Text.ToString() == m1[1].ToString())) Response.Redirect("WebForm1.aspx"); } 這個(gè)也是登陸 protected void Button1_Click(object sender, EventArgs e) { string ConnStr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True"; SqlConnection conn = new SqlConnection(ConnStr); 連接數(shù)據(jù)庫 conn.Open(); string str = "select * from [userinfo] where Name='"+this.TextBox1.Text+"' and Password='"+this.TextBox2.Text+"'"; SqlCommand com = new SqlCommand(str,conn); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { Response.Write("<script>alert('恭喜你！登錄成功！')</script>"); } else { Response.Write("<script>alert('很遺憾！登錄失??！')</script>"); }　　} 注冊(cè) string ConnStr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True"; SqlConnection conn = new SqlConnection(ConnStr); conn.Open(); SqlCommand mon = conn.CreateCommand(); mon.CommandText = "insert into Table3 values ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox7.Text + "')"; try { int a = mon.ExecuteNonQuery(); Label3.Text = "注痢?冊(cè)á成é功|！?您ú的?用?戶§名?為a：阰" + TextBox1.Text + " 密ü碼?：阰" + TextBox2.Text + ""; } catch (Exception ee) { Label1.Text = "用?戶§名?已?經(jīng)-存?在ú！?"; } if (TextBox1.Text == "") { Label1.Text = "請(qǐng)?輸?入?用?戶§名?！?"; } if (TextBox2.Text == "") { Label2.Text = "請(qǐng)?輸?入?密ü碼?！?"; } if ((TextBox2.Text) == (TextBox3.Text)) { Label2.Text = "兩?次?密ü碼?相à同?"; } 兩種登陸 一種注冊(cè)

//已發(fā)郵箱，注意查收。js部分代碼如下：    <script>        function $(id){            return document.getElementById(id)        }        function clear_msg(){            set_msg('');        }        function set_msg(msg){            $("tipmsg").innerHTML = msg;        }        function check_form(){            clear_msg();            var username = $('username').value,                password = $('password').value,                repasswd = $('repasswd').value,                sex      = $('sex').value,                email    = $('email').value;            if(!/^[a-zA-Z]/.test(username)){                set_msg("請(qǐng)輸入用戶名，并以字母開頭");                return false;            }            if(password.length == 0){                set_msg("請(qǐng)輸入密碼");                return false;            }            if(password!=repasswd){                set_msg("兩次密碼不一致，請(qǐng)修改");                return false;            }            if(sex.length == 0){                set_msg("請(qǐng)選擇性別");                return false;            }            if(!/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/.test(email)){                set_msg("郵箱為空或格式不正確");                return false;            }            set_msg('<span style="color:#00ff00;">恭喜你?。?！通過驗(yàn)證了</span>');            return false;//防止表單提交，如果后臺(tái)有接口改為return true; 就可以提交表單了        }    </script>

//已發(fā)郵箱，注意查收。js部分代碼如下：    <script>        function $(id){            return document.getElementById(id)        }        function clear_msg(){            set_msg('');        }        function set_msg(msg){            $("tipmsg").innerHTML = msg;        }        function check_form(){            clear_msg();            var username = $('username').value,                password = $('password').value,                repasswd = $('repasswd').value,                sex      = $('sex').value,                email    = $('email').value;            if(!/^[a-zA-Z]/.test(username)){                set_msg("請(qǐng)輸入用戶名，并以字母開頭");                return false;            }            if(password.length == 0){                set_msg("請(qǐng)輸入密碼");                return false;            }            if(password!=repasswd){                set_msg("兩次密碼不一致，請(qǐng)修改");                return false;            }            if(sex.length == 0){                set_msg("請(qǐng)選擇性別");                return false;            }            if(!/^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/.test(email)){                set_msg("郵箱為空或格式不正確");                return false;            }            set_msg('<span style="color:#00ff00;">恭喜你?。?！通過驗(yàn)證了</span>');            return false;//防止表單提交，如果后臺(tái)有接口改為return true; 就可以提交表單了        }    </script>

<%Dim connweb, connstrconnstr = "provider=sqloledb;data source=IP地址或機(jī)器名;uid=用戶名;pwd=登錄密碼;database=數(shù)據(jù)庫名;"Set connweb = server.createobject("adodb.connection")connweb.open connstr%>