display binary image in asp.net grid using dataset and datatable? how to

Question

1.00/5 (1 vote)

See more:

methodology explains

My Method link must check

I am using the above method in link to display image in ASP.NET grid but my data is in binary form i have to use same technique is their any API available to add in asp.net grid or web api config that display binary data into grid
here is my ERROR

System.Byte[]

Posted 8-Sep-15 11:28am

Engr Nouman

Updated 8-Sep-15 11:39am

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 8-Sep-15 17:51pm

Please tell me this secret: what, are there such images which are not binary? What are they?
—SA

Engr Nouman 8-Sep-15 19:00pm

then why my grid shows system.byte[] instead of image i have binary data in database

Patrice T 8-Sep-15 20:11pm

SVG ? :)

Sergey Alexandrovich Kryukov 8-Sep-15 21:35pm

Vector format, based on text. But all files/streams are binary, even text. Can't you see that texts are always binary? Everything is binary.
—SA

Engr Nouman 8-Sep-15 19:00pm

then why my grid shows system.byte[] instead of image i have binary data in database

F-ES Sitecore 10-Sep-15 5:25am

Because you are doing "ToString()" on your database field, and when a type can't represent itself as a string it returns the type name instead, so when you ToString a byte array it will return "System.Byte[]" as that is its type nanme.

The article you are using assumes the image is on disc and the image filename held in the database and the file is accessible via a url. Your image is not on disc so is not available via a normal url so this technique isn't going to work. Instead you have to use a handler (as explained in the other solutions) that will allow your image to be accessed via a url.

Engr Nouman 12-Dec-15 4:27am

no 4 different cell db also have null values how to insert images to other 3 remaining feilds by creating more ashx files solution not wors becase id is different for other images and this one is using other it for that id that above image handler is using i shall get other customer ids (using host id) the use them to display images what will be query or alternate way

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ajay_Saini · Answer 1 · 2015-09-08T18:57:00

You need to create a handler (.ashx) and use below code on your GridView

XML

<asp:TemplateField HeaderText="Image">
                        <ItemTemplate>
                            <asp:Image ID="imgPreview" ImageUrl='<%#
                            "ImageHandler.ashx?imgID="+ Eval("ImageID") %>' runat="server"
                                Height="80px" Width="80px" />
                        </ItemTemplate>
                    </asp:TemplateField>

and here is the code you need to write on your ImageHandler.ashx file

C#

public void ProcessRequest(HttpContext context)
    {      
            SqlDataReader rdr = null;
            SqlConnection conn = null;
            SqlCommand selcmd = null;
            try
            {
                conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString);
                selcmd = new SqlCommand("select Image from tblImage where ImageID=" + context.Request.QueryString["imgID"], conn);
                conn.Open();
                rdr = selcmd.ExecuteReader();
                while (rdr.Read())
                {
                    context.Response.ContentType = "image/jpg";
                    context.Response.BinaryWrite((byte[])rdr["Image"]);
                }             
                rdr.Close();
            }
            finally
            {
                conn.Close();
            }  
}

Uttam katariya · Answer 2 · 2015-09-09T20:37:00

Solution 2

Hi
for display binary image in grid
please refer this link
http://stackoverflow.com/questions/19132451/how-to-display-binary-images-into-a-gridview-in-asp-net-using-c[^]

Posted 9-Sep-15 20:37pm

Uttam katariya