private void ResetControls()
        {
            SqlCommand findNumMembers;
            SqlCommand findID;
            string strCommand;
            int num_members = 0;

            //gets the next empty ID number from members table
            strCommand = "select ident_current('member')";
            findID = new SqlCommand(strCommand, sql_connection);
            findNumMembers = new SqlCommand("select count(*) from member", sql_connection);

            myReader = findNumMembers.ExecuteReader();

            if (myReader.HasRows && myReader.Read())
                num_members = Convert.ToInt32(myReader[0].ToString());

            MessageBox.Show(num_members.ToString());

            myReader.Close();

            myReader = findID.ExecuteReader();


            if (myReader.HasRows && myReader.Read() && myReader[0] != DBNull.Value)
            {
                    int ID = Convert.ToInt32(myReader[0]);
                    if (num_members == 0)
                        lblMemIDNum.Text = Convert.ToString(ID);
                    else
                        lblMemIDNum.Text = Convert.ToString(ID+1);
            }
            
            txtMemFName.Text = "";
            txtMemLName.Text = "";
            txtMemAddress.Text = "";
            txtMemEmail.Text = "";
            txtMemPhone.Text = "";
            txtMemMobile.Text = "";
            dateMemBDae.Value = DateTime.Now;
            dateMemJoin.Value = DateTime.Now;
            myReader.Close();
        }