Image Save and Retrieve in SQL Server in asp.net using c#

Question

I am trying to save images in a SQL Server database.

I convert the image to bytes and store in SQL Server, but now I want to convert the saved bytes to an image and show it on a label in asp.net using c#.

I tried a lot but didn't find a solution.

Here is the code (convert bytes to Image)

if (fImage.HasFile)
{
    if (fImage.PostedFile.ContentType == "image/jpg" || fImage.PostedFile.ContentType == "image/jpeg" || fImage.PostedFile.ContentType == "image/png")
    {
       int filelenght = fImage.PostedFile.ContentLength;
       byte[] imagebytes = new  byte[filelenght];
       fImage.PostedFile.InputStream.Read(imagebytes, 0, filelenght);
       SqlCommand cmd = new SqlCommand();
       cmd.CommandText = "Insert into tbImage(Img) values(@img)";
       cmd.Connection = con;
       cmd.Parameters.AddWithValue("@img", imagebytes);
       con.Open();
       cmd.ExecuteNonQuery();
       con.Close();
       Response.Write("Image saved to database");
    }
}

Wahtever · Accepted Answer · 2014-02-19 12:13:06Z

5

Something like this will convert Byte[] to Image:

MemoryStream ms = new MemoryStream(byte);
Image i = Image.FromStream(ms);

answered Feb 19, 2014 at 12:13

Wahtever

3,69810 gold badges47 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Md Shahriar · Accepted Answer · 2016-12-27 19:12:35Z

1

SqlCommand cmd = new SqlCommand("Select img from tbImage where id = " + id, con);

con.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.HasRows)
{
    while (reader.Read())
    {
        byte[] img = (byte[])reader["img"];

        MemoryStream ms = new MemoryStream(img);

        PictureBox1.Image = Image.FromStream(ms);
    }
}

con.Close();

answered Dec 27, 2016 at 19:12

Md Shahriar

2,86227 silver badges17 bronze badges

1 Comment

Maerlyn Over a year ago

Can you add some explanation, so it's more than just a wall of code?

RononDex · Accepted Answer · 2014-02-19 12:13:27Z

0

All you need to do is to store the byte content in a variable and then write it to the File system:

var imgBlob = ... // Load the image binary array from the database
File.WriteAllBytes("path/to/file.jpg", imgBlob);

answered Feb 19, 2014 at 12:13

RononDex

4,19527 silver badges40 bronze badges

Comments

Matt Tabor · Accepted Answer · 2014-02-19 12:14:15Z

0

you can create a controller action to handle retrieving the image

    public FileResult DownloadImage(int Photo_Id)
    {

        byte[] fileBytes = "get bytes from db here";
        string fileName = "file name here"

        return File(fileBytes, "contentType of the image" , fileName);

    }

answered Feb 19, 2014 at 12:14

Matt Tabor

1,0538 silver badges10 bronze badges

Comments

Sahil Verma · Accepted Answer · 2014-02-21 05:15:44Z

0

Thanks for your valuable reply.

i solve this problem with this one. give a look.

int id = Convert.ToInt32(drpImage.SelectedValue);

    SqlCommand cmd = new SqlCommand("Select img from tbImage where id = " + id+"", con);
    con.Open();
    SqlDataReader dr = null;
    dr = cmd.ExecuteReader();
    if (dr.HasRows)
    {
        while (dr.Read())
        {
            byte[] img = (byte[])dr["img"];
            string base64string = Convert.ToBase64String(img, 0, img.Length);

            lblImage.Text += "<img src='data:image/png;base64," + base64string + "' alt='No Image' width='200px' vspace='5px' hspace='5px' />";
        }
    }
    con.Close();

answered Feb 21, 2014 at 5:15

Sahil Verma

331 gold badge1 silver badge5 bronze badges

Collectives™ on Stack Overflow

Image Save and Retrieve in SQL Server in asp.net using c#

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related