Sending/Recieving PictureBox Image in C# To/From Microsoft SQL SERVER

Introduction

This Article is intended to fullfill the lack of clarity in Retrieving and sending PictureBox image

or lets say any image in win application to database and vice versa.So guys don't Panic,Relax

because the code is so simple.

Background

I will advice those guys who are not still familiar with SQL Language and Broadly Speaking not having of database interaction knowledge in win application in .NET to leave this page and go after those mentioned items.

Using the code

the full code with comment in each line is showned in below,enjoy it!

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO;

//author:Morteza Naeimabadi  Location=IRAN ,Yazd
//written in 2008/03/12


namespace SampleOfMorteza
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //we are using SQl express.
            //My database name is "PictureDb".
            SqlConnection con = new SqlConnection("Server=.;database=PictureDb;integrated security=true");
            //i have used a table named "tblUsers" and fill their fields
            SqlCommand com = new SqlCommand("insert into tblUsers(fldCode,fldPic) values(1,@Pic)", con);
            
            //in here i have to save the picturebox image to tblUsers
            //because you couldn't able to send the PictureBox1.Image to field "fldPic" that is of kind 
            //"image" in SQL SERVER EXPRESS ,then you should do somthing else and that is converting
            //your picture box image to array of bytes and tehn sending that array to database.
            //in below we have used a stream which will be used to contain our picturebox image bytes.
            MemoryStream stream=new MemoryStream();
            //through the instruction below we does save the image to byte in the object "stream".
            pictureBox1.Image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);

            //the below is the most important part,actually you are transferring the bytes of array 
            //to the pic which is also of kind byte[]
            byte[] pic=stream.ToArray();

            com.Parameters.AddWithValue("@Pic", pic);
            try
            {
                con.Open();
                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                con.Close();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection connect = new SqlConnection("Server=.;database=PictureDb;integrated security=true");
            SqlCommand command = new SqlCommand("select fldPic from tblUsers where fldCode=1", connect);
            //for retrieving the image field in SQL SERVER EXPRESS Database you should first bring 
            //that image in DataList or  DataTable
            //then add the content to the byte[] array.
            //That's ALL!
            SqlDataAdapter dp = new SqlDataAdapter(command);
            DataSet ds = new DataSet("MyImages");

            byte[] MyData = new byte[0];

            dp.Fill(ds, "MyImages");
            DataRow myRow;
            myRow = ds.Tables["MyImages"].Rows[0];

            MyData = (byte[])myRow["fldPic"];


            MemoryStream stream = new MemoryStream(MyData);
            //With below you are in fact converting the byte array of image to the real image.
            pictureBox2.Image = Image.FromStream(stream);
            
        }
    }
}
         

the coding image is:

Points of Interest

Working with RFID Technology in .NET,Serial communication in C# win app,all win app related topics.

History

I am Morteza Naeimabadi,Born in IRAN.I was been raised in India and also IRAN.I do programming about 3 to 4 years.22 Years Old.Married.Love my Wife(Sindokht).Crazy in learning new things.especially new things in .NET.