private void btnhome_Click(object sender, EventArgs e)
{
FrmHome frmHome = new FrmHome();
this.Hide();
frmHome.Show();
}
private void btnEntrar_Click(object sender, EventArgs e)
{
SqlConnection banco = new SqlConnection("Data Source=DESKTOP-7VCU04E;Initial Catalog=Projeto;Integrated Security=True");
SqlCommand comando = new SqlCommand("SELECT * FROM CADASTRO where LOGIN=@LOGIN AND SENHA=@SENHA", banco);
comando.Parameters.Add("@LOGIN", SqlDbType.VarChar).Value = txtLogin.Text;
comando.Parameters.Add("@SENHA", SqlDbType.VarChar).Value = txtSenha.Text;
if (txtLogin.Text == "" && txtSenha.Text == "")
{
MessageBox.Show("Preencha todos os campos!");
txtLogin.Focus();
}
try
{
banco.Open();
SqlDataReader leia = comando.ExecuteReader();
if (leia.HasRows == false)
{
throw new Exception("Usuário ou senha Incorreta!");
}
else
{
leia.Read();
FrmHome frmHome = new FrmHome();
this.Hide();
frmHome.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
banco.Close();
}
}
