login

using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        OleDbConnection oleConnection = getConn();
        try
        {
            string userID = this.TextBox1.Text;
            string userPwd = this.TextBox2.Text;
            string strCom = "Select * from login where userID='" + userID + "' and userPwd='" + userPwd + "'";

            OleDbCommand myCommand = new OleDbCommand(strCom, oleConnection);
            // 打开数据库连接
            oleConnection.Open();
            OleDbDataReader reader;
            reader = myCommand.ExecuteReader();

            if (reader.Read())
            {
                Response.Redirect("~/main.aspx");
            }
            else
            {
                Response.Write("用户或密码错误请重新输入！");
            }

            reader.Close();
            oleConnection.Close();
            // 显示连接成功信息
            //Label1.Text = "Access数据库连接状态：" + oleConnection.State;
        }
        catch
        {

            Response.Write("error");
            // 如果出现异常，显示异常信息

        }
        finally
        {
            // 关闭数据库连接
            oleConnection.Close();
        }

    }

    public OleDbConnection getConn()
    {
        string path = "d://db1.mdb";
        // 连接到 ACCESS 的连接字符串

        string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + path;

        // 使用OleDb .NET数据提供程序创建连接
        OleDbConnection oleConnection = new OleDbConnection(ConnStr);
        return (oleConnection);
    }
}