连接Sql server

来源：互联网发布：北京顺义编程培训编辑：程序博客网时间：2024/06/05 14:54

后台代码：

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;

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 connstr = "Data Source=GFWMJ3FJ7JLJJBR;Initial Catalog=ZT_DB.MDF;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 person where person_name=@u";

cmd.Parameters.Add(new SqlParameter("u",txtUserName.Text));

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())

{

if (reader.GetString(reader.GetOrdinal("pwd")) == txtPassword.Text)

{

Response.Redirect("Page1.aspx");

}

else

{

Label1.Text = "密码不正确";

}

else

{

Label1.Text = "用户名不存在!";

}

<%@ Page Language="C#" CodeFile="Login.aspx.cs" Inherits="Login" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<table>

<tr>

<td>

<asp:TextBox ID="txtUserName" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td>

<asp:TextBox ID="txtPassword" runat="server" TextMode="Password"></asp:TextBox></td>

</tr>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text=""></asp:Label></td>

</tr>

</table>

</div>

</form>

</body>

</html>