public void musicmp3() { string sql = "select top 10* from Music,Casi,TheLoai where Casi.MaCaSi=Music.MaCaSi and Music.MaTheLoai=TheLoai.MaTheLoai ORDER BY NgayDang Desc"; con.Open(); SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds); Music__.DataSource = ds; Music__.DataBind(); con.Close(); }
public void timnhac() { string sql = "select * from Music,Casi,TheLoai where Casi.MaCaSi=Music.MaCaSi and Music.MaTheLoai=TheLoai.MaTheLoai and TenKhongDau like '%" + Session["txtname"] + "%'"; con.Open(); SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds); Music__.DataSource = ds; Music__.DataBind(); con.Close(); }
public void baihatlienquan(string macasi) { //Download source code tai Sharecode.vn string sql = "select * from Music,Casi,TheLoai where Casi.MaCaSi=Music.MaCaSi and Music.MaTheLoai=TheLoai.MaTheLoai and Casi.MaCaSi ='" + macasi + "' order by LuotXem desc"; con.Open(); SqlDataAdapter da = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); da.Fill(ds); Music__.DataSource = ds; Music__.DataBind(); con.Close(); }