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;
using System.Web.SessionState;
using System.Data;


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

        }

        protected void btna_Click(object sender, EventArgs e)
        {
           OleDbConnection conne = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|baconwp.accdb");
            conne.Open();
            OleDbCommand cmd = new OleDbCommand("select * from tlausers where usuario=@username and password=@password", conne);            
            cmd.Parameters.AddWithValue("@usuario", txtu.Text);
            cmd.Parameters.AddWithValue("@password", txtp.Text);
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            DataTable tb = new DataTable();
            da.Fill(tb);
            
            if (tb.Rows.Count > 0)
            {
                
                //Session.Add("usuario",txtu.Text);
                Session["apellido"] = tb.Rows[0]["apellido"];
                Response.Redirect("Default.aspx");
                
            }
            else
            {
                ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('usuario y contraseña incorrectos')</script>");
            }
            
        }
        }
    }