如何将数据从datagridview显示到picturebox？

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.

我需要一些帮助来显示从我的datagridview到我的图片框的图像，有人可以帮助我吗？我对此很新。也到这个网站。

I've used this to save the images

我用它来保存图像

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

And the following is to show the datagridview

以下是显示datagridview

    private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
    {
        if(e.RowIndex >= 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();
        }
    }

Besides this code the picturebox isn't mentioned.

除了这个代码，没有提到图片框。

    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;
        }
    }

The image is shown in the datagridview in this column:

该图像显示在此列的datagridview中：

    afbeelding_txt.Text = row.Cells["afbeelding"].Value.ToString();

I tried :

我试过了：

    pictureBox1.Image = Image.FromFile(row.Cells["afbeelding"].Value.ToString());

And got the following error :

并得到以下错误：

An unhandled exception of type 'System.IO.FileNotFoundException' occurred in System.Drawing.dll

System.Drawing.dll中发生了未处理的“System.IO.FileNotFoundException”类型异常

Additional information: System.Byte[]

附加信息：System.Byte []

1 个解决方案

#1

If in the column there is the file path of the image, use the Image.FromFile method:

如果列中有图像的文件路径，请使用Image.FromFile方法：

pictureBox1.Image = Image.FromFile(row.Cells["afbeelding"].Value.ToString());

Else, if in the column there is directly the image value you can use the FromStream method as described here, in your case:

否则，如果在列中直接存在图像值，则可以使用此处所述的FromStream方法，在您的情况下：

var data = (Byte[])(row.Cells["afbeelding"].Value);
var stream = new MemoryStream(data);
pictureBox1.Image= Image.FromStream(stream);

#1