private void button_insert_Click(object sender, EventArgs e)
{
TB_CUST temp = new TB_CUST();
temp.cust_id = textBox1.Text;
temp.birth_dt = textBox2.Text;
DataManager_MySql.tb_custs.Add(temp);
DataManager_MySql.Save();
DataLoad();
}
private void button_update_Click(object sender, EventArgs e)
{
try
{
TB_CUST temp = DataManager_MySql.tb_custs.Single
((x) => x.cust_id.Trim().ToString() == textBox1.Text);
//DataManager.tb_custs.Remove(temp);
temp.birth_dt = textBox2.Text;
DataManager_MySql.Save();
DataLoad();
}
catch (Exception ex)
{
}
}
private void button_delete_Click(object sender, EventArgs e)
{
try
{
//싱글은 pk 대상으로 해야 함
//값이 두 개 들어 있으면 catch에서 걸림
TB_CUST temp = DataManager_MySql.tb_custs.Single
((x) => x.cust_id.Trim().ToString() == textBox1.Text);
DataManager_MySql.tb_custs.Remove(temp);
DataManager_MySql.Save();
DataLoad();
}
catch (Exception ex)
{
}
}
private void DataLoad()
{
DataManager_MySql.Load();
dataGridView1.DataSource = null;
dataGridView1.DataSource = DataManager_MySql.tb_custs;
}