コード例 #1
0
        private void searchBtn_Click(object sender, EventArgs e)
        {
            MySqlConnection connection = DBConnection.getDbConnection().getConnection();

            MySqlCommand    mcd;
            MySqlDataReader mdr;


            try
            {
                connection.Open();
                string s = "select * from MEMBER where athleticId='" + searchText.Text + "'";
                mcd = new MySqlCommand(s, connection);
                mdr = mcd.ExecuteReader();
                if (mdr.Read())
                {
                    Member member = new Member(mdr.GetString("athleticId"),
                                               mdr.GetString("fullName"),
                                               mdr.GetString("nameWithInitials"),
                                               mdr.GetString("dob"),
                                               mdr.GetString("NICNo"),
                                               mdr.GetString("address"),
                                               mdr.GetInt32("telNo"),
                                               mdr.GetInt32("mobileNo"),
                                               mdr.GetString("occupation"),
                                               mdr.GetString("email"),
                                               mdr.GetString("DANorGUP"),
                                               mdr.GetString("kukkiwonNo"),
                                               mdr.GetString("belt"), mdr.GetString("club"),
                                               mdr.GetString("coacher"));
                    //MessageBox.Show(mdr.GetString("nameWithInitials"));

                    MemberViewAndUpdate memberViweAndUpdateForm = new MemberViewAndUpdate(member);
                    memberViweAndUpdateForm.Show();
                }
                else
                {
                    MessageBox.Show("NO DATA");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                // mdr.Close();
                connection.Close();
            }
        }
コード例 #2
0
        private void memberSearchBtn_Click(object sender, EventArgs e)
        {
            Member member = MemberController.SearchMemberByAthleticId(searchMemberText.Text);

            if (searchMemberText.Text != "")
            {
                if (member != null)
                {
                    MemberViewAndUpdate addAdminForm = new MemberViewAndUpdate(member, true);
                    addAdminForm.Show();
                    return;
                }
                MessageBox.Show(searchMemberText.Text + " is not a member of Nationl Taekwondo Federation!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            else
            {
                MessageBox.Show("Enter ahtletic id to search.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
        }
コード例 #3
0
        private void memberSearchBtn_Click(object sender, EventArgs e)
        {
            Member member = MemberController.SearchMemberByAthleticId(searchMemberText.Text);

            try
            {
                if (member != null)
                {
                    MemberViewAndUpdate memberViewAndUpdate = new MemberViewAndUpdate(member);
                    memberViewAndUpdate.Show();
                }
                else
                {
                    MessageBox.Show("Member not found!", "Message", MessageBoxButtons.OK);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }