//-------------------------------------------------------------
// 입력 버튼
//-------------------------------------------------------------
private void btnInput_Click(object sender, System.EventArgs e)
{
if (txtName.Text == "" || txtTel.Text == "")
{
MessageBox.Show("성명, 전화번호는 필수 입력사항 입니다.");
txtName.Focus();
return;
}
string gubun;
if (comSex.Text == "남자")
{
gubun = "M";
}
else
{
gubun = "F";
}
try
{
LocalConn.Open();
string sql = "Insert Into AddrBook (Name, Sex, Addr, Tel) values(";
sql += "'" + txtName.Text + "'" + ",";
sql += "'" + gubun + "'" + ",";
sql += "'" + txtAddr.Text + "'" + ",";
sql += "'" + txtTel.Text + "'" + ")";
if (Common_DB.DataManupulation(sql, LocalConn))
{
OleDbDataReader myReader = Common_DB.DataSelect("select * from AddrBook", LocalConn);
DataLoad(myReader);
Log.WriteLine("FrmListView", "데이터 한건 입력(" + txtName + "," + txtTel + ")");
MessageBox.Show("정상적으로 입력 되었습니다...");
}
}
catch (Exception e1)
{
MessageBox.Show(e1.ToString());
Log.WriteLine("FrmListView", e1.ToString());
}
finally
{
LocalConn.Close();
}
}
//-------------------------------------------------------------
// 수정 버튼 클릭시 DB에 Update 하는 부분
//-------------------------------------------------------------
private void btnUpdate_Click(object sender, System.EventArgs e)
{
if (txtName.Text == "" || txtTel.Text == "")
{
MessageBox.Show("성명, 전화번호는 필수 입력사항 입니다.");
txtName.Focus();
return;
}
string gubun;
if (comSex.Text == "남자")
{
gubun = "M";
}
else
{
gubun = "F";
}
try
{
LocalConn.Open();
string myExecuteQuery = "Update AddrBook set Name='" + txtName.Text + "'" + ",";
myExecuteQuery += " Addr = '" + txtAddr.Text + "'" + ",";
myExecuteQuery += " Sex = '" + gubun + "'" + ",";
myExecuteQuery += " Tel = '" + txtTel.Text + "'";
myExecuteQuery += " where Name = " + "'" + txtName.Text + "'";
if (Common_DB.DataManupulation(myExecuteQuery, LocalConn))
{
OleDbDataReader myReader = Common_DB.DataSelect("select * from AddrBook", LocalConn);
DataLoad(myReader);
MessageBox.Show(" 정상적으로 수정 되었습니다...");
}
}
catch (Exception e1)
{
MessageBox.Show(e1.ToString());
Log.WriteLine("FrmListView", e1.ToString());
}
finally
{
LocalConn.Close();
}
}
//-------------------------------------------------------------
// 삭제 버튼 클릭시 DB에 Update 하는 부분
//-------------------------------------------------------------
private void btnDelete_Click(object sender, System.EventArgs e)
{
OleDbDataReader myReader = null;
if (txtName.Text == "" || txtTel.Text == "")
{
MessageBox.Show("성명, 전화번호는 필수 입력사항 입니다.");
txtName.Focus();
return;
}
//-------------------------------- 삭제 확인
if (MessageBox.Show("정말 삭제 하시겠습니까?", "삭제확인",
MessageBoxButtons.YesNo, MessageBoxIcon.Question)
!= DialogResult.Yes)
{
return;
}
try
{
LocalConn.Open();
string myExecuteQuery = "Delete AddrBook ";
myExecuteQuery += " where Name = " + "'" + txtName.Text + "'";
if (Common_DB.DataManupulation(myExecuteQuery, LocalConn))
{
myReader = Common_DB.DataSelect("select * from AddrBook", LocalConn);
DataLoad(myReader);
MessageBox.Show(" 정상적으로 삭제 되었습니다...");
}
}
catch (Exception e1)
{
MessageBox.Show(e1.ToString());
Log.WriteLine("FrmListView", e1.ToString());
}
finally
{
LocalConn.Close();
}
}