private void button3_Click(object sender, EventArgs e)
{
string sql;
modaname2 = comboBox4.Text.Replace("'", "''");
modtime2 = comboBox5.Text;
/* if (modaname2 != modaname)
{
connectSQL();
sql = "update [album] set aname='" + modaname2 + "' where acode='" + modacode + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteScalar();
closeSQL();
MessageBox.Show("修改专辑名成功！", "消息");
}
if (modtime2 != modtime)
{
connectSQL();
sql = "update [album] set time='" + modtime2 + "' where acode='" + modacode + "'";
cmd = new SqlCommand(sql, conn);
cmd.ExecuteScalar();
closeSQL();
MessageBox.Show("修改首发展会成功！", "消息");
}
connectSQL();
sql = "update [album] set cover='@cover' where acode='" + modacode + "'";
cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("cover", SqlDbType.Image);
cmd.Parameters["cover"].Value = imagebytes;
cmd.ExecuteScalar();
closeSQL();
MessageBox.Show("修改专辑图片成功！", "消息");
*/
using (sqlAdapter sqladp = new sqlAdapter())
{
sql = "delete from [album] where acode='" + modacode + "'";
sqladp.ExecuteNonQuery(sql);
sql = "insert into [album] values ('" + modacode + "','" + modaname2 + "','" + modtime2 + "',@cover)";
sqladp.setCommand(sql);
sqladp.Command.Parameters.Add("cover", SqlDbType.Image);
sqladp.Command.Parameters["cover"].Value = imagebytes;
sqladp.Command.ExecuteNonQuery();
}
MessageBox.Show("修改成功！", "消息");
}
private void button2_Click(object sender, EventArgs e)
{
// modacode2 = comboBox2.Text;
// modtrack2 = comboBox6.Text;
// modscode2 = modacode2 + modtrack2;
// modgcode2 = comboBox1.Text;
modgname2 = comboBox3.Text.Replace("'", "''");
if (modgname2 != modgname)
{
using (sqlAdapter sqladp = new sqlAdapter())
{
sqladp.ExecuteNonQuery("update [group] set gname='" + modgname2 + "' where gcode='" + modgcode + "'");
}
MessageBox.Show("修改社团名成功！", "消息");
}
}
