Retrieve Image from Sql Database using c#

Ankush

10y1.3k.NET

I am developing a windows application using c#, where the user will save the image and retrieve the image. The image saving is working, but retrieving the image from database to picture box is not working. The code I have written was working 2 days back, but now its not working, Error occurs at runtime as "Parameter is not valid" @ line no.10 Here is my code below :-

string cnstd = ConfigurationManager.ConnectionStrings["My_ConnectionString"].ConnectionString;
SqlConnection cone = new SqlConnection(cnstd);
cone.Open();
string sql = "Select Pic from Emp_Details";
SqlCommand command = new SqlCommand(sql, cone);
byte[] image = (byte[])command.ExecuteScalar();
cone.Close();
MemoryStream ms = new MemoryStream(image);
ms.Seek(0, SeekOrigin.Begin);
bitmap = (Bitmap)System.Drawing.Image.FromStream(ms);
pbLogo.Image = bitmap;

Thanks in Advance !!!

3 Replies

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

Munesh Sharma10y ago
http://net-informations.com/csprj/dataset/cs-retrieve-image.htm
Vivek Bansod10y ago
Hi,

Try replacing line no 9 to -
ms.Position = 0;

Nishant Mittal10y ago

Try this

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();