连接Sql Server 查询、插入数据
Login.aspx:<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="Application.数据库.Login" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr><td>用户名：</td><td>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td><td><span class="red">*</span></td></tr>
<tr><td>密 码：</td><td>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox></td><td><span class="red">*</span></td></tr>
<tr><td>
<asp:Button ID="btnLogin" runat="server" Text="登陆"/></td><td></td><td>
<asp:Button ID="btnRegister" runat="server" Text="注册" /></td></tr>
</table>
<asp:Label ID="lblErrorMessage" runat="server" Text="Label" Visible="False"></asp:Label>
</div>
</form>
</body>
</html>
Login.aspx.cs:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace Application.数据库
{
public partial class Login : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassword.Text;
string connStr = "Data Source=PC_THINK-THINK;Initial Catalog=User;Persist Security Info=True;User ID=sa;Password=111111";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from T_Users where FuserName=@name";
cmd.Parameters.Add(new SqlParameter("@name", username));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
string pwd = reader.GetString(reader.GetOrdinal("Fpassword"));
if (pwd == password)
{
Response.Redirect("~/数据库/Welcome.aspx");
}
else
{
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text = "密码错误";
}
}
else
{
this.lblErrorMessage.Text = "用户名不存在！";
}
}
}
}
}
}
Welcome.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Welcome.aspx.cs" Inherits="Application.数据库.Welcome" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
欢迎登陆
</div>
</form>
</body>
</html>
register.aspx向数据库插入数据:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Register.aspx.cs" Inherits="Application.数据库.Register" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.red
{
color:Red;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr><td>用户名：</td><td>
<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td><td><span class="red">*</span><asp:RequiredFieldValidator ID="RequiredFieldValidator1"
runat="server" ErrorMessage="请输入用户名！" ControlToValidate="txtUserName"
ForeColor="Red"></asp:RequiredFieldValidator></td></tr>
<tr><td>密 码：</td><td>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox></td><td><span class="red">*</span><asp:RequiredFieldValidator ID="RequiredFieldValidator2"
runat="server" ErrorMessage="请输入密码!" ControlToValidate="txtPassword"
ForeColor="Red"></asp:RequiredFieldValidator></td></tr>
<tr><td>邮箱：</td><td>
<asp:TextBox ID="Email" runat="server"></asp:TextBox></td><td><span class="red">*</span><asp:RequiredFieldValidator ID="RequiredFieldValidator3"
runat="server" ErrorMessage="请输入邮箱账号！" ControlToValidate="Email"
ForeColor="Red"></asp:RequiredFieldValidator></td></tr>
<tr><td></td> <td> <asp:Button ID="btnRegister" runat="server" Text="注册"
/></td><td>
</td></tr>
</table>
</div>
</form>
</body>
</html>
register后台：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace Application.数据库
{
public partial class Register : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnRegister_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassword.Text;
string email = Email.Text;
string connStr = "Data Source=PC_THINK-THINK;Initial Catalog=User;Persist Security Info=True;User ID=sa;Password=111111";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_Users(FuserName,FPassword,FEmail) values(@name,@password,@email)";
cmd.Parameters.Add(new SqlParameter("@name", username));
cmd.Parameters.Add(new SqlParameter("@password", password));
cmd.Parameters.Add(new SqlParameter("@email", email));
cmd.ExecuteNonQuery();
}
}
}
}
}
页:
[1]