连接Sql Server 查询、插入数据

最新推荐文章于 2024-03-29 15:34:12 发布

iteye_4537

最新推荐文章于 2024-03-29 15:34:12 发布

阅读量239

点赞数

文章标签：数据库 xhtml ui

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

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

<%@ 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">

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">

<%@ 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();
}
}
}
}
}