why not display image?

Question

0.00/5 (No votes)

See more:

I stored image from a folder to mysql database.image column type mediumblob..
but I cant come back to gridview image control inside templatefield

I am seeing icon but image not comess...

I think binary store and binary convert to image again problem..

WHAT İS THE WRONG?
image insert code

string fileName = fileuploadImage.PostedFile.FileName;
               int fileLength = fileuploadImage.PostedFile.ContentLength;

               byte[] imageBytes = new byte[fileLength];
               fileuploadImage.PostedFile.InputStream.Read(imageBytes, 0, fileLength);

               MySqlConnection conn1 = new MySqlConnection(baglan.connStr1);
               conn1.Open();

             string   sql = "INSERT INTO kayit(ogrno,resim) VALUES" +
                   "('" + fileName + "'" +

                   ",'" + imageBytes + "')";
               MySqlCommand cmd = new MySqlCommand(sql, conn1);
               int count=cmd.ExecuteNonQuery();
               conn1.Close();

image comeback code

this is gridview source

XML

<asp:TemplateField HeaderText="resim">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "xxx.ashx?ImID="+ Eval("id") %>' Height="150px" Width="150px"/>
</ItemTemplate>
</asp:TemplateField>

string imageid = context.Request.QueryString["ImID"];
           MySqlConnection connection = new MySqlConnection(baglan.connStr1);
           connection.Open();
           MySqlCommand command = new MySqlCommand("select resim from kayit where id=" + imageid, connection);
           byte[] buf = (byte[])command.ExecuteScalar();


           context.Response.Clear();
           context.Response.OutputStream.Write(buf, 0, buf.Length);
           context.Response.ContentType = "image/jpeg";
           context.Response.BinaryWrite(buf);
           connection.Close();
           context.Response.End();

this is code

Posted 4-Jun-13 20:36pm

Member-2338430

Updated 4-Jun-13 21:06pm

Bojjaiah

v3

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Jun-13 4:07am

Can you simple debug the ashx handler by putting a debugger in that file and check what its fetching.

And check in DataBase table, if data is getting saved or not in the column "resim" .

Member-2338430 5-Jun-13 4:24am

resim column has 13 byte data so image saved

Member-2338430 5-Jun-13 4:25am

after debug everything ok there is no error anywhere but not seeing image only icon

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Jun-13 6:04am

Check what are you getting in buf variable?

Bojjaiah 5-Jun-13 8:07am

what is the database structure you have? for saving image

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Jun-13 8:28am

You should reply to the OP, instead you replied to me.

Bojjaiah 5-Jun-13 8:44am

hm.. sorry actually I asked this quetion to Member-2338430?not you
well below my solution work fine

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Jun-13 8:54am

No problem...

1 solution

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)

Bojjaiah · Answer 1 · 2013-06-04T21:19:00

try this in handler.ashx page

C#

public void ProcessRequest(HttpContext context)
    {
        //context.Response.ContentType = "text/plain";
        //context.Response.Write("Hello World");
        string imageId = context.Request.QueryString["ImID"];
        SqlConnection con = new SqlConnection(strcon);
        con.Open();
        SqlCommand command = new SqlCommand("select resim from kayit where id=" + imageId, con);
        SqlDataReader dr = command.ExecuteReader();
        dr.Read();
        context.Response.BinaryWrite((Byte[])dr[0]);
        con.Close();
        context.Response.End();


    }

How to Insert and Retrieve Image from DataBase[^]