private void EnterUserBtn_Click(object sender, EventArgs e) { SqlCommand command; SqlDataReader dataReader; String query; query = "Select * From LoginTable Where Username = '******' and Password = '******' and Type = 'User'"; BookDBConn.Open(); command = new SqlCommand(query, BookDBConn); dataReader = command.ExecuteReader(); if (dataReader.Read()) { //Add welcome later BookStore UserAccess = new BookStore(UsernameText.Text); this.Hide(); UserAccess.ShowDialog(); this.Show(); } else { MessageBox.Show("Username or Password are not valid!", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Stop); } BookDBConn.Close(); }