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();
}
