private void btnGuardar_Click(object sender, EventArgs e) { MySqlConnection conectar = new MySqlConnection("server = localhost; port = 3306; username = root; password=; database = reservas"); try { conectar.Open(); } catch (MySqlException ex) { MessageBox.Show(ex.Message.ToString()); } String sql = "insert into login(correo, usuario, contrasena) values ('" + txtEmail.Text + "' , '" + txtUser.Text + "' , '" + txtPass.Text + "' )"; MySqlCommand cmd = new MySqlCommand(sql, conectar); try { cmd.ExecuteNonQuery(); MessageBox.Show("Usuario Registrado con exito"); this.Hide(); principal.Show(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void btnCambiar_Click(object sender, EventArgs e) { MySqlConnection conectar = new MySqlConnection("server = localhost; port = 3306; username = root; password=; database = reservas"); try { conectar.Open(); } catch (MySqlException ex) { MessageBox.Show(ex.Message.ToString()); } String sql = "UPDATE login SET contrasena = '" + txtContrasena.Text + "' WHERE correo = '" + txtCorreoElectronico.Text + "'"; MySqlCommand cmd = new MySqlCommand(sql, conectar); try { cmd.ExecuteNonQuery(); MessageBox.Show("Contrasena cambiada correctamente"); this.Hide(); formularioPrincipal.Show(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void btnEntrar_Click_1(object sender, EventArgs e) { MySqlConnection conectar = new MySqlConnection("server = localhost; port = 3306; username = root; password=; database = reservas"); conectar.Open(); MySqlCommand codigo = new MySqlCommand(); codigo.Connection = conectar; codigo.CommandText = ("select * from login where correo = '" + txtUser.Text + "'and contrasena = '" + txtContrasena.Text + "'"); MySqlDataReader leer = codigo.ExecuteReader(); if (leer.Read()) { MessageBox.Show("Bienvenido" + " " + txtUser.Text); this.Hide(); principal.Show(); } else { MessageBox.Show("usuario y/o contraseña incorrectos"); } conectar.Close(); }