文件名称: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("更新成功!");