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("修改社团名成功!", "消息"); } }