Who can tell me how to retrieve and display the image from SQL server database?

[JoyceKeng]

here is the way i store my image...
''

string imageUploaded = "Image";
                string savePath;
                string saveFile;
 
 
                conItem.Close();
                if (fupload.HasFile)
                {
                    savePath = Path.Combine(Request.PhysicalApplicationPath, imageUploaded);
                    saveFile = Path.Combine(savePath, itemCount   + ".jpg");
                    fupload.SaveAs(saveFile);
                }

''

Then, how i can retrieve the image from the database and display it in my form?

[PsychoCoder]

the image will be returned and needs to be read into a byte array, here's an example of retrieving an image from your table (data type should be image

public byte[] GetImageFromSQL(string imgName)
{   
    try
    {
        using (MemoryStream stream = new MemoryStream())
        {
            using (SqlConnection connection = new SqlConnection(@"YourConnectionString"))
            {
                using (SqlCommand command = new SqlCommand())
                {
                    command.CommandText = "SELECT [YourImageColumn] FROM [YourTable] WHERE [YourImageNameColumn] = @img";
                    command.CommandType = System.Data.CommandType.Text;
                    command.Parameters.AddWithValue("@img", imgName);
                    command.Connection = connection;
                    command.Connection.Open();
 
                    SqlDataReader reader = command.ExecuteReader();
                    byte[] imgBytes = null;
                    while (reader.Read())
                        imgBytes = (byte[])reader[0];
 
                    return imgBytes;
                }
            }
        }
    }
    catch(Exception ex)
    {
        Response.Write(ex.Message);
        return null;
    }
}

Then to display it

protected void Page_Load(object sender, EventArgs e)
{
    byte[] img = GetImageFromSQL("YourImageName");
    Response.ContentType = "image/jpeg";
    Response.BinaryWrite(img);
}

Hope that helps :)

[Prathap]

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

[Matsuura]

Works like magic. Thank you very much for the posting.

[PsychoCoder]

No problem, glad I could help :)