Save And Play Video Files on Web Page from Database

Dear all,

 

I have a requirement - I have to save a video file to SQL Server and Play it on Web Page.

 

1. Save Video on SQL Server database  table - done - varbinary(max) datatype.

2. Load Video details on Gridview. - Done.

3. Play Video - How to do this ??

 

In database - I have -

1. ID - int primary key

2. File Name - varchar(max)

3. Data - varbinary(max)

 

I have loaded ID and File Name on grid view... How to play video on web page?

 

ASPX File -  

---

HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White">

-------

ASPX.cs file -

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Configuration;
using System.Data.SqlClient;
namespace VideoInWeb
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select ID, Name from tblfiles";
cmd.Connection = con;
con.Open();
// DataList1.DataSource = cmd.ExecuteReader();
// DataList1.DataBind();
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
con.Close();
}
}
}

protected void btnupload_Click(object sender, EventArgs e)
{
using (BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream))
{
byte[] bytes = br.ReadBytes((int)FileUpload1.PostedFile.InputStream.Length);
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "insert into tblFiles(Name, ContentType, Data) values (@Name, @ContentType, @Data)";
cmd.Parameters.AddWithValue("@Name", Path.GetFileName(FileUpload1.PostedFile.FileName));
cmd.Parameters.AddWithValue("@ContentType", "audio/mpeg3");
cmd.Parameters.AddWithValue("@Data", bytes);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
Response.Redirect(Request.Url.AbsoluteUri);
}


}
} 

 

Please guide -