web开发练习题
using System.Data;
using System.Data.SqlClient;
protected void Button1_Click(object sender, EventArgs e) //登录 {
String user = username.text; String psd = password.text;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=LHAN-PC\\SQLEXPRESS;Initial Catalog=test;Integrated Security=True"; conn.Open();
string sqlstr = "SELECT COUNT(*) FROM users where [username]='"+user+"' and [password]='"+psd+"'";
SqlCommand comm = new SqlCommand(sqlstr, conn); int num = Convert.ToInt32(comm.ExecuteScalar()); if (num > 0) {
Response.Redirect("welecome.aspx"); } else
Response.Write("用户密码输入有误！"); conn.Close(); }
protected void Button2_Click(object sender, EventArgs e) //注册 {
Response.Redirect("register.aspx"); } 注册页面
<%@ Page Language="C#" %> <body>
<form id="form1" runat="server">
<asp:Label ID="Label1" runat="server" Text="用户名："></asp:Label> <asp:TextBox ID="username" runat="server"></asp:TextBox> <ASP:RequiredFieldValidator id="Validator1" Runat="Server" ControlToValidate="username" ErrorMessage="用户名不能为空" Display="static">用户名不能为空 </ASP:RequiredFieldValidator>
<asp:Label ID="Label2" runat="server" Text="密码："></asp:Label>