Click here to Skip to main content
Click here to Skip to main content

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

, 10 May 2008 CPOL
Rate this:
Please Sign up or sign in to vote.
This article is written for those stuck in such a problem

Introduction

This article is intended to fulfill the lack of clarity in retrieving and sending PictureBox images or let's say any image in a Windows application to a database and vice versa. So guys, don't panic, just relax because the code is so simple.

Background

I will advice those guys who are still not familiar with the SQL language and broadly speaking, those not having database interaction knowledge in Windows application in .NET to leave this page and go after those mentioned items.

Using the Code

The entire code with comments in each line is shown 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 the 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 were not able to send the PictureBox1.Image
            //to field "fldPic" that is of kind
            //"image" in SQL SERVER EXPRESS, then you should do something else
            // and that is converting
            //your picture box image to an array of bytes and then sending
            //that array to database.
            //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 save the
            //image to byte in the object "stream".
            pictureBox1.Image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);

            //Below is the most important part, actually you are
            //transferring the bytes of the 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 the code below, you are in fact converting the byte array of image
            //to the real image.
            pictureBox2.Image = Image.FromStream(stream);
        }
    }
}

History

  • 11th May, 2008: Initial post

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Morteza Naeiamabadi
Software Developer (Senior)
Iran (Islamic Republic Of) Iran (Islamic Republic Of)
independent IT Consultant,Currently engaged with Sharepoint developing and MVC Asp.net apps

Comments and Discussions

 
QuestionParameter is invalid PinmemberMember 1061618425-Sep-14 20:50 
Questiontype of fldPic PinmemberCP-Ayyub12-Apr-14 2:33 
QuestionThanks PinmemberGarima111115-Aug-13 21:02 
Questionsearching by image PinmemberRahul Kumar Ghosh20-Apr-13 18:14 
QuestionSome advises: PinmemberShahin Khorshidnia23-Dec-12 3:00 
QuestionParameter is not valid Pinmembergroupnima19-Oct-12 10:06 
AnswerRe: Parameter is not valid PinmemberMorteza Naeiamabadi21-Oct-12 3:10 
QuestionTHANK YOU!! THANK YOU!! THANK YOU!! THANK YOU!! THANK YOU!! PinmemberMember 802179725-May-12 8:31 
AnswerRe: THANK YOU!! THANK YOU!! THANK YOU!! THANK YOU!! THANK YOU!! PinmemberMorteza Naeiamabadi26-May-12 4:08 
Questionquestion2 Pinmemberaliprogrammer27-Apr-12 3:07 
AnswerRe: question2 PinmemberMorteza Naeiamabadi27-Apr-12 4:33 
GeneralRe: question2 Pinmemberaliprogrammer28-Apr-12 20:19 
Questionquestion Pinmemberaliprogrammer27-Apr-12 2:56 
AnswerRe: question PinmemberMorteza Naeiamabadi27-Apr-12 4:31 
GeneralRe: question Pinmemberaliprogrammer28-Apr-12 20:17 
GeneralMy vote of 5 Pinmemberjalalbabaei17-Mar-12 19:37 
QuestionGOOOOOOOD Pinmemberbalagp14-Jan-12 3:43 
AnswerRe: GOOOOOOOD PinmemberMorteza Naeiamabadi27-Apr-12 4:35 
Questionamir Pinmemberamir 214-Jul-11 22:53 
QuestionThanks Pinmembermahmood seyedkarimi27-Jun-11 0:07 
GeneralMy vote of 5 PinmemberEyewan27-Oct-10 5:01 
GeneralThank u Pinmemberahmed__sobhy18-Sep-10 14:58 
GeneralRetriving Image from Database to Display in a PictureBox in C#.NEt Pinmemberjajaboor17-Jul-10 22:45 
GeneralThank U PinmemberGeorge_Bat15-Dec-08 5:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141030.1 | Last Updated 11 May 2008
Article Copyright 2008 by Morteza Naeiamabadi
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid