【文件属性】:
文件名称:ktv后台代码
文件大小:962B
文件格式:SLN
更新时间:2018-10-11 18:46:35
C#
rivate void btnBaocun_Click(object sender, EventArgs e)
{
int gesxb = Convert.ToInt32(this.comboBox1.SelectedValue);//singer_info 歌手
string mingcheng=this.txtGequmingcheng.Text;
string wenjianming=this.txtGequwenjianming.Text;
string shuoxie=this.txtpinyinsuoxie.Text;
int leixin = Convert.ToInt32( this.cmbleixing.SelectedValue);//shong_type 类型下标
//保存song_info表
string sql = "update song_info set song_name='" + mingcheng + "',song_ab='" + shuoxie + "',songtype_id=" + leixin + ",singer_id=" + gesxb + ",song_url='" + wenjianming + "' where song_id="+id+"";
SqlConnection aon = new SqlConnection(str);
try
{
con.Open();
SqlCommand com = new SqlCommand(sql, con);
int shu = com.ExecuteNonQuery();
if (shu == 1)
{
MessageBox.Show("更新成功!");