private void MetroButtonLogin_Click(object sender, EventArgs e) { DataSet1TableAdapters.UsersTableAdapter userAdapter = new DataSet1TableAdapters.UsersTableAdapter(); DataTable dt = userAdapter.GetDataByUserAndPassword(metroTextBoxUser.Text, metroTextBoxPassword.Text); if (dt.Rows.Count > 0) { //Valid Login MessageBox.Show("Login Successful"); UserID = int.Parse(dt.Rows[0]["UserID"].ToString()); loginFlag = true; } else { //Not Valid Login MessageBox.Show("Access Denied"); loginFlag = false; } Close(); }