How to insert\retrieve image in SQL Server database?

Do Not use the Data Type image because the Image will be converted into binary and will be saved so better you save the path

private void SaveImage()
        {
            string path = Application.StartupPath+"\\ProfessorImage\\";
            string path2 = txtBrowse.Text;

            try
            {
                if (Directory.Exists(path))
                {
                    string filename = Path.GetFileName(path2);
                    path = path + filename;
                    File.Copy(path2, path, true);

                    toolStripStatusAll.Text = "Succesfully Added";
                }
                else
                {

                    Directory.CreateDirectory(path);
                    string fileName = Path.GetFileName(path2);
                    path = path + fileName;
                    File.Copy(path2, path);
                    toolStripStatusAll.Text = "Succesfully Added";
                }           
                }
            catch (Exception ex)
            {

                toolStripStatusAll.Text = "Failed To Copy"+ex.ToString();
            }
            txtBrowse.Text = "";

            
        }

Save the Image in a directory and Save the path in the DB

In many many many cases you have to save it as image not only the path.. In case users may change\delete images and you depend on them.

Ya u can protect them using hiding techniques right,because converting to binary can loose or corrupt images na?

1- The work and the privilage you need to operate on file system is much harder with lots of exceptions.
2- In many cases there no images on HDD, all manipulated from database directly.

Conclusion... both solutions right and correct.

Solved

Imports System.Data.SqlClient
Imports System.Data
Imports System.IO
 
 Public Class Form1
    Dim str As String = "Data Source=NET3\SQLEXPRESS;Initial Catalog=RestPos;Persist Security Info=True;User ID=sa;Password=password"
    Dim con As New SqlClient.SqlConnection

    'To open an image from computer
    '-------------------------------
    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        OpenFileDialog1.Title = "Please select a file"
        OpenFileDialog1.InitialDirectory = "c:temp"
        OpenFileDialog1.ShowDialog()
        TextBox2.Text = OpenFileDialog1.FileName.ToString  '--->To Show the file path in textbox2
        PictureBox1.ImageLocation = TextBox2.Text  '--->To show selected image in picturebox
    End sub
   
   'To insert selected image into database
   'The datatype of the column in table to store image should be <image>  
   '--------------------------------------------------------------------
    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        con.ConnectionString = str
        Dim ms As New IO.MemoryStream()
        PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)
        Dim arrimage() As Byte = ms.GetBuffer
        Dim cmd As New SqlCommand("insert into image (Emp_Image)values(@picture)", con)
        cmd.Parameters.Add(New SqlParameter("@Picture", SqlDbType.Image)).Value = arrimage
        con.Open()
        cmd.ExecuteNonQuery()
        con.Close()
    End Sub
    
    'We have successfully inserted the image into database.
    'Now we want to Retrieve the image from database.
    '-------------------------------------------------
    Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
        Dim stream As New IO.MemoryStream()
        con.Open()
        Dim command As New SqlCommand("select Emp_Image from Image where Emp_Id='" +  TextBox3. Text + "'", con)  '--->You can give Emp_id instead of Textbox value.
        Dim image As Byte() = DirectCast(command.ExecuteScalar(), Byte())
        stream.Write(image, 0, image.Length)
        con.Close()
        Dim bitmap As New Bitmap(stream)
        PictureBox2.Image = bitmap '--->I have used another picturebox to display image from database.
    End Sub
    'Thats all, You can place a linklabel below the picturebox if you to change photo and update it in database.

Regards,
Prathap

perfect. this is my code:

Private Sub SaveImagen(ByVal FileName As String, ByVal NombreArticuloCB As String)

    Try
        'abro la conexión
        Dim c As New System.Data.SqlClient.SqlConnection
        c.ConnectionString = TextBox1.Text
        c.Open()
        'MsgBox("ok CONEXION jj")


        'cargo la imagen en un array de bits
        Dim Fs As System.IO.FileStream = New System.IO.FileStream(FileName, System.IO.FileMode.Open)
        Dim imageAsBytes(Fs.Length) As Byte
        Fs.Read(imageAsBytes, 0, imageAsBytes.Length)
        Fs.Close()


        'preparo la sql a ejecutar
        Dim cmd As New System.Data.SqlClient.SqlCommand("insert into ArticuloImagenBlob (Cod_ArticuloImg, Imagen)values('" & NombreArticuloCB & "',@picture)", c)
        cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Picture", System.Data.SqlDbType.Image)).Value = imageAsBytes
        cmd.ExecuteNonQuery()


        MsgBox("Imagen almacenada")



    Catch ex As Exception
        MsgBox("Error al guardar en db." & vbCrLf & ex.ToString)

    End Try




End Sub