ASP.NET 3.5 ACCESS 登录代码，非login控件
login.aspx页面文件：（母版页为MasterPage.master）
<%@ Page Title="" Language="C#" MasterPageFile="MasterPage.master" AutoEventWireup="true" CodeFile="AdminLogin.aspx.cs" Inherits="manager_AdminLogin" %>
<asp:Content ContentPlaceHolder Runat="Server">
</asp:Content>
<asp:Content ContentPlaceHolder Runat="Server">
<div >
<div >
<div >
<asp:Label runat="server" Text="姓名"></asp:Label>
<asp:TextBox runat="server"></asp:TextBox>
<br />
<br />
<asp:Label runat="server" Text="密码"></asp:Label>
<asp:TextBox runat="server" TextMode="Password"></asp:TextBox>
<br />
<br />
<asp:Button runat="server" onclick="ButtonLogin_Click"
Text="登录" />
<asp:Label runat="server"></asp:Label>
</div>
</div>
</div>
</asp:Content>
login.aspx.cs代码文件：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class manager_AdminLogin : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void ButtonLogin_Click(object sender, EventArgs e)
{
try
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("App_Data/sitedb.mdb"));//建立access数据库文件sitedb.mdb（相对路径）的数据库连接
con.Open(); //打开数据库
string sql; //定义字符串sql
sql = "select count(*) from usertab where username='" + this.TextBoxName.Text + "' and userpwd='" + this.TextBoxPwd.Text + "'";//建立sql查询语句
OleDbCommand cmd = new OleDbCommand(sql, con);//建立数据集
int state =Convert.ToInt32( cmd.ExecuteScalar());//执行sql语句，并返回获得值
if (state == 0 || state > 1)//如果数据中没有记录或有多条记录则抱错
{
message.Text = "用户不存在，请检测用户名和密码是否正确！";
}
else//正确数据指向登陆后页面
{
Session["admin"] = TextBoxName.Text;
Response.Redirect("manager/AdminPage.aspx");//指向登陆后页面
}
}
catch
{
message.Text = "无法进行数据连接";
}
}
}