How to insert an image to a table in a database

Question

4.00/5 (1 vote)

See more:

How can a image in a picture box be insert into a table in the database?

C#

private void button3_Click(object sender, EventArgs e)  //Add button
{
 if (textBox1.Text == "" ||textBox2.Text==""|| pictureBox1.Container == null || pictureBox2.Container == null)
   MessageBox.Show("Please make sure to enter the name and pictures!!");
            
 else//add pictures to table
 {
  try
   {
    string dbconnstr = @"C:\Users\compaq\Desktop\new\n1\ClassLibrary1\Database1.mdf;Integrated Security=True;User Instance=True";
    SqlConnection conn = new SqlConnection(dbconnstr);
    conn.Open();
    string qry = "insert into pic values (pictureBox1.Image)"; 

    //Initialize SqlCommand object for insert.
    SqlCommand sqlcom = new SqlCommand(qry,conn);
    sqlcom.BeginExecuteNonQuery();                                     
                    conn.Close();
                    conn.Dispose();
   }
  catch (Exception ee)
   {string error = ee.Message;}
}

This code doesn't insert pictures to table, even there are no errors to be found.

Please help.

Posted 29-May-11 4:19am

Member 7779792

Updated 29-May-11 4:39am

Kim Togo

v2

Add a Solution

4 solutions

Solution 4

Try

Saving and Retrieving an Image from database in C#[^]

Posted 29-May-11 6:47am

RaviRanjanKr

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)

thatraja · Accepted Answer · 2011-05-29T04:45:00

Solution 1

Try this

C# Save and Load Image from Database[^]

Posted 29-May-11 4:45am

thatraja

Comments

Kim Togo 29-May-11 12:14pm

My 5 for the link.

Espen Harlinn 29-May-11 14:35pm

Nice howto, my 5

Kim Togo · Accepted Answer · 2011-05-29T04:51:00

Solution 3

Try this Load/Unload images into/from DB table[^] and C# Save and Load Image from Database[^]

There are many articles here at CP that can help you. Try search :-)

Posted 29-May-11 4:51am

Kim Togo

Comments

yesotaso 29-May-11 10:59am

If I may add:
While writing your question Subject you'd notice a Related Entries column which also brings up related posts you are trying to ask, which can serve as implicit search :P

Kim Togo 30-May-11 2:26am

Implicit search, yes you are right :-)

OriginalGriff · Accepted Answer · 2011-05-29T04:50:00

Nope. It won't. Why? because "picturebox1.Image" is a string. Not an image.
If you have the field configured in your database, then try:

SqlConnection conn = new SqlConnection(dbconnstr);
conn.Open();
string qry = "INSERT INTO myTable (myImageField) VALUES (@PD)";
 //Initialize SqlCommand object for insert.
SqlCommand sqlcom = new SqlCommand(qry,conn);
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms,System.Drawing.Imaging.ImageFormat.Bmp);
sqlcom.Parameters.AddWithValue("@PD", ms.ToArray());
sqlcom.ExecuteNonQuery();