联接Sql Server 查询、插入数据_SQL

连接Sql Server 查询、插入数据

<%@ 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 [email protected]";
                    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();
                }
            }
        }
    }
}