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

c#, database, sql-server, winforms

Solution

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

Problem

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.

Original source