How to retrieve image from database to picturebox in C#

Question

Hi people! How to retrieve image from database to picturebox in C# ... I have already the codes but the problem is it always says 'Parameter is not valid' im using Visual Studio platform i already attached the codes for retrieving the image but still error .. thank you very much

Sundaram Subramanian · Answer

Think, You are passing a Parameter which is not related to the Table or Stored Procedure. Check your Data Layer Code. Check the Parameters passed.

shubham chawke · Answer

First retrieve image from database using Query public MemoryStream memorystream; public byte[] View_Sign(string filename) { string QueryViewSign = "Select image from " + SqlDatabaseName + ".." + mTableNameSignMaster + " where filename='" + filename + "' order by edate desc"; con = new SqlConnection(constr); con.Open(); SqlCommand cmd = new SqlCommand(QueryViewSign, con); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { Signature = ((byte[])dr[0]); } if (Signature != null) { memorystream = new MemoryStream(Signature); } return Signature; } then after retrieve file from database private void btn_Click(object sender, EventArgs e) { try { cn.View_Sign(cn.getsign); if (cn.Signature == null) { cn.Signature = null; } else { pictureBox1.Image = Image.FromStream(cn.memorystream); } } catch (Exception ex) { MessageBox.Show(ex.Message + Environment.NewLine + ex.StackTrace); } }

Sundaram Subramanian · Answer

Follow this link https://www.aspsnippets.com/Articles/Save-and-Retrieve-BLOB-Images-from-MySql-Database-in-ASPNet-C-and-VBNet.aspx You can convert the BLOB to Normal Displaying Image

Prince Cabanducos · Answer

Sir im new with the C# language im using BLOB data type this is the result when i successfully saved the image from picturebox

Gokhul Varman · Answer

refeer the link for more explanation:https://www.codeproject.com/Questions/499613/C-plushowplustoplusretrieveplusimageplusfromplus

How to retrieve image from database to picturebox in C#

Answers (5)