Winforms: How to upload an image to a SQL Server database using C #

Question

I want to upload images to a SQL Server database. I have two buttons, one picture. Using the browse button, I can select a file from disk, and it is displayed in the image window.

The problem is that I cannot save the image from the picturebox to the database.

Please help me with the code. Appreciate it.

Answer 1

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

Try the following:

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(); 

Answer 2

Sending / receiving a PictureBox image in C # to / from Microsoft SQL SERVER

I have not tried the code itself.