Show image in picture box clicked from datagridview

Guest User

8y11.3kVisual Basic .NET

I want to show image in picture box from database clicked in datagridview.

Here is my code:

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
txtEmpID.Text = row.Cells[0].Value.ToString();
txtDeleteAndSearch.Text = row.Cells[0].Value.ToString();
txtEmpName.Text = row.Cells[1].Value.ToString();
dateTimePicker1.Text = row.Cells[2].Value.ToString();
if (row.Cells[3].Value.ToString() == "Male")
{
radioMale.Checked = true;
}
else
{
radioFemale.Checked = true;
}
txtEmail.Text = row.Cells[4].Value.ToString();
txtMSalary.Text = row.Cells[5].Value.ToString();
txtAddr.Text = row.Cells[6].Value.ToString();
txtMob.Text = row.Cells[8].Value.ToString();
pictureBoxEmpPic.Image =row.Cells[9].Value as Image;
txtPass.Text = row.Cells[10].Value.ToString();
txtPassConf.Text = txtPass.Text;
}
}

every thing is OK, but image not showing in picturebox,

(pictureBoxEmpPic.Image =row.Cells[9].Value as Image; is not working)

Anybody help me?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User8y ago
Hi,
Thanx a lot,
I have solved it by try catch block.
Here is my code and it is working very nicely:
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.dataGridView1.Rows[e.RowIndex];
try
{
txtEmpId.Text = row.Cells[0].Value.ToString();
txtEmpName.Text = row.Cells[1].Value.ToString();
dateTimePicker1.Text = row.Cells[2].Value.ToString();
if (row.Cells[3].Value.ToString() == "Male")
{
rdoMale.Checked = true;
}
else
{
rdoFemale.Checked = true;
}
txtBSalary.Text = row.Cells[4].Value.ToString();
txtMob.Text = row.Cells[5].Value.ToString();
txtEmail.Text = row.Cells[6].Value.ToString();
txtAddr.Text = row.Cells[7].Value.ToString();
if (row.Cells[8].Value != null)
{
Byte[] data = new Byte[0];
data = (Byte[])row.Cells[8].Value;
MemoryStream mem = new MemoryStream(data);
pictureBox1.Image = Image.FromStream(mem);
}
else
{
return;
}
}
catch (Exception)
{
pictureBox1.Image = null;
MessageBox.Show("No image in database or you have selected blank row in grid!!!");
return;
}
}
}
Guest User8y ago
Sorry,
Same error,
I have just copy paste and close by your missing ')' after [9].

txtMob.Text = row.Cells[8].Value.ToString();
if (row.Cells[9].Value != null)
{
Byte[] data = new Byte[0];
data = (Byte[])(row.Cells[9]).Value;
MemoryStream mem = new MemoryStream(data);
pictureBoxEmpPic.Image = Image.FromStream(mem);
}
else
{
pictureBoxEmpPic.Image = null;
}

//pictureBoxEmpPic.Image =row.Cells[9].Value as Image;

txtPass.Text = row.Cells[10].Value.ToString();
Amit Gupta8y ago
Yeah, thats what I stated in my earlier post to check for the nullable values
Update:
if(row.Cells[9] !=null)
{
Byte[] data = new Byte[0];
data = (Byte[])(row.Cells[9].Value;
MemoryStream mem = new MemoryStream(data);
pictureBoxEmpPic.Image= Image.FromStream(mem);
}
else
pictureBoxEmpPic.Image=null;
mark the answer as accepted, if your problem is resolved :)
Good Luck
Guest User8y ago
Hi Amit,
Thanx for your nice suggesstion. It is working nicely.
But showing below error:

Unable to cast object of type 'System.DBNull' to type 'System.Byte[]'.

for no data or image (empty /null / no image in column) in datagridview/database .
Amit Gupta8y ago
Then it was in the form of bytes[], you need to load image from MemoryStream
Byte[] data = new Byte[0];
data = (Byte[])(row.Cells[9].Value;
MemoryStream mem = new MemoryStream(data);
pictureBoxEmpPic.Image= Image.FromStream(mem);
Change your naming controls accordingly
Guest User8y ago
It is not filepath,
It is image data from database.
sql column name is 'Emp_Photo'
and datatype is 'image'
Amit Gupta8y ago
It won't work at all, picturebox.image requires to take image from file or a stream

What is the value contains in cell 9? If it is a filepath then use the below snippet
pictureBoxEmpPic.Image =Image.FromFile(row.Cells[9].Value.ToString());

// Do check the null value of cell 9 before converting ToString()