how to convert image to byte

Question

0.00/5 (No votes)

See more:

Hi everyone,

Here is my code, I am facing problem in converting image to byte format.
Also value is getting populated in database but when I want to show the image in gridview it shows nothing.

Please help....
I dont understand if this is the problem or anything else is the problem
here null value is getting populated from database....

 public byte[] ShowEmpImage(int wids)
{
    int flag = 0;

    SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["WATERMARKING"].ConnectionString);
    connection.Open();
    SqlCommand imid = new SqlCommand("SELECT IMAGE_ID from WATERMARKED_IMAGES", connection);
    SqlCommand wid = new SqlCommand("SELECT WID from WATERMARKED_IMAGES where FLAG='" + flag + "'", connection);
    wids = Convert.ToInt32(wid.ExecuteScalar());
    SqlCommand photoCommand = new SqlCommand("SELECT IMAGE.IMAGE_CONTENT  FROM   WATERMARKED_IMAGES INNER JOIN   IMAGE ON WATERMARKED_IMAGES.IMAGE_ID = IMAGE.IMAGE_ID where WATERMARKED_IMAGES.FLAG='" + flag + "'  ", connection);
       // Get bytes return from DB Command
    byte[] b = (byte[])photoCommand.ExecuteScalar();
    if (b.Length > 0)
    {
        return b;
    }



}

Posted 18-Mar-11 23:01pm

RKT S

Updated 19-Mar-11 1:58am

Rajesh Anuhya

v6

Add a Solution

Comments

Abdul Quader Mamun 19-Mar-11 6:47am

Too big

RKT S 19-Mar-11 7:35am

now i have shorten it...:)

Dalek Dave 19-Mar-11 7:04am

Edited for Grammar and Readability.

Toli Cuturicu 19-Mar-11 16:26pm

Only an 1x8 monochrome image can be converted to a byte?!

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)

#realJSOP · Answer 1 · 2011-03-19T01:11:00

You posted way too much code. I didn't bother to look through it. Using google, I found this code in a CP article:

C#

public byte[] ImageToByteArray( System.Drawing.Image p_ImageIn )
{
    byte[] aRet = null;
    using ( System.IO.MemoryStream oMS = new System.IO.MemoryStream() )
    {
        p_ImageIn.Save( oMS, System.Drawing.Imaging.ImageFormat.Gif );
        aRet = oMS.ToArray();
    }
    // Possibly dispose image too here, if no extra manipulation is needed
    // Remember, Image is sent by ref, so if you dispose it inside method it will 
    // not be available outside either.
    // p_ImageIn.Dispose();
    return aRet;
}

Theingi Win · Answer 2 · 2011-03-19T06:55:00

Solution 2

You should study these link

Posted 19-Mar-11 6:55am

Theingi Win