Parameter is invalid exception when retrieving image from database to picturebox

Question

I am retrieving the image from a SQL Server database into a PictureBox in a C# Windows application. The image is a form which I don't know.

I tried this code but it throws a "parameter invalid" exception, and I also go through many answer related to this but didn't work any.

My code:

  SqlConnection sql_con  = new SqlConnection();
  sql_con.ConnectionString = @"Server=abc-14;Database=Abcstudent;User Id=sa; Password=abc;";

  if (sql_con.State == ConnectionState.Closed) 
      sql_con.Open();

  try
  {
      string query = "Select grno, PICStudent from GENREG where grno = 1";                        
      SqlCommand sql_cmd = new SqlCommand(query, sql_con);

      sql_cmd.ExecuteNonQuery();

      SqlDataAdapter sql_adp = new SqlDataAdapter(sql_cmd);               
      sql_adp.Fill(sql_ds);    
  }
  catch(Exception ex)
  {
  }

  // code for retrieving image to picture box 
  try
  {
       DataRow myRow;
       byte[] MyData = new byte[0];
       myRow = sql_ds.Tables[0].Rows[0];

       MyData = (byte[])myRow["PICStudent"];
       MemoryStream stream = new MemoryStream(MyData);
       pictureBox1.Image = Image.FromStream(stream);  // getting error here
  }
  catch()
  {
  }

Database Image

In which line of code you are getting the error?

Chetan
– Chetan

2017-01-07 05:14:43 +00:00
Commented Jan 7, 2017 at 5:14 — Chetan
– Chetan, Commented Jan 7, 2017 at 5:14
I update question with line of error in comments

Mamta
– Mamta

2017-01-07 06:21:22 +00:00
Commented Jan 7, 2017 at 6:21 — Mamta
– Mamta, Commented Jan 7, 2017 at 6:21

Vinoth Raj · Accepted Answer · 2017-01-07 05:58:41Z

1

 SqlConnection con = new SqlConnection("Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Integrated Security=SSPI;");
        con.Open();
        SqlCommand cmd = new SqlCommand("select picbox from picture1 where id=1", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count > 0)
        {
            MemoryStream ms = new MemoryStream((byte[])ds.Tables[0].Rows[0]["picbox"]);
            pictureBox1.Image = new Bitmap(ms);
        }

answered Jan 7, 2017 at 5:58

Vinoth Raj

3061 silver badge14 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mamta Over a year ago

thank you @vinoth but same error : parameter invalid

Vinoth Raj Over a year ago

in which line@Mamta

Mamta Over a year ago

pictureBox1.Image = new Bitmap(ms) // Parameter Invalid

Mamta Over a year ago

I didn't know the type of image in database like jpg , png etc but datatypes is Image in table

Chetan · Accepted Answer · 2017-01-07 08:15:42Z

1

Insead of using Image.FromStream, did you try using ImageConverter?

Sample come of using ImageConverter looks as following.

byte[] filedata = (byte[])myRow["PICStudent"];
ImageConverter imageConverter = new System.Drawing.ImageConverter();
System.Drawing.Image image = imageConverter.ConvertFrom(fileData) as System.Drawing.Image;
image.Save(imageFullPath, System.Drawing.Imaging.ImageFormat.Jpeg);

This should resolve your issue.

Thanks and regards, Chetan Ranpariya

answered Jan 7, 2017 at 8:15

Chetan

6,9314 gold badges24 silver badges33 bronze badges

1 Comment

Mamta Over a year ago

thank you for answer @Chetan but getting error "Parameter Invalid " in imageConverter.ConvertFrom(fileData) as System.Drawing.Image ;

Collectives™ on Stack Overflow

Parameter is invalid exception when retrieving image from database to picturebox

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related