Solved

Extracting blob data and binding to datagrid asp.net 1.1 vb.net

Posted on 2007-04-11
3
665 Views
Last Modified: 2012-05-05
Experts, I am trying to bind blob's do a datagrid which I have never done in asp.net 1.1.  We have a database table that stores pdf's, docs, and gif's as blobs.  How do I extract blob's and bind it to a datagrid?
What I would like to do in the datagrid is have a hyper link column that when clicked displays the blob in its format as doc, pdf, gif etc.  Any ideas?
0
Comment
Question by:tentavarious
  • 2
3 Comments
 
LVL 4

Expert Comment

by:jasco4617
ID: 18892442
Tentavarious,

You would need to have a page, lets call it download.aspx and pass it a document ID that would be the the primary key for the column that has the stored blob data.

you would then need to have a query that pulls that information from the database and use that data to modify the http header for the request and stream the blob data.  See the below example.

--------
        Byte[] content = new Byte[0];
        String filename = "";
        String contentType = "";

        Response.ContentType = contentType;
        Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);
        Response.BinaryWrite(content);
        Response.End();
-------

You would set the appriate variable information from what was returned in your query.   for this to work correctly, you must have the contentType (mime type) or else the browser will not know how to work with the data.

I hope this answers your question and points you in the right direction.

- pat
0
 

Author Comment

by:tentavarious
ID: 18897912
i was actually looking for maybe and example of using a datareader or dataset to read in the blob column.  Is there something special I need to do?
0
 
LVL 4

Accepted Solution

by:
jasco4617 earned 250 total points
ID: 18898575
Here is an example from .net 2.0....i am not sure if this is the same with 1.1 or not though (i think it is, give it a shot):




protected void Page_Load(object sender, EventArgs e)
    {
        String doc = Request.QueryString["doc"];
        try
        {
            Int32.Parse(doc);
        }
        catch
        {
            Response.Redirect("Default.aspx");
        }

        SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["SQLConnString"].ConnectionString);
        SqlCommand cmd = new SqlCommand("SELECT files.*, fileTypes.* FROM files INNER JOIN fileTypes ON files.typeID = fileTypes.typeID WHERE fileID=@fileID", conn);
        cmd.Parameters.Add("@fileID", SqlDbType.Int).Value = doc;
        cmd.Connection.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        Byte[] content = new Byte[0];
        String filename = "";
        String contentType = "";
        if (reader.HasRows)
        {
            while (reader.Read())
            {
                contentType = reader.GetValue(6).ToString();

                //content = new Byte[reader.GetInt32(7)];
                content = reader.GetSqlBytes(5).Buffer;
                //reader.GetBytes(5, 0, content, 0, reader.GetInt32(7));
                filename = reader.GetValue(1).ToString();
            }
        }

        cmd.Connection.Close();

        Response.ContentType = contentType;
        Response.AddHeader("Content-Disposition", "attachment; filename=" + filename);
        Response.BinaryWrite(content);
        Response.End();
    }
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now