Upload image to SQL table

Question

Hi, I wish to upload an image to an sql table.

So far I have used an open file dialogue and a picturebox where the user can browse for images and preview it. The code I have used for this is ;

//open the BtnBrowse dialog

OpenFileDialog BrowseDialogue = new OpenFileDialog();

//Select filters on which file types to upload

BrowseDialogue.Filter = "Images Files (*.jpg; *.jpeg; *.gif; *.bmp; *.png:)|*.jpg; *.jpeg; *.gif; *.bmp; *png;";

if (BrowseDialogue.ShowDialog() == DialogResult.OK)

{

//Preview the image in a picturebox

pictureBox1.Image = new Bitmap(BrowseDialogue.FileName);

//Display image path in textbox

textBox1.Text = BrowseDialogue.FileName;

The above code all works fine but I now want to have an upload button where the image in the picturebox is uploaded to the database, I understand that there are two ways of doing this via file stream or memory stream.

The table name I wish to upload to is contents and the field name is image.

Could someone provide me with some information of how to go about this?

Many thanks for your help.

Sakthis · Answer

yes..

Lynn Emery · Answer

Hi, thank you for your reply. For the code which is related to the SQL connection, i am a little confused. Do I need to define the security etc? sqlcon.ConnectionString = "Data Source=sakthi\sqlexpress; Initial Catalog=LoginDetails; Integrated Security=True"; Could please explain further? I have a data source called ProductImages and are using SQL server 2003. Thank you once again.

Sakthis · Answer

Hi Open an Image : private void button1_Click(object sender, EventArgs e) { OpenFileDialog openFD = new OpenFileDialog(); openFD.Filter = "All Files | *.jpg;"; DialogResult dr = openFD.ShowDialog(); pictureBox1.Image = Image.FromFile(openFD.FileName); pictureBox1.LoadAsync(openFD.FileName); } Button Save : MemoryStream ms = new MemoryStream(); byte[] pic = new byte[ms.Length]; ms.Position = 0; ms.Read(pic, 0, pic.Length); SqlConnection sqlcon = new SqlConnection(); SqlCommand sqlcmd = new SqlCommand(); sqlcon.ConnectionString = "Data Source=sakthi\sqlexpress; Initial Catalog=LoginDetails; Integrated Security=True"; sqlcon.Open(); sqlcmd.Connection = sqlcon; sqlcmd.CommandText = "insert into emp(empcode, name, image) values (@empcode, @name, @image)"; sqlcmd.Parameters.AddWithValue("@empcode", txtEmpCode.Text); sqlcmd.Parameters.AddWithValue("@name", txtName.Text); sqlcmd.Parameters.AddWithValue("@image", pic); sqlcmd.ExecuteNonQuery(); sqlcon.Close(); MessageBox.Show("Saved"); Close();

Upload image to SQL table

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)