コード例 #1
0
 private void btnNext_Click(object sender, EventArgs e)
 {
     try
     {
         conn.Open();
         MySqlCommand comm = new MySqlCommand("INSERT INTO member_tbl(firstName, middleName, lastName, "
                                              + "nickName, birthdate, gender, civilStatus, citizenship, homeAddress, homePhoneNumber, contactNum, emailAd, "
                                              + "occupation, companyName, companyContactNum, companyAddress, schoolName, schoolContactNum, "
                                              + "schoolAddress, spouseName, spouseContactNum, spouseBirthdate, memberType) VALUES('" + txtFirstName.Text + "', '" + txtMiddleName.Text + "', "
                                              + "'" + txtLastName.Text + "', '" + txtNickName.Text + "', '" + convertBirthDate()[0] + "', "
                                              + "'" + convertGender() + "','" + convertCivilStatus() + "', '" + convertCitizenship() + "', "
                                              + "'" + txtHomeAddress.Text + "', '" + txtHomeNumber.Text + "', '" + txtMobileNumber.Text + "', "
                                              + "'" + txtEmailAddress.Text + "', '" + txtProfession.Text + "', '" + txtCompanySchoolName.Text + "', "
                                              + "'" + txtCompanyPhoneNumber.Text + "', '" + txtCompanySchoolAddress.Text + "', "
                                              + "'" + txtCompanySchoolName.Text + "', '" + txtCompanyPhoneNumber.Text + "', "
                                              + "'" + txtCompanySchoolAddress.Text + "', '" + txtSpouse.Text + "', '" + txtMobileNumberSpouse.Text + "', "
                                              + "'" + convertBirthDate()[1] + "', 0);", conn);
         comm.ExecuteNonQuery();
         conn.Close();
         FormRegisterUsePass frmregisterusepass = new FormRegisterUsePass();
         frmregisterusepass.reference_to_frmregisternewcomer = this;
         frmregisterusepass.reference_to_frmlogin            = reference_to_frmlogin;
         this.Hide();
         frmregisterusepass.Show();
     }
     catch (Exception ex)
     {
     }
 }
コード例 #2
0
 private void btnNext_Click(object sender, EventArgs e)
 {
     try
     {
         memberID = reference_to_frmregisterdgroup.getMemberID();
         conn.Open();
         MySqlCommand comm1 = new MySqlCommand("UPDATE discipleshipgroupmembers_tbl SET dgroupID = " + dgroupID + ", "
                                               + "memberID = " + memberID + " WHERE dgroupmemberID = " + getDgroupMemberID() + ";", conn);
         comm1.ExecuteNonQuery();
         conn.Close();
         FormRegisterUsePass frmregisterusepass = new FormRegisterUsePass();
         frmregisterusepass.reference_to_frmchooseleader = this;
         frmregisterusepass.reference_to_frmlogin        = reference_to_frmlogin;
         this.Hide();
         frmregisterusepass.Show();
     }
     catch (Exception ex)
     {
     }
 }