Images retrieval from database issue

Muhammad imran

13y1.7k.NET

Hello

i am trying to retrieve images from database.But my code is not working.Please help me.Thanks

SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=company;Integrated Security=True");

conn.Open();

SqlCommand cmd = new SqlCommand("select image from image", conn);

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read()) //yup we found our image

{

Response.ContentType = dr["Image"].ToString();

Response.BinaryWrite((byte[])dr["Image"]);

Response.Write(System.Environment.NewLine);

}

Response.Close();

conn.Close();

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Muhammad imran13y ago
can u guys please help me that how i can build this question answer page.one question and many answers on that.like this one... http://www.c-sharpcorner.com/Forums/Thread/210137/

Parveen Siwach13y ago

To show all images from album, you need to have a bindable control (like: GridView, DataList, ListView, Repeater etc.) with control.

I am explaining with ListView:

                DataSourceID="SqlDataSource1">

                                            ID="groupPlaceholder"
                        runat="server" />

                                                    ID="itemPlaceholder"
                            runat="server" />

                                            ID="picAlbum" runat="server" ImageUrl='<%# "ShowImage.ashx?id=" + Eval("pic_id") %>' />





In this control: "picAlbum" image control will show all the images based on "Pic_Id" from database.

You have to create an Handler(ashx file) e.g.: ShowImage.ashx to render the image based on Pic_Id.

public class ShowImage : IHttpHandler {     public void ProcessRequest(HttpContext context)
    {
        Int32 idNo;
        
        if (context.Request.QueryString["id"] != null)
            idNo = Convert.ToInt32(context.Request.QueryString["id"]);
            
        else
            throw new ArgumentException("No parameter specified");

        context.Response.ContentType = "image/jpeg";
        Stream strm = ShowEmpImage(idNo);
        byte[] buffer = new byte[4096];
        int byteSeq = 0;
        try
        {
            byteSeq = strm.Read(buffer, 0, 4096);

        }
        catch (Exception)
        {
            return;
        }

        while (byteSeq > 0)
        {
            context.Response.OutputStream.Write(buffer, 0, byteSeq);
            byteSeq = strm.Read(buffer, 0, 4096);
        }
    }
}

Earlier shared code also working on same approach.

Hope this will help you to solve your problem.

Muhammad imran13y ago
how we can get multiple images??as we do in album.where we click the button album and get all images relavent to it.
Shankar M13y ago
No Muhammad,

The ExecuteScalar() Method here ,

byte[] image = (byte[])command.ExecuteScalar();

just takes only the first column first row of the result set. And here we are converting it to byte[] array type.

Thanks, Shankar M
Muhammad imran13y ago
Hello thanks dear.Does this works for retrieving the multiple images from database??rather than just getting one image???
Parveen Siwach13y ago
Hi,

you can follow this link:

http://www.codeproject.com/Articles/268123/Display-Store-and-Retrieve-Image-Data-from-Databas

This can help you to solve your problem.
Shankar M13y ago
Hi Muhammad,

I tried it, Its working Fine my dear friend, try this..

Code :

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection cnn;
string connectionString;

connectionString = "Data Source=ServerName; Initial Catalog=dbName; User ID=User Name; Password=password";

cnn = new SqlConnection(connectionString);

MemoryStream stream = new MemoryStream();
cnn.Open();
SqlCommand command = new SqlCommand("select img from imgtable where id=2", cnn);
byte[] image = (byte[])command.ExecuteScalar();
stream.Write(image, 0, image.Length);
cnn.Close();
//Bitmap bitmap = new Bitmap(stream);
Response.BinaryWrite(image);

}
}

Thanks, Shankar M
Muhammad imran13y ago
its nt helping bro..
Shankar M13y ago
Hi Muhammad,

Please try this link,
http://net-informations.com/csprj/dataset/cs-insert-image.htm

http://net-informations.com/csprj/dataset/cs-retrieve-image.htm

Thanks, Shankar M
Jignesh Trivedi13y ago
hi,
I think you must convert your image byte to memory stream object and write with in image object.
please refer
http://www.codeproject.com/Articles/354639/Storing-and-Retrieving-Images-from-SQL-Server-Usin
http://mitch-wheat.blogspot.in/2007/05/save-and-restore-filesimages-to-sql.html
hope this will help you.