using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.OleDb;

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

    }
    protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
    {
        try
        {
            string conString = @"provider=Microsoft.Jet.OLEDB.4.0;user id=;password=; data source=" + Server.MapPath("./db/DataBank.mdb");

            OleDbDataReader dr;
            OleDbCommand cmd;
            OleDbConnection conn = new OleDbConnection(conString);
            string query = "Select UserName, [PassWord] From Admin Where UserName='" + Login1.UserName + "' AND [PassWord] ='" + Login1.Password + "'";

            conn.Open();
            cmd = new OleDbCommand(query, conn);
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                //Response.Redirect("Default.aspx");
                FormsAuthentication.RedirectFromLoginPage(Login1.UserName, false);
            }
            dr.Close();
            conn.Close();
        }
        catch (Exception ex)
        {
            ex.ToString();
        }
    }
}