连接Sql Server 查询、插入数据

本文介绍了一个使用ASP.NET实现的简单登录与注册系统的代码示例。该系统包括登录页面、注册页面及相应的后台处理逻辑,通过SQL Server进行数据验证与存储。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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="登陆" onclick="btnLogin_Click" /></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="注册"
onclick="btnRegister_Click" /></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();
}
}
}
}
}


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值