Problem with storing images in sql server

Question

I am trying to store images in sql server with data type image now the problem is getting stored into two rows, i am using FileUpload control to upload image, my code is as follows

byte[] imagedata = ImageUpload.FileBytes;
con.Open();
SqlCommand insertImageCmd = new SqlCommand("insert into Images(ImageName,Image) values (@name, @image)", con);
insertImageCmd.Parameters.AddWithValue("@name", imageNameTextBox.Text);
insertImageCmd.Parameters.AddWithValue("@image", imagedata );
insertImageCmd.ExecuteNonQuery();
con.Close();

is this the correct way store images? please help!

Andy · Accepted Answer · 2011-06-13 17:02:20Z

2

If its getting stored as two rows, using the code you've posted, I think that you might somehow be double posting your page.

answered Jun 13, 2011 at 17:02

Andy

8,5726 gold badges43 silver badges79 bronze badges

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

Comments

Jean-Philippe Leclerc · Accepted Answer · 2011-06-13 17:00:31Z

1

Here is what I would do:

byte[] image = File.ReadAllBytes(path)

Then you can insert it in your database.

tip:

When you use a SqlConnection, surround it with the using keyword:

using (var connection = new SqlConnection(connectionString))
{

}

edited Jun 13, 2011 at 17:00

answered Jun 13, 2011 at 16:54

Jean-Philippe Leclerc

6,8055 gold badges45 silver badges66 bronze badges

Collectives™ on Stack Overflow

Problem with storing images in sql server

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