Winforms: How to upload a picture into SQL Server database using C#

Question

I want to upload images to my SQL Server database. I have two buttons , One picture box. With the browse button, I am able to select the file from disk, and it is displayed into the picturebox.

The problem is that I am not able to save the picture from picturebox into the database.

Please help me out with the code. Appreciate it.

Sameh Deabes · Accepted Answer · 2010-03-04 23:21:03Z

5

You can save the image directly from its path (you have it already).

Try this:

    byte[] img = File.ReadAllBytes("your image path");

    mySqlCommand = "INSERT INTO MyTable(Image) VALUES(@Image)";//mySqlCommand is a SqlCommand, and @Image is a parameter 
    mySqlCommand.Parameters.AddWithValue("@Image", img);
    mySqlCommand.ExecuteNonQuery();

edited Mar 4, 2010 at 23:21

answered Mar 4, 2010 at 22:53

Sameh Deabes

2,9931 gold badge26 silver badges31 bronze badges

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

Comments

Jay Riggs · Accepted Answer · 2010-03-04 19:36:44Z

2

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

Haven't tried the code myself.

answered Mar 4, 2010 at 19:36

Jay Riggs

53.7k10 gold badges146 silver badges156 bronze badges

Collectives™ on Stack Overflow

Winforms: How to upload a picture into SQL Server database using C#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related