private void lblLogin_Click(object sender, EventArgs e) { if (txtUsername.ForeColor == Color.Black && txtUsername.Text != "" && txtPassword.ForeColor == Color.Black && txtPassword.Text != "") { cn = new OleDbConnection(); cn.ConnectionString = "Provider='Microsoft.ACE.OLEDB.12.0';Data Source='Usuarios.accdb'"; cn.Open(); string sql = "Select * from Usuario where Username = '******' and Clave = '{1}'"; sql = String.Format(sql, txtUsername.Text.ToLower(), txtPassword.Text.ToLower()); cmd = new OleDbCommand(sql, cn); da = new OleDbDataAdapter(cmd); ds = new DataSet(); da.Fill(ds, "DatosLog"); if (ds.Tables["DatosLog"].Rows.Count != 0) { Var.user = txtUsername.Text.ToLower(); Var.UserRoom = Convert.ToInt32(ds.Tables["DatosLog"].Rows[0].ItemArray[2]); home = true; this.Close(); MyHouse house = new MyHouse(); house.Show(); } else MessageBox.Show("That's not a valid Username/Password"); cn.Close(); } else MessageBox.Show("Fill in every field", "Error"); }
private void lblHouse_Click(object sender, EventArgs e) { this.Visible = false; if (Var.user != null) { MyHouse mi_casa = new MyHouse(); mi_casa.Show(); } else { LoginHouse login = new LoginHouse(); login.Show(); } }