public DataTable Executar(string sql, DataTable tabla)
{
MySqlCommand Cm = new MySqlCommand(sql, Cn);
if (Conectar() == true)
{
MySqlDataReader Datos;
Datos = Cm.ExecuteReader();
if (Datos.HasRows == true)
{
while (Datos.Read())
{
DataRow r = tabla.NewRow();
int x = 0;
foreach (System.Data.DataColumn c in tabla.Columns)
{
r[c] = Datos.GetValue(x);
x++;
}
tabla.Rows.Add(r);
}
Cn.Close();
return tabla;
}
else
{
Cn.Close();
return tabla;
}
}
else
{
return tabla;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text.Length > 0)
{
Tabla = Executar("select * from login where usuario='" + this.textBox1.Text + "'", Tabla);
if (Tabla.Rows.Count > 0)
{
DataRow r = Tabla.Rows[0];
if (r[1].ToString() == this.textBox2.Text)
{
Status = Estado.Autentificado;
textBox2.ResetText();
Form login = new Form1();
login.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Password Incorrecto", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox2.Focus();
}
}
else
{
MessageBox.Show("Usuario Incorrecto", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox1.Focus();
}
}
}
private void button2_Click(object sender, EventArgs e)
{
Status = Estado.Cancelar;
this.Close();
}
private void login_Load(object sender, EventArgs e)
{
Tabla.Columns.Add("usuario", typeof(string));
Tabla.Columns.Add("contraseña", typeof(string));
Form m = new Form1();
m.SendToBack();
if (m.IsDisposed == true)
m.Show();
else
m.BringToFront();
Form1 f = new Form1();
f.BringToFront();
}
enum Estado
{
Ninguno, Autentificado, Cancelar
}
}