Retrieve Images from sql server database

c#, image, sql-server-2005

Solution

this is an example from Sql Server

        connection.Open();
        SqlCommand command1 = new SqlCommand("select imgfile from myimages where imgname=@param", connection);
        SqlParameter myparam = command1.Parameters.Add("@param", SqlDbType.NVarChar, 30);
        myparam.Value = txtimgname.Text;
        byte[] img = (byte[])command1.ExecuteScalar();
        MemoryStream str = new MemoryStream();
        str.Write(img, 0, img.Length);
        Bitmap bit = new Bitmap(str);
        connection.Close();

look here http://www.akadia.com/services/dotnet_read_write_blob.html

Problem

i am storing images to the database. How to retrieve all the images from the database. Eg: select images from imagetable Problem: Data Logic: ``` while (dr.Read()) { ///Check for null if (!dr.IsDBNull(0)) { try { ///Converting the image into bitmap byte[] photo = (byte[])dr[0]; ms = new MemoryStream(photo); Bitmap bm = new Bitmap(ms); bmp[i] = bm; ms.Close(); } catch (Exception ex) { } } ``` ASpx.CS page: ``` Bitmap[] bm= photos.GetImage(); for (int i = 0; i < bm.Length; i++) { MemoryStream ms = new MemoryStream(); **bm[i].Save(ms, ImageFormat.Jpeg);**(Error : A generic error occurred in GDI+.) htmlCode.Append("<li><img ImageUrl=\\\""); htmlCode.Append(**ms.GetBuffer()**); htmlCode.Append("\" alt=\"\" width=\"100\" height=\"100\"></li>"); } ``` Image not getting displayed Geetha

Original source