private void btnAddVideo_Click(object sender, EventArgs e)
{
VideoForm dlg = new VideoForm();
if (dlg.ShowDialog() == DialogResult.OK)
{
string qry = string.Format("INSERT INTO tblVideo (Name, Num, Company, Director," +
"Major, Genre) VALUES ('{0}',{1},'{2}','{3}','{4}','{5}');",
dlg.Name1, dlg.Num, dlg.Company, dlg.Director, dlg.Major, dlg.Genre);
SqlCommand Com = new SqlCommand(qry, Con);
Com.ExecuteNonQuery();
RefreshVideo();
}
}
private void btnEditVideo_Click(object sender, EventArgs e)
{
int Pk;
if (lvVideo.SelectedItems.Count == 0)
{
MessageBox.Show("수정할 비디오를 먼저 선택하십시오.");
return;
}
Pk = Convert.ToInt32(lvVideo.SelectedItems[0].SubItems[0].Text);
VideoForm dlg = new VideoForm();
SqlCommand Com = new SqlCommand("SELECT Name, Num, Company, Director, Major, Genre FROM " +
"tblVideo WHERE Pk = " + Pk.ToString(), Con);
SqlDataReader R = Com.ExecuteReader();
R.Read();
dlg.Name1 = R["Name"].ToString();
dlg.Num = (int)R["Num"];
dlg.Company = R["Company"].ToString();
dlg.Director = R["Director"].ToString();
dlg.Major = R["Major"].ToString();
dlg.Genre = R["Genre"].ToString();
R.Close();
if (dlg.ShowDialog() == DialogResult.OK)
{
string qry = string.Format("UPDATE tblVideo Set Name = '{0}', Num = {1}, Company = '{2}', " +
"Director = '{3}', Major = '{4}', Genre = '{5}' WHERE Pk = {6}",
dlg.Name1, dlg.Num, dlg.Company, dlg.Director, dlg.Major, dlg.Genre, Pk);
Com = new SqlCommand(qry, Con);
Com.ExecuteNonQuery();
RefreshVideo();
}
}