Untitled

<pre lang="c#"></pre><pre lang="c#"><%@ Page Language="C#" %>
 <%@ Import Namespace="System.IO" %>
 <%@ Import Namespace="System.Data" %>
 <%@ Import Namespace="System.Data.SqlClient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;script runat="server">

    private void Page_Load(Object sender, EventArgs e)
     {
         string sql = "SELECT * FROM Entry";
         SqlConnection connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True");
         SqlCommand command = new SqlCommand(sql, connection);
         connection.Open();
         FileList.DataSource = command.ExecuteReader();
         FileList.DataBind();
         connection.Close();
     }

&lt;/script>

&lt;html xmlns="http://www.w3.org/1999/xhtml" >
 &lt;head runat="server">
     &lt;title>Untitled Page&lt;/title>
 &lt;/head>
 &lt;body>
     &lt;form id="form1" runat="server">
     <div>
         <asp:DataGrid id="FileList" runat="server" AutoGenerateColumns="false" >
             <Columns>
                 <asp:TemplateColumn HeaderText="Entry Name">
                 <ItemTemplate>
                     <%# DataBinder.Eval(Container.DataItem, "EntryName")%>
                 </ItemTemplate>
                 </asp:TemplateColumn>

                <asp:TemplateColumn HeaderText="Entry Media Type">
                 <ItemTemplate>
                     <%# DataBinder.Eval(Container.DataItem, "EntryMediaMIMEType") %>
                 </ItemTemplate>
                 </asp:TemplateColumn>

                <asp:TemplateColumn HeaderText="Entry Media">
                 <ItemTemplate>
                     <a href="FileHandler.ashx?ID=<%# DataBinder.Eval(Container.DataItem, "EntryID") %>">View File</a>
                 </ItemTemplate>
                 </asp:TemplateColumn>
             </Columns>
         </asp:DataGrid>
     </div>
     &lt;/form>
 &lt;/body>
 &lt;/html></pre>


<b>this is FileHandler.ashx, returns binary stream</b>


<pre lang="c#"><%@ webhandler language="C#" class="MediaHandler" %>
 using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
 public class MediaHandler : IHttpHandler
{
    public bool IsReusable { get { return true; } }

    public void ProcessRequest(HttpContext ctx)
    {
         string sql = "SELECT * FROM Entry WHERE EntryID = '" + ctx.Request.QueryString["ID"] + "'";
         SqlConnection connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True");

        SqlCommand command = new SqlCommand(sql, connection);
         connection.Open();
         SqlDataReader dr = command.ExecuteReader();

        if (dr.Read())
         {
             ctx.Response.Clear();
             ctx.Response.AddHeader("Content-Type", dr["EntryMediaMIMEType"].ToString());
             ctx.Response.BinaryWrite((byte[])dr["EntryMedia"]);
         }

        dr.Close();
         connection.Close();
     }
}  </pre>


<b>this is video.aspx for displaying the video</b>

<pre lang="c#">
<%@ Page Language="C#" %>
 <%@Import Namespace="System.IO" %>
 <%@Import Namespace="System.Data" %>
 <%@Import Namespace="System.Data.SqlClient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;script runat="server">
 &lt;/script>

&lt;html xmlns="http://www.w3.org/1999/xhtml" >
 &lt;head runat="server">
     &lt;title>Untitled Page&lt;/title>
 &lt;/head>
 &lt;body>
     &lt;form id="form1" runat="server">
     <div>
     &lt;object classid="clsid:6BF52A52-394A-11D3-B153-00C04F79FAA6" id="player" width="320" height="260">
         <param name="url" value="FileHandler.ashx?ID=4" />
         <param name="showcontrols" value="true" />
         <param name="autostart" value="true" />
     &lt;/object>
     </div>
     &lt;/form>
 &lt;/body>
 &lt;/html></pre>