Adding an image to SQL database using Visual C#

Question

I am working on a visual C# program for image processing.I am trying to add image to sql database using Visual C# (Windows forms) and ADO.NET.

I have converted the image to binary form with filestream method but the image bytes are not getting saved in database. At the database image column, it says < Binary data > and no data is getting saved!

I have tried many methods for inserting( with and without stored procedures..etc) but always getting the same thing at database.

private void button6_Click(object sender, EventArgs e)
{
   try
   {
      byte[] image = null;
      pictureBox2.ImageLocation = textBox1.Text;
      string filepath = textBox1.Text;
      FileStream fs = new FileStream(filepath, FileMode.Open, FileAccess.Read);
      BinaryReader br = new BinaryReader(fs);
      image = br.ReadBytes((int)fs.Length);
      string sql = " INSERT INTO ImageTable(Image) VALUES(@Imgg)";
      if (con.State != ConnectionState.Open)
         con.Open();
      SqlCommand cmd = new SqlCommand(sql, con);
      cmd.Parameters.Add(new SqlParameter("@Imgg", image));
      int x= cmd.ExecuteNonQuery();
      con.Close();
      MessageBox.Show(x.ToString() + "Image saved");
   }
}

I am not getting error in code. the image got converted and entry is done in database but says < Binary Data > at the sql database.

It's not clear in what way this isn't working. If there's binary data stored in the database, isn't that successful? Or do you mean it's storing the literal string "<Binary data>"? Show the code you're using to store the data, and indicate where you notice there's a problem. — David
– David, Commented Nov 6, 2013 at 16:37
Show code. If you show us both how you convert the image to bytes and how you're trying to insert it, there's a bigger chance we can find the problem. — Tobberoth
– Tobberoth, Commented Nov 6, 2013 at 16:38
Post your code, we could guess all day as to why it's not working (but we won't). Also, do you need to save the image to the database? Or can you simply write the location of the image instead? — sab669
– sab669, Commented Nov 6, 2013 at 16:40
yes..only the literal string is there. Its empty when i have tried to convert it back to image using memorystream. — Jeena
– Jeena, Commented Nov 6, 2013 at 16:41

Jeena · Accepted Answer · 2013-11-08 07:33:06Z

5

The selected file stream should be converted to byte array.

        FileStream FS = new FileStream(filepath, FileMode.Open, FileAccess.Read); //create a file stream object associate to user selected file 
        byte[] img = new byte[FS.Length]; //create a byte array with size of user select file stream length
        FS.Read(img, 0, Convert.ToInt32(FS.Length));//read user selected file stream in to byte array

Now this works fine. Database still shows < Binary data > but it could be converted back to image using memorystream method.

Thanks to all...

answered Nov 8, 2013 at 7:33

Jeena

1011 gold badge1 silver badge7 bronze badges

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

Comments

majimenezp · Accepted Answer · 2013-11-06 16:46:22Z

2

Try with something like this:

byte[] fileBytes=System.IO.File.ReadAllBytes("path to file");
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand("insert  into table(blob,filename) values (@blob,@name)");
command.Parameters.AddWithValue("blob", fileBytes);
command.Parameters.AddWithValue("name", "filename");
command.ExecuteNonQuery();

answered Nov 6, 2013 at 16:46

majimenezp

3122 silver badges3 bronze badges

Comments

GarethD · Accepted Answer · 2013-11-06 18:47:24Z

1

Assuming that you are using VARBINARY to store your image (which you should be), you may need to make your SqlParameter more strongly typed:

So instead of

cmd.Parameters.Add(new SqlParameter("@Imgg", image));

You would use:

cmd.Parameters.Add("@Imgg", SqlDbType.VarBinary).Value = (SqlBinary)image;

You could also use System.IO.File.ReadAllBytes to shorten your code turning a file path into a byte array.

answered Nov 6, 2013 at 18:47

GarethD

70k11 gold badges90 silver badges130 bronze badges

Comments

slavoo · Accepted Answer · 2014-01-28 09:53:53Z

0

Execute this stored procedure:

create procedure prcInsert
(
   @txtEmpNo varchar(6),
   @photo image
)
as
begin
   insert into Emp values(@txtEmpNo, @photo)
end

Table Emp:

create table Emp
(
   [txtEmpNo] [varchar](6) NOT NULL,
   imPhoto image
)

edited Jan 28, 2014 at 9:53

slavoo

6,11464 gold badges40 silver badges41 bronze badges

answered Dec 4, 2013 at 10:00

user2136053

Collectives™ on Stack Overflow

Adding an image to SQL database using Visual C#

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related