DaniWeb Forum Index > Software Development > C#

C# RSS

Reading binary data from SPROC..help please...

Please support our C# advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Dec 2007

Posts: 6

Reputation: sean_morris9 is an unknown quantity at this point

Solved Threads: 0

sean_morris9 sean_morris9 is offline

Offline

Newbie Poster

Reading binary data from SPROC..help please...

Feb 26th, 2008

Hi,

I'm trying to display an image that's stored in a SQL Server database. The ContentType and binary data are being returned but the image is coming up as a broken image. To test that the data is being retrieved I tried outputting the content type.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
 Response.Write(adm["Image_MIME_type"].ToString());
 Response.Write(adm["Image_MIME_type"].ToString());

It is getting the corect data i.e. "image/pjpeg"

Then I tried Response.write for the binary data returned

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
Response.Write((byte[])adm["Image_image"]);
Response.Write((byte[])adm["Image_image"]);

It is outputting printing "System.Byte[]"

Am I right in saying the data is being returned from the SPROC?

Here is the code...

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
 
 if (adm.HasRows)
            {
 
                while (adm.Read())
                {
                 // Response.Write(adm["Image_MIME_type"].ToString());
 
                        Response.ContentType = adm["Image_MIME_type"].ToString();
                        Response.BinaryWrite((byte[])adm["Image_image"]);  
                }
            }
            else
            {
                Response.Write("Reaer has no rows");
 
            }
            adm.Close();
            conn.Close();
 
 if (adm.HasRows)
            {
                
                while (adm.Read())
                {
                 // Response.Write(adm["Image_MIME_type"].ToString());
                 
                        Response.ContentType = adm["Image_MIME_type"].ToString();
                        Response.BinaryWrite((byte[])adm["Image_image"]);  
                }
            }
            else
            {
                Response.Write("Reaer has no rows");

            }
            adm.Close();
            conn.Close();

•

Join Date: Dec 2007

Posts: 6

Reputation: sean_morris9 is an unknown quantity at this point

Solved Threads: 0

sean_morris9 sean_morris9 is offline

Offline

Newbie Poster

Re: Reading binary data from SPROC..help please...

Feb 26th, 2008

Any help would be great, thanks!

•

Join Date: Nov 2006

Posts: 436

Reputation: JerryShaw is on a distinguished road

Solved Threads: 72

JerryShaw

Offline

Posting Pro in Training

Re: Reading binary data from SPROC..help please...

Feb 26th, 2008

Load the image into a byte array.
Pass the byte array into a memory stream
Pass the memory stream into a new or existing bitmap.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
 
byte[] b = (byte[])adm["Image_image"];
System.IO.MemoryStream stream = new System.IO.MemoryStream(b, true);
                        stream.Write(b, 0, b.Length);
 
Bitmap bmp = new Bitmap(stream);
byte[] b = (byte[])adm["Image_image"];
System.IO.MemoryStream stream = new System.IO.MemoryStream(b, true);
                        stream.Write(b, 0, b.Length);

Bitmap bmp = new Bitmap(stream);