}
private void dgvSongList_Click(object sender, EventArgs e)
{
DBHelp db = new DBHelp();
if (dgvSongList.SelectedRows[ ]!=null)
{
string songname = this.dgvSongList.SelectedRows[ ].Cells["SongName"].Value.ToString();
db.connection();
string sql = string.Format("SELECT song_name,singer_name,song_url,song_photo_url FROM dbo.song_info,dbo.singer_info where dbo.singer_info.singer_id=dbo.song_info.singer_id and song_name='{ }'", songname);
SqlDataReader reader = db.ExecuteReaders(sql.ToString());
Song song;
if (reader.Read())
{
song = new Song();
song.SongName = reader["song_name"].ToString();
song.SongURL = KtvUnit.SongPath + reader["song_url"].ToString();
PlayList.AddSong(song);
}
reader.Close();
}
else
{
MessageBox.Show("空");
}
}
数字点歌
-
public FrmMain frmMain;
string connectionStr = "server=.;database=MyKTV;uid=sa";
-
DBHelp db = new DBHelp();
private SqlConnection con;
-
private void FrmNumber_Load(object sender, EventArgs e)
{
-
con = new SqlConnection(connectionStr);
con.Open();
-
string sqlsongpath = "select resource_path from resource_path where resource_id= ";
SqlCommand cmd = new SqlCommand(sqlsongpath, con);
