类型点歌
- public FrmMain frmMain; string connectionStr = "server=.;database=MyKTV;uid=sa";
- DBHelp db = new DBHelp(); private SqlConnection con;
- private void FrmSongType_Load(object sender, EventArgs e) {
- con = new SqlConnection(connectionStr); con.Open();
- string sql = "select resource_path from resource_path where resource_id= "; string sqlsongpath = "select resource_path from resource_path where resource_id= ";
- SqlCommand cmd = new SqlCommand(sqlsongpath,con); KtvUnit.SongPath = cmd .ExecuteScalar().ToString();
- SqlCommand cmd = new SqlCommand(sql, con); KtvUnit.ImagePath = cmd.ExecuteScalar().ToString();
- con.Close(); con = new SqlConnection(connectionStr);
- string sql = string.Format("select songtype_id,songtype_name,songtype_URL from song_type"); SqlCommand cmd = new SqlCommand(sql , con);
- SqlDataReader dr; try
- { con.Open();
- int index = ; lvSongType.Items.Clear();
