Inserting Image into picturebox with mouseclick in DataGridView

Question

2.33/5 (2 votes)

See more:

, +

I want to put an image on my picturebox when i click on a cell in my datagridview, but my program always stopped when i click on a single cell..

i'm having trouble too with how i could cast the "image" into "byte" data type..
(fyi, i use "varbinary(max)" on my SQL server, and i want to convert it to "byte")
can someone help me?

C#

private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
{
    DataGridViewRow row;
    row = dataGridView1.CurrentRow;
    Byte[] picture = (Byte[]) row.Cells[5].Value;  //my program always stopped here
    MemoryStream ms = new MemoryStream(picture);
    pictureBox1.Image = Image.FromStream(ms);
}

Posted 3-Jun-13 23:15pm

Sam Oryza Reyno

Updated 24-Jan-18 20:39pm

v3

Add a Solution

Comments

Sunasara Imdadhusen 4-Jun-13 5:56am

What is your error?

Sam Oryza Reyno 4-Jun-13 21:16pm

Byte[] picture = (Byte[]) row.Cells[5].Value;

when i run it, and double click on my GridView, my program stopped on that line.

dinesh 2010 26-Sep-13 4:28am

ok

BulletVictim 4-Jun-13 6:35am

You could try to use the CellContentClick Event on the DataGridView.
If it needs to be on a specific column you need to use something like this.
if(e.columnIndex == i)
{
//your code
}
I might be missing exactly what you are asking

Sam Oryza Reyno 4-Jun-13 21:27pm

i have update my question, in case of ambiguity.. are you still confused?
(sorry if my english make you confused)

[no name] 4-Jun-13 21:47pm

Okay.... step back a second. Is the contents of the 6th column of your grid a byte array? Is it not already an image? Knowing what the error is that you are getting would help a bit. What does SQL server have to do with anything?

Sam Oryza Reyno 4-Jun-13 22:00pm

6th column is declared as Varbinary(max) (i read some post about how to insert image into database , and they said i must use varbinary datatype)
when i insert an image, the cell wrote binary data

Error message:
Index was out of range. Must be non-negative and less than the size of the collection.

SQL Server 2008 R2 ..

2 solutions

Solution 2

//On Double click on the gridview then textbox and picturebox get value and images from the gridview. my working code is as follows

public Image GetDataToImage(byte[] pData)
{
try
{
ImageConverter imgConverter = new ImageConverter();
return imgConverter.ConvertFrom(pData) as Image;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
private void dataGridView1_CellDoubleClick(object sender, EventArgs e)
{
if (dataGridView1.SelectedCells.Count > 0)
{
int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;

DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];

textBox1.Text = Convert.ToString(selectedRow.Cells[0].Value);
textBox2.Text = Convert.ToString(selectedRow.Cells[1].Value);
picture_photo.Image = GetDataToImage((byte[])(selectedRow.Cells[2].Value));
}

}

Posted 24-Jan-18 20:39pm

Member 13144815

Updated 24-Jan-18 20:40pm

Comments

CHill60 25-Jan-18 4:40am

Question has an accepted solution from over 4 years ago. You have added nothing new to the thread

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sam Oryza Reyno · Accepted Answer · 2013-06-12T17:34:00

I have solve it,,

C#

public Image GetDataToImage(byte[] pData)
        {
            try
            {
                ImageConverter imgConverter = new ImageConverter();
                return imgConverter.ConvertFrom(pData) as Image;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return null;
            }
        }
        //Event Handler CellClick
        private void dgv_ProductData_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            pictureBox1.Image = GetDataToImage((byte[])(dgv_ProductData.CurrentRow.Cells[5].Value));
            pictureBox2.Image = GetDataToImage((byte[])(dgv_ProductData.CurrentRow.Cells[6].Value));
        }