Please support our C# advertiser: Programming Forums
Views: 7905 | Replies: 7
 |
•
•
Join Date: Mar 2005
Location: Ottawa, Ontario, Canada
Posts: 959
Reputation: 
Rep Power: 5
Solved Threads: 2
Posting Shark
Is there a way to download an image (binary) from a database in sql server and insert it on a page as an image control? I want to add the image to a page when it loads. I can't figure how to do it and I am not sure if it is possible to do.
thx
thx
•
•
Join Date: Jul 2003
Location: Bamberg, Germany
Posts: 117
Reputation:
Rep Power: 6
Solved Threads: 2
Junior Poster
I've never actually done that, but I'm guessing you're going to have to create some sort of BinaryStream then create a file out of that, then use the BitMap.LoadFromFile() method to load the picture....I'm not actualy sure though.
•
•
Join Date: Mar 2005
Location: Ottawa, Ontario, Canada
Posts: 959
Reputation:
Rep Power: 5
Solved Threads: 2
Posting Shark
I found a way to do it. I uploaded all the thousands of images to the DB. Now to show them up, I download the one I need to the server, then just show it on the page. It's fine like this but if anybody would know if it is possible to show the image on a page without copying the file to a drive, it would be nice... thx
•
•
Join Date: Dec 2004
Posts: 1,592
Reputation:
Rep Power: 7
Solved Threads: 35
You set the image into the HTTP response stream, setting the proper MIME type, of course. Do an internet search for "image response stream".
This question might have been answered sooner if it were posted in the Web Development | ASP.NET forum.
This question might have been answered sooner if it were posted in the Web Development | ASP.NET forum.
•
•
Join Date: Mar 2005
Location: Ottawa, Ontario, Canada
Posts: 959
Reputation:
Rep Power: 5
Solved Threads: 2
Posting Shark
•
•
•
•
Originally Posted by tgreer
You set the image into the HTTP response stream, setting the proper MIME type, of course. Do an internet search for "image response stream".
This question might have been answered sooner if it were posted in the Web Development | ASP.NET forum.
Youre right I should've posted this in the .NET forum.
•
•
Join Date: Dec 2004
Posts: 1,592
Reputation:
Rep Power: 7
Solved Threads: 35
No, the technique is to create a webform/aspx application that retrieves an image from the database, and streams it out.
Then, the image CONSUMER application would have an img tag. The "src" attribute is set to the image PRODUCER application.
So if you a red and a blue image, you might have a src as such:
<img src=:http://www.belama.org/imageSelect.aspx?img=red">
The imageSelect.aspx would use the querystring to retrieve the "red" image from the database and stream it back.
Then, the image CONSUMER application would have an img tag. The "src" attribute is set to the image PRODUCER application.
So if you a red and a blue image, you might have a src as such:
<img src=:http://www.belama.org/imageSelect.aspx?img=red">
The imageSelect.aspx would use the querystring to retrieve the "red" image from the database and stream it back.
•
•
Join Date: Dec 2004
Posts: 1,592
Reputation:
Rep Power: 7
Solved Threads: 35
Something like this, in the code-behind. This is code that creates an in-memory graphic, but you could just as well retrieve the image from a database:
That code SAVES the image. To SERVE the image, instead, you could use:
Then to use this code inside of another HTML and/or WebForm page, set the img src to the image producing page.
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Drawing.Imaging;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace charts
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Image Image1;
private void Page_Load(object sender, System.EventArgs e)
{
DisplayLine();
Image1.ImageUrl = Server.MapPath("")+"temp.jpg";
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void DisplayLine()
{
Bitmap b =new Bitmap(250,250);
b.Save(Server.MapPath("")+"temp.jpg",ImageFormat.Jpeg);
Graphics g = Graphics.FromImage(b);
g.Clear(Color.White);
Pen p = new Pen(Color.Blue);
g.DrawLine(p,10,240,240,240);
b.Save(Server.MapPath("")+"temp.jpg",ImageFormat.Jpeg);
}
}
}That code SAVES the image. To SERVE the image, instead, you could use:
Response.ContentType = "image/jpeg"; b.Save(Response.OutputStream, ImageFormat.Jpeg);
Then to use this code inside of another HTML and/or WebForm page, set the img src to the image producing page.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
