Ajax+asp.net实现用户登陆_实用技巧_

 
登录
用户名：
密码：

 using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; namespace AJAXtest { public class DAL { private string connstr = "server=acer-pc;database=mydatabase;user id=sa;password=123456"; public DataTable selectDB(string sql) { DataTable dt = new DataTable(); try { SqlConnection conn = new SqlConnection(connstr); SqlDataAdapter sda = new SqlDataAdapter(sql, conn); sda.Fill(dt); } catch(Exception e) {} return dt; } } } 

 using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; namespace AJAXtest { public class BLL { public bool login(string username,string password) { try { string sql = "select password from Users where username='" + username + "'"; DAL sqlSelect = new DAL(); DataTable dt = sqlSelect.selectDB(sql); if (dt.Rows[0]["password"].ToString() != password) return false; } catch (Exception) { } return true; } } } 

 using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace AJAXtest { public partial class Server : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string username = Request["username"].ToString(); string password = Request["password"].ToString(); BLL b = new BLL(); if (b.login(username, password)) { Response.Write("登录成功"); Response.End(); } else { Response.Write("登录失败"); Response.End(); } } } } 

 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Server.aspx.cs" Inherits="AJAXtest.Server" %>