private void Delete1_Click(object sender, EventArgs e)//削除ボタンの処理 作品
{
string deletequery;
int counter = 0;
counter = SQLiteConnect.counterID("origin", beforeListView1ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
DialogResult res = MessageBox.Show(beforeListview1Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_origin where origin_id =" + beforeListView1ID;
SQLiteConnect.Excute(deletequery);
Listview1.Items.Clear();
SQLiteConnect.lording(ref Listview1, "select origin_ID,origin_title from t_origin", "origin_ID", "origin_title");
Textbox1.Clear();
}
}
private void Delete2_Click(object sender, EventArgs e)
{
int counter = 0;
counter = SQLiteConnect.counterID("genre", beforeListview2ID);
if (counter != 0)
{
MessageBox.Show("データが" + counter + "件存在するため、削除できません。", "警告", MessageBoxButtons.OK);
return;
}
string deletequery;
DialogResult res = MessageBox.Show(beforeListview2Title + "を削除しますか？", "削除確認", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
deletequery = "delete from t_genre where genre_id =" + beforeListview2ID;
SQLiteConnect.Excute(deletequery);
Listview2.Items.Clear();
SQLiteConnect.lording(ref Listview2, "select genre_ID,genre_title from t_genre", "genre_ID", "genre_title");
Textbox2.Clear(); //リフレッシュ処理
}
}
