private void BtnLogin_Click(object sender, EventArgs e)
{
SC = new SqlConnection("Data Source=LATITUDE\\SQLEXPRESS; initial Catalog=Registro;integrated security = true");
SC.Open();
string query = "SELECT * FROM Registrar1 WHERE NombreUsuario = '" + txtUsername.Text.Trim() + "'and Contraseña = '" + txtPassword.Text.Trim() + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, SC);
DataTable dtbl = new DataTable();
sda.Fill(dtbl);
if (dtbl.Rows.Count == 1)
{
Encuesta newform = new Encuesta();
newform.Show();
this.Hide();
}
else
{
MessageBox.Show("Check your user or password");
}
}
public Nueva_Encuesta()
{
encuesta = new Encuesta();
InitializeComponent();
}
