前台代碼
<embed src="<%=VUrl%>" noerror="true" style="width: 579px; height: 321px"></embed>
後台代碼
//觀看視頻
protected void seeVi()
{
try
{
string sql = "select * from tb_Video where VideoID=" + Convert.ToInt32(Request.QueryString["VideoID"]);
OleDbDataReader odr = mydo.row(sql);//調用資料庫操作類中的row方法
odr.Read(); //前進一條記錄
VUrl = "Video" + "\\" + odr["VideoUrl"].ToString(); //儲存視頻教程的路徑
if (!File.Exists(Server.MapPath(".") + "\\" + VUrl))//判斷此教程是否存在
{
string dlsql = "delete from tb_Video where VideoID=" + Convert.ToInt32(Request.QueryString["VideoID"]);
mydo.adlData(dlsql);
Page.RegisterStartupScript("true", "<script>alert('檔案不存在!請返回!');location='index.aspx'</script>");
}
VideoTitle = odr["VideoName"].ToString();
Content = odr["VideoContent"].ToString();
Name = odr["Name"].ToString();
FBDate = odr["FBDate"].ToString();
ClickSum = odr["ClickSum"].ToString();
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
}
檔案下載:
if (Session["UserName"] != null)
{
string path = Server.MapPath(".\\") + VUrl;
//初始化 FileInfo 類的執行個體,它作為檔案路徑的封裝
FileInfo fi = new FileInfo(path);
Response.Write(path);
// 判斷檔案是否存在
if (fi.Exists)
{
// 將檔案儲存到本機上
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(fi.Name));
Response.AddHeader("Content-Length", fi.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.Filter.Close();
Response.WriteFile(fi.FullName);
Response.End();
}