private void B_Add_DB_Click(object sender, EventArgs e) { int error = 0; try { if (B_Add_Name.Text.Equals("")) { MessageBox.Show("책이름을 확인하여 주십시오", "Information"); error++; } else if (B_Add_Writer.Text.Equals("")) { MessageBox.Show("작가명을 확인하여 주십시오", "Information"); error++; } else if (!(B_Add_Realse1.Text.Length == 4) || !(B_Add_Realse2.Text.Length == 2) || !(B_Add_Realse3.Text.Length == 2)) { MessageBox.Show("출판년도를 확인하여 주십시오", "Information"); B_Add_Realse1.Text = ""; B_Add_Realse2.Text = ""; B_Add_Realse3.Text = ""; error++; } else if (!(Convert.ToInt32(B_Add_Realse1.Text) > 1000) || !(Convert.ToInt32(B_Add_Realse2.Text) > 0) || !(Convert.ToInt32(B_Add_Realse2.Text) < 13) || !(Convert.ToInt32(B_Add_Realse3.Text) > 0) || !(Convert.ToInt32(B_Add_Realse3.Text) < 32)) { MessageBox.Show("출판년도를 확인하여 주십시오", "Information"); B_Add_Realse1.Text = ""; B_Add_Realse2.Text = ""; B_Add_Realse3.Text = ""; error++; } if (error == 0) { string Realse = B_Add_Realse1.Text + "-" + B_Add_Realse2.Text + "-" + B_Add_Realse3.Text; string str = "INSERT INTO book (name,writer,realse) VALUES('" + B_Add_Name.Text + "','" + B_Add_Writer.Text + "','" + Realse + "');"; MySqlCommand cmd = new MySqlCommand(str, conn); cmd.ExecuteNonQuery(); MessageBox.Show("추가 완료", "Information"); Form1 fa = (Form1)this.Owner; fa.Book_DB_List(); B_Add_Name.Text = ""; B_Add_Writer.Text = ""; B_Add_Realse1.Text = ""; B_Add_Realse2.Text = ""; B_Add_Realse3.Text = ""; } } catch (Exception ex) { MessageBox.Show("출판년도를 확인하여 주십시오", "Information"); B_Add_Realse1.Text = ""; B_Add_Realse2.Text = ""; B_Add_Realse3.Text = ""; error++; } }