Showing Image in asp page from sql server.

//I am not a byte a array so  i am selecting an image from openfiledialogbox and converting it to byte[].
openFileDialog1.ShowDialog();
Image img = Image.FromFile(openFileDialog1.FileName);
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] bt = ms.ToArray();
//till now i had converted my image in to byte[].
//now from this byte[] i am creating a Image

MemoryStream ms2 = new MemoryStream(bt);
System.Drawing.Image img2 = System.Drawing.Image.FromStream(ms2);
//i got my image.

Bitmap bit = new Bitmap(200, 200);
Graphics g = Graphics.FromImage(bit);
g.DrawImage(img2, new Point(0, 0));
bit.Save("abc.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
MessageBox.Show("Done");
yourImageControl.ImageUrl = "Images/abc.jpg";
//just replace the path "abc.jpg" in your code with "Server.MapPath("Images/abc.jpg")"

Here is the solution,

Default.aspx.cs

using System.IO;
using System.Drawing;
//For inserting image in to database.
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (FileUpload1.HasFile)
        {
            System.Drawing.Image img = System.Drawing.Image.FromFile(Server.MapPath("Images/abc.jpg"));
            MemoryStream ms = new MemoryStream();
            img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
            byte[] bt = ms.ToArray();
            ViewState["byteArray"] = bt;
        }
    }
    //For Fetching image from database
    protected void Button2_Click(object sender, EventArgs e)
    {
        byte[] bt = ViewState["byteArray"] as byte[];
        MemoryStream ms2 = new MemoryStream(bt);
        System.Drawing.Image imgPhoto = System.Drawing.Image.FromStream(ms2);
        Bitmap bit = new Bitmap(ms2, true);
        bit.Save(Server.MapPath("Images/abc.jpg"), System.Drawing.Imaging.ImageFormat.Jpeg);
        Image1.ImageUrl = "Images/abc.jpg";
    }

Code for Default.aspx

<form id="form1" runat="server">

   <asp:FileUpload ID="FileUpload1" runat="server" />
   <asp:Button ID="Button1" runat="server" Text="Upload" onclick="Button1_Click" />
   <br />
   <asp:Image ID="Image1" runat="server"  Height="200px" Width="200px"/>
   <asp:Button ID="Button2" runat="server" Text="Fetch Image"
       onclick="Button2_Click" />

   </form>

You need to implement Genric Handler. Here are some examples

How to store and retrieve images from SQL server database using asp.net?[^]
Display image from database in ASP.net with C#[^]


[Edit member="Tadit"]
Link text added to reflect the article title.
[/Edit]

I made a mistake in my initial solution. WebControls.Image is just a HTML container for an image URL - you can't store the image data directly in it, you just store the reference (URL) to an image file. If you need to retrieve image data dynamically, the usual approach is to create an image handler that will handle the request and return the image as a stream that the browser can display. You can create ASPX page that will return image file as byte array with appropriate headers information, to get image you will be able to call this page like imagemanager.aspx?imgid=31337

Then in your main page in system.web.ui.webcontrols.image control set ImageUrl property to your script path:

ctrlImage.ImageUrl = "imagemanager.aspx?imgid=31337";

Here is example of method to output you image in imagemanager.aspx:

private void TransmitBytes(byte[] bytes, string outFileName)
{
    Response.Clear();
    Response.AddHeader("Content-Disposition", "attachment; filename=" + outFileName);
    Response.AddHeader("Content-Length", bytes.Length.ToString());
    Response.ContentType = "image/jpeg";
    Response.BinaryWrite(bytes);
    Response.End();
}

This should work :)


[Edit member="Tadit"]
Corrected formatting issues.
[/Edit]

This is code you had posted i am justion adding 2-3 line as solution to this question.

TextBox Name1 = LoginUser.FindControl("UserName") as TextBox;
String Name = Name1.Text;
TextBox pass = LoginUser.FindControl("Password") as TextBox;
String pass2 = pass.Text;
SqlCommand cmd = new SqlCommand("Select * from UserInfo where UserName1 = '" + Name + "' And Password1 = '" + pass2 + "'", conn);
conn.Open();<pre></pre>
dr = cmd.ExecuteReader();
if (dr.HasRows)
{ dr.Read();
byte[] b = (byte[])dr[3];
MemoryStream ms = new MemoryStream(b);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);

Bitmap bit = new Bitmap(200,200);

Graphics g = Graphics.FromImage(img);
g.DrawImage(img,new Point(0,0));

bit.Save(Server.MapPath("Images/abc.jpg"), System.Drawing.Imaging.ImageFormat.Jpeg);
yourImageControl.ImageUrl = "Images/abc.jpg";

this is how it done.actually you are reading a byte[] from database so create image from this byte array and store that image in some location and give that location to you image contorl.
second option is use Image handler mean create a handler that will display image.
second one i think is complex.