private void btn_Update_Click(object sender, EventArgs e)
{
bool state = false;
updateID = tb_userID.Text;
conn = new MySqlConnection(strConn);
conn.Open();
cmd = new MySqlCommand("", conn);
string sql = "SELECT uid FROM user_info";
cmd.CommandText = sql;
reader = cmd.ExecuteReader();
while (reader.Read())
{
string uid = reader["uid"].ToString();
if (uid == tb_userID.Text)
{
state = true;
}
}
if (state == true)
{
SelectUpdateForm dlgUpdate = new SelectUpdateForm(this);
dlgUpdate.ShowDialog();
if (dlgUpdate.DialogResult == DialogResult.OK)
{
conn = new MySqlConnection(strConn);
conn.Open();
cmd = new MySqlCommand("", conn);
sql = "UPDATE user_info SET uid='" + dlgUpdate.tb_userID.Text;
sql += "', upw='" + dlgUpdate.tb_PwChange.Text + "', uname='" + dlgUpdate.tb_Uname.Text;
sql += "', ubirth='" + dlgUpdate.combo_birth1.Text + "." + dlgUpdate.combo_birth2.Text + "." + dlgUpdate.combo_birth3.Text;
sql += "', ugender='" + dlgUpdate.combo_Gender.Text + "', uadress='" + dlgUpdate.tb_Adress.Text;
sql += "', uphone1='" + dlgUpdate.tb_Phone1.Text + "', uphone2='" + dlgUpdate.tb_Phone2.Text + "', uphone3='" + dlgUpdate.tb_Phone3.Text;
sql += "' WHERE uid='" + tb_userID.Text + "'";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
tb_userID.Text = "";
MessageBox.Show("회원정보수정이 완료되었습니다.");
conn.Close();
}
else
{
tb_userID.Text = "";
}
}
else
{
MessageBox.Show("아이디를 확인해주세요.");
}
}
public ImageProcessing(SelectUpdateForm form)
{
InitializeComponent();
this.selectUpdateForm = form;
}