title: How to display image from datagridview to picturebox?
body: <p>I need some help to display images from my datagridview to my picturebox, can someone please help me? I'm very new to this. To this site as well.</p>
  
  <p>I've used this to save the images</p>
  
  <pre><code>    private void button1_Click(object sender, EventArgs e)
      {
          byte[] imageBt = null;
          FileStream fstream = new FileStream(this.afbeelding_txt.Text, FileMode.Open, FileAccess.Read);
          BinaryReader br = new BinaryReader(fstream);
          imageBt = br.ReadBytes((int)fstream.Length);
  
          string constring = "datasource=localhost;port=3306;username=username;password=password";
          string Query = "INSERT INTO project.auto (kenteken, merk, type, kleur, deuren, prijscategorie, afbeelding) VALUES('" + this.kenteken_txt.Text + "','" + this.merk_txt.Text + "','" + this.type_txt.Text + "','" + this.kleur_txt.Text + "','" + this.deuren_txt.Text + "','" + this.prijscategorie_txt.Text + "',@IMG) ;";
          MySqlConnection conDataBase = new MySqlConnection(constring);
          MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
          MySqlDataReader myReader;
          try
          {
              conDataBase.Open();
  
              cmdDataBase.Parameters.Add(new MySqlParameter("@IMG", imageBt));
  
              myReader = cmdDataBase.ExecuteReader();
              MessageBox.Show("Opgeslagen");
              while (myReader.Read())
              {
  
              }
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          load_table();
      }
  </code></pre>
  
  <p>And the following is to show the datagridview</p>
  
  <pre><code>    private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
      {
          if(e.RowIndex &gt;= 0)
          {
              DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
  
              kenteken_txt.Text = row.Cells["kenteken"].Value.ToString();
              merk_txt.Text = row.Cells["merk"].Value.ToString();
              type_txt.Text = row.Cells["type"].Value.ToString();
              kleur_txt.Text = row.Cells["kleur"].Value.ToString();
              deuren_txt.Text = row.Cells["deuren"].Value.ToString();
              prijscategorie_txt.Text = row.Cells["prijscategorie"].Value.ToString();
              afbeelding_txt.Text = row.Cells["afbeelding"].Value.ToString();
          }
      }
  </code></pre>
  
  <p>Besides this code the picturebox isn't mentioned.</p>
  
  <pre><code>    private void button6_Click(object sender, EventArgs e)
      {
          OpenFileDialog dlg = new OpenFileDialog();
          dlg.Filter = "PNG Files(*.png)|*.png|JPG Files(*.jpg)|*.jpg|All Files(*.*)|*.*";
          dlg.Title = "Selecteer auto afbeelding.";
          if (dlg.ShowDialog() == DialogResult.OK)
          {
              string picPath = dlg.FileName.ToString();
              afbeelding_txt.Text = picPath;
              pictureBox1.ImageLocation = picPath;
          }
      }
  </code></pre>
  
  <p>The image is shown in the datagridview in this column:</p>
  
  <pre><code>    afbeelding_txt.Text = row.Cells["afbeelding"].Value.ToString();
  </code></pre>
  
  <p>I tried :</p>
  
  <pre><code>    pictureBox1.Image = Image.FromFile(row.Cells["afbeelding"].Value.ToString());
  </code></pre>
  
  <p>And got the following error :</p>
  
  <p>An unhandled exception of type 'System.IO.FileNotFoundException' occurred in System.Drawing.dll</p>
  
  <p>Additional information: System.Byte[]</p>