How to convert an image into binary format and save/retrieve it?

Question

0.00/5 (No votes)

See more:

Hi Everybody,

I want small help from you guys. I have some images. I need the images to store in sql server database with the format of binary and the same image has to convert back from binary while retrieving from database and placed in picture box in windows application.

Can you please help me to do this.

Thanks& Regards,
Venkata Sandeep P

Posted 26-Mar-11 19:56pm

sandeep.paruchuru

Updated 26-Mar-11 20:23pm

Sandeep Mewara

v2

Add a Solution

Comments

Sandeep Mewara 27-Mar-11 2:23am

Make effort now, if you face specific issue then post back.

3 solutions

Solution 1

Here, go through this article, it has more than you seek: C# Photo Album Viewer[^]

Posted 26-Mar-11 20:21pm

Sandeep Mewara

Solution 3

you shuold do this:

using system.io;
using system.data.sqlclient; 



public partial class Form1 : Form
    {
        SqlConnection con = new SqlConnection();
        string _path;
        public Form1()
        {
            InitializeComponent();
        }

        //convert Image to binary and save in DB
        private void button1_Click(object sender, EventArgs e)
        {
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {

                    _path = openFileDialog1.FileName;

                   
                    InsertInSQL(_path);
                    
                
            }
          
        }

        private void InsertInSQL(string _path)
        {
            con.ConnectionString = Pic.Properties.Settings.Default.ConnectionS;
        string strQ = "insert into dbo.PicTBL(Pic)values(@p)";
        SqlCommand command = new SqlCommand(strQ,con);
        command.Parameters.AddWithValue("@p",ImageToBinary(_path));
        con.Open();
        command.ExecuteNonQuery();
        con.Close();
        }      

        public static byte[] ImageToBinary(string _path)
        {
            FileStream fS = new FileStream(_path, FileMode.Open, FileAccess.Read);
                   byte[] b = new byte[fS.Length];
                   fS.Read(b, 0, (int)fS.Length);
                   fS.Close();
                   return b;
        }

                    
 



         //Convert Binary to imge and save in a folder



        private void button1_Click_1(object sender, EventArgs e)
        {
                     

            DataTable dt = Rimage();

            foreach (DataRow row in dt.Rows)
            {
                byte[] b = (byte[])row["Pic"];
                Image img = BinaryToImage(b);
                img.Save("D:\\NewFolder\\" + row["ID"].ToString() + ".jpg");
            }

            
       }

         private Image BinaryToImage(byte[] b)
          {
            if (b == null) 
                return null;
         
    
           MemoryStream memStream = new MemoryStream();
           memStream.Write(b, 0, b.Length);

           return Image.FromStream(memStream);
 	
           }

               private DataTable Rimage()
                 {
                 con.ConnectionString = Pic.Properties.Settings.Default.ConnectionS;
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = "select * from dbo.PicTBL";
                 cmd.Connection = con;
                 SqlDataAdapter adp = new SqlDataAdapter(cmd);
                 DataTable dt = new DataTable();
                 con.Open();
                 adp.Fill(dt);
              
                 return dt;

        }
       

       
    }

Posted 7-Jul-12 20:40pm

Mina Mansouri

Updated 18-Oct-12 3:33am

v2

Comments

Sandeep Mewara 8-Jul-12 2:55am

This is more than 1.5yrs old question, do you think OP will be still waiting for an answer?

Mina Mansouri 9-Jul-12 1:43am

I did not mention to its time :D

Mina Mansouri 9-Jul-12 1:43am

and so what do you do here?????!!!!!!

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)

Manish Choudhary .NET expert · Accepted Answer · 2011-03-26T20:26:00

Yes you can do this easily. Set the datatype of the field
"Image" in which you want to store the Image. Now you have to convert the image in byte array(byte[]). Now by Query or Stored procedure insert data in the table. To retrieve the Image use reverse process.

To convert image or any other object to byte array you can use the function written below.....

public byte[] ObjectToByteArray(Object obj)
        {
            if (obj == null)
                return null;
            BinaryFormatter bf = new BinaryFormatter();
            MemoryStream ms = new MemoryStream();
            bf.Serialize(ms, obj);
            return ms.ToArray();
        }

Convert a byte array to an Object

public Object ByteArrayToObject(byte[] arrBytes)
      {
           MemoryStream memStream = new MemoryStream();
           BinaryFormatter binForm = new BinaryFormatter();
           memStream.Write(arrBytes, 0, arrBytes.Length);
           memStream.Seek(0, SeekOrigin.Begin);
           Object obj = (Object)binForm.Deserialize(memStream);
           return obj;
       }