Retrieving image from SQL (C#) problem

[Bjorn Sagbakken]

This is kind of silly, but I just cannot figure out why:

In ASP.NET 2.0 I am retrieving images from a MS SQL server, and writing them
as binary to a separate page as the url for image controls, everything by
the book. I have been doing this a lot with VB. Now I am writing a new
application in C#, and the strange thng is this:

- it works well in debug mode
- but not on the published folder on the same server (localhost) - image
frames all have a cross in them
- a VB coded Image.aspx works well also on the published folder

Her is the C# code in the Image.aspx file::

.....som init code...

SqlConnection con = new SqlConnection(i nit.con());
con.Open();
string strSQL = "SELECT img FROM photo where ID= " + ID;
SqlCommand cmd = new SqlCommand(strS QL, con);
imagebyte = (byte[])cmd.ExecuteSca lar();
con.Close();
Response.Clear( );
Response.Conten tType = "image/jpeg";
Response.Binary Write(imagebyte );
Response.Buffer Output= true;

--Why does this work in debug mode, and not on the published folder?

Bjorn

[Eliyahu Goldin]

If you set Response.Buffer Output= true; you will likely need to call
Response.Flush( ); at some stage.

If the page is just serving images, there should not be any reason for
setting Response.Buffer Output= true.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Bjorn Sagbakken" <bj*****@online .nowrote in message
news:3_******** *************@t elenor.com...

This is kind of silly, but I just cannot figure out why:

In ASP.NET 2.0 I am retrieving images from a MS SQL server, and writing
them as binary to a separate page as the url for image controls,
everything by the book. I have been doing this a lot with VB. Now I am
writing a new application in C#, and the strange thng is this:

- it works well in debug mode
- but not on the published folder on the same server (localhost) - image
frames all have a cross in them
- a VB coded Image.aspx works well also on the published folder

Her is the C# code in the Image.aspx file::

....som init code...

SqlConnection con = new SqlConnection(i nit.con());
con.Open();
string strSQL = "SELECT img FROM photo where ID= " + ID;
SqlCommand cmd = new SqlCommand(strS QL, con);
imagebyte = (byte[])cmd.ExecuteSca lar();
con.Close();
Response.Clear( );
Response.Conten tType = "image/jpeg";
Response.Binary Write(imagebyte );
Response.Buffer Output= true;

--Why does this work in debug mode, and not on the published folder?

Bjorn

[Bjorn Sagbakken]

"Eliyahu Goldin" <RE************ **************@ mMvVpPsS.orgwro te in
message news:O1******** ******@TK2MSFTN GP03.phx.gbl...

If you set Response.Buffer Output= true; you will likely need to call
Response.Flush( ); at some stage.

If the page is just serving images, there should not be any reason for
setting Response.Buffer Output= true.

Well, I removed the Response.Buffer Output=true

and still the result is the same: in debug mode this works, but not when
running on the published folder.

Bjorn