连接Sql Server 查询、插入数据

云深处 · 发表于 2016-11-1 08:43:58

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

账号		自动登录	找回密码
密码			立即注册

c++ size_t 和 int 的区别

HERE 使用 AWS EF 和 JFrog Artifactory 打

C++ 指针大全：从基础到进阶，一篇快速上手

wirelessnetview好用的无线分析工具

Red Hat RHCE 8 (EX294) Cert Guide

亿图图示专家(EDraw Max) V7.9 中文破解版

zabbix3.4.1安装部署+微信推送信息+大屏显

[经验分享] 连接Sql Server 查询、插入数据

浏览过的版块

扫码加入运维网微信交流群