retrieve images from database

You can retrieve the images along with remaining data as given below
using (SqlConnection conn = ...)
{
    conn.Open();

    using (SqlCommand cmd = new SqlCommand("SELECT Picture FROM WHERE ...", conn)
    using (SqlDataReader reader = cmd.ExecuteReader())
    {
        if (reader.Read())
        {
            byte[] picData= reader["Picture"] as byte[] ?? null;

            if (picData!= null)
            {
                using (MemoryStream ms = new MemoryStream(picData))
                {
                    // Load the image from the memory stream. How you do it depends
                    // on whether you're using Windows Forms or WPF.
                    // For Windows Forms you could write:
                    System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(ms);
                }
            }
        }
    }
}

If you have any doubts refer this example http://www.aspsnippets.com/Articles/Retrieve-images-using-a-file-path-stored-in-database-in-ASPNet.aspx

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma12y ago
go on this link
http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html
Hemant Kumar12y ago
You can retrieve the images along with remaining data as given below
using (SqlConnection conn = ...)
{
    conn.Open();

    using (SqlCommand cmd = new SqlCommand("SELECT Picture FROM WHERE ...", conn)
    using (SqlDataReader reader = cmd.ExecuteReader())
    {
        if (reader.Read())
        {
            byte[] picData= reader["Picture"] as byte[] ?? null;

            if (picData!= null)
            {
                using (MemoryStream ms = new MemoryStream(picData))
                {
                    // Load the image from the memory stream. How you do it depends
                    // on whether you're using Windows Forms or WPF.
                    // For Windows Forms you could write:
                    System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(ms);
                }
            }
        }
    }
}

If you have any doubts refer this example http://www.aspsnippets.com/Articles/Retrieve-images-using-a-file-path-stored-in-database-in-ASPNet.aspx