using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;

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

    }
    protected void btlogon_Click(object sender, EventArgs e)
    {
        string conexao = "Server=LocalHost;Database=StoneHenge;Uid=root;Pwd='';Connect Timeout=30";
        MySqlConnection conn = new MySqlConnection(conexao);
        string comando = "select * from usuario where nome='" + nome.Text + "' and senha='" + senha.Text + "'";
        MySqlCommand cmd = new MySqlCommand(comando,conn);
        conn.Open();
        MySqlDataReader dr = cmd.ExecuteReader();
        if (dr.HasRows)
        {
            Response.Redirect("Default.aspx");
        }
        else {
            mensagem.Text = "Senha ou usuario errado!";
            //mensagem.Text = "rows "+dr.RecordsAffected.ToString();
        }


    }
}