public NewMember(string rfid, RFIDLoggerMain main, MySqlConnection mySQLcon)
        {
            this.main = main;
            newMemCon = mySQLcon;
            InitializeComponent();
            RFIDBox.Text = rfid;

            if (main.openDB())
            {
                projCombo.Items.Clear();
                newMemComm             = newMemCon.CreateCommand();
                newMemComm.CommandText = "select project_name from projects where active_project=1 order by project_id;";
                newMemReader           = newMemComm.ExecuteReader();
                while (newMemReader.Read())
                {
                    projCombo.Items.Add(newMemReader.GetValue(0));
                }
                newMemReader.Close();
                main.closeDB();
            }
            projCombo.SelectedIndex = 0;
        }
        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");
            }
        }