public void videomp4()
{
string sql = "select * from Video,Casi,TheLoai where Casi.MaCaSi=Video.MaCaSi and Video.MaTheLoai=TheLoai.MaTheLoai ";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds);
Video__.DataSource = ds;
Video__.DataBind();
con.Close();
}
public void videolienquan(string macasi)
{
string sql = "select * from Video,Casi,TheLoai where Casi.MaCaSi=Video.MaCaSi and Video.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);
Video__.DataSource = ds;
Video__.DataBind();
con.Close();
}
public void videomp4()
{
string macasi = Request.QueryString["L"].ToString();
string sql = "select * from Video,Casi,TheLoai where Casi.MaCaSi=Video.MaCaSi and Video.MaTheLoai=TheLoai.MaTheLoai and Casi.MaCaSi='" + macasi + "'";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds);
Video__.DataSource = ds;
Video__.DataBind();
con.Close();
}
public void timvideo()
{
//Download source code tai Sharecode.vn
string sql = "select * from Video,Casi,TheLoai where Casi.MaCaSi=Video.MaCaSi and Video.MaTheLoai=TheLoai.MaTheLoai and TenKhongDau like '%" + Session["txtname"] + "%'";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds);
Video__.DataSource = ds;
Video__.DataBind();
con.Close();
}
