NOTE: do not use this in production as this is vulnerable to sql injection:   "select Blob from DocumentMain where (DocumentName = '" + thisTitle + "') and documentStatuscode ='40' ";

Here is the general idea... put this .ascx as a simple iPart in a WCM page.  Then pass a query string to it i.e.  ReadBlob.aspx?title=MyStory

This will pulll the html content from the blob with that title.  before delpoying we restricted access to particular folders so no one could pull just any content from the db. This is just sample code to show how to read html from the blob, not necesarily ready for production.   

This is just proof of concept for reading BLOB, no warrenties, etc.

<%@ Control Language="C#" ClassName="VA_ReadContent"  Inherits="System.Web.UI.UserControl"  %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Collections" %>
<%@ Import Namespace="System" %>

<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Xml" %>

<script runat="server">
   
   
   
    protected  override  void OnLoad(EventArgs e)
    {
        SqlDataReader rdr = null;
        SqlConnection con = null;
        SqlCommand cmd = null;

        string ConnectionString = System.Configuration.ConfigurationManager.AppSettings["va_WCM_Connection"].ToString();

        con = new SqlConnection(ConnectionString);
        con.Open();

        // Set up a command with the given query and associate
        // this with the current connection.
        string thisTitle = Request.QueryString["title"];

        string CommandText = "  select Blob from DocumentMain where (DocumentName = '" + thisTitle + "') and documentStatuscode ='40' ";
        cmd = new SqlCommand(CommandText);
        cmd.Connection = con;

        rdr = cmd.ExecuteReader();
        rdr.Read();
        int bufferSize = 10000;
        byte[] ByteArray = new byte[bufferSize];
        System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();

        int startIndex = 0;

        string s = "";

        try
        {
            long ReadChars = rdr.GetBytes(0, 0, ByteArray, 0, bufferSize);

            while (ReadChars == bufferSize)
            {
                s += enc.GetString(ByteArray);
                startIndex += bufferSize;
                ReadChars = rdr.GetBytes(0, startIndex, ByteArray, 0, bufferSize);
            }

            s += enc.GetString(ByteArray);

            // Close data reader object and database connection
            if (rdr != null)
                rdr.Close();

            if (con.State == ConnectionState.Open)
                con.Close();

            // FOR NOW, use string manipulation to show the INNER html
            int myStart = s.IndexOf("<b:Body>");
            int myEnd = s.IndexOf("</b:Body>");

            s = s.Substring(myStart + 8, myEnd - myStart - 8);
            s = Server.HtmlDecode(s);

            s = s.Replace("[Root]", ConfigurationSettings.AppSettings["VA_ImagesPath"]);

            ltrMessage.Text = s;
        }
        catch
        {
            ltrMessage.Text = "No content found or other error.";

        }
          
     ltrMessage.Visible = true;

    }
</script>

 <asp:Literal ID="ltrMessage" runat="server"></asp:Literal>