using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;

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

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string db = "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source=C:\\database\\next21.mdb";

            OleDbConnection con = new OleDbConnection(db);
            OleDbCommand cmd;
            OleDbDataReader dr;


            String sql;
            con.Open();

            sql = "SELECT * FROM gwapko WHERE uname =  '"+ tbusernamehome.Text +"' AND password='"+ tbpasshome.Text +"'";

            cmd = new OleDbCommand(sql,con);

            dr=cmd.ExecuteReader();

            if(dr.Read()){

                Session["uname"] = dr.GetValue(1).ToString();
                Response.Redirect("useracnt.aspx");


            }else{

                Response.Write("<script language='Javascript'>alert('Failed!');</script>");
            }

            con.Close();

        }

        protected void Button2_Click(object sender, EventArgs e)
        {

        }
    }
}