private void okayButton_Click(object sender, EventArgs e) { int tag; bool num; int proj = -2; if (tagBox.Text.Trim().Length > 0 && nameBox.Text.Trim().Length > 0) { num = Int32.TryParse(tagBox.Text.Trim(), out tag); if (num) { if (main.openDB()) { newMemComm.CommandText = "select project_id from projects where project_name=\'" + projCombo.SelectedItem.ToString().Trim() + "\';"; newMemReader = newMemComm.ExecuteReader(); //going to have to close the connection here so it can be reopened in main if (newMemReader.Read()) { proj = (int)newMemReader.GetValue(0); } newMemReader.Close(); } main.closeDB(); main.AddMember(RFIDBox.Text, Convert.ToInt32(tagBox.Text.Trim()), nameBox.Text.Trim(), proj); this.Close(); } else { MessageBox.Show("Please be sure the Tag# is an actual integer.", "Tag# not a number"); } } else { MessageBox.Show("Please be sure all fields have data in them.", "Empty fields"); } }