留言簿完全代码

1、using System;using System.Data;using System.Configuration;using System.Web;usingusingusingusingusingusingpublic partial class _DefaultPage protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) string Con = "Data Source=localhost;User Id=sa

2、;Password=;Initial Catalog=db_lyb" SqlConnection sqlcon = new SqlConnection(Con); sqlcon.Open(); SqlCommand sqlcom2 = new SqlCommand(); sqlcom2.Connection=sqlcon; sqlcom2.CommandText = "select * from tb_user where Uid='"+TextBox1.Text+"'" SqlDataReader read = sqlcom2

3、.ExecuteReader(); read.Read(); if (read.HasRows) Response.Write("<script language=javascript>alert('对不起，该用户已经注册！')</script>"); return; read.Close(); try SqlCommand sqlcom = new SqlCommand(); sqlcom.Connection = sqlcon; sqlcom.CommandText = "Insert into tb_user valu

4、es('" + TextBox1.Text + "','" + TextBox2.Text + "')" sqlcom.ExecuteNonQuery(); Response.Write("<script language=javascript>alert('注册成功!');location='Default2.aspx'</script>"); catch (Exception ex) Response.Write("<

5、script language=javascript>alert('注册失败！')</script>"); sqlcon.Close(); using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;usingusingusingusingusingusingpublic partial class Default2Page protected void Page_Load(object sender, Even

6、tArgs e) protected void Button1_Click(object sender, EventArgs e) string Con = "Data Source=localhost;User Id=sa;Password=;Initial Catalog=db_lyb" SqlConnection sqlcon = new SqlConnection(Con); sqlcon.Open(); SqlCommand sqlcom = new SqlCommand(); SqlCommand sqlcom2 = new SqlCommand(); sqlc

7、om2.Connection = sqlcon; sqlcom2.CommandText = "select * from tb_user where Uid='" + TextBox1.Text + "' and Pwd='"+TextBox2.Text+"'" SqlDataReader read = sqlcom2.ExecuteReader(); read.Read(); if (read.HasRows) Response.Write("<script language=jav

8、ascript>location='Default3.aspx'</script>"); return; else Response.Write("<script language=javascript>alert('用户名或密码错误')</script>"); read.Close(); using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;us

9、ingusingusingusingusingusingpublic partial class Default3Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) string Con = "Data Source=localhost;User Id=sa;Password=;Initial Catalog=db_lyb" SqlConnection sqlcon = new SqlConnect

10、ion(Con); sqlcon.Open(); try SqlCommand sqlcom = new SqlCommand(); sqlcom.Connection = sqlcon; sqlcom.CommandText = "Insert into tb_fb values('" + TextBox1.Text + "','" + TextBox2.Text + "')" sqlcom.ExecuteNonQuery(); Response.Write("<script language=javascript>alert('留言发表成功');location='Default2.aspx'&l