/*
* private void DeleteData()
* {
* try
* {
* using (MySqlConnection conn = new MySqlConnection(Commons.CONNSTR))
* {
* conn.Open();
* MySqlCommand cmd = new MySqlCommand();
* cmd.Connection = conn;
* cmd.CommandText = "DELETE FROM divtbl" +
* " WHERE Division = @Division ";
* MySqlParameter paramDivision = new MySqlParameter("@Division", MySqlDbType.VarChar);
* paramDivision.Value = TxtDivision.Text;
* cmd.Parameters.Add(paramDivision);
*
* cmd.ExecuteNonQuery();
*
* if (myMode == BtnMode.INSERT)
* {
* MetroMessageBox.Show(this, $"구분코드 {paramDivision.Value}가 삭제되었습니다.", "삭제");
* myMode = BtnMode.NONE;
* }
* }
* }
* catch (Exception ex)
* {
* MetroMessageBox.Show(this, $"에러발생 {ex.Message}", "에러", MessageBoxButtons.OK, MessageBoxIcon.Error);
* }
* finally
* {
* UpdateData();
* }
* }
*/
#endregion
private void BtnCancel_Click(object sender, EventArgs e)
{
TxtDivision.Text = string.Empty;
TxtNames.Text = string.Empty;
TxtDivision.ReadOnly = false;
myMode = BtnMode.NONE; // 모드 초기화
GrdDivTbl.Focus();
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (myMode != BtnMode.UPDATE)
{
MetroMessageBox.Show(this, $"삭제할 데이터를 선택하세요.", "알림");
return;
}
myMode = BtnMode.DELETE;
//DeleteData();
SaveData();
InitControls();
GrdDivTbl.Focus();
}
