datagridview to picturebox

Question

Dear friends, how to display image from datagridview to picturebox on cell double click event of datagridview. anybody has solution for this, than please post it as soon as possible thank you prasanna

Tanmoy Singha · Answer

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex > -1 && e.RowIndex > -1) if (dataGridView1.Columns[e.ColumnIndex].HeaderText == "EDIT") { if (e.RowIndex > -1) { panelDOCTor.Enabled = true; button_AddNew.Enabled = false; button_save.Enabled = false; panelUG.Enabled = true; Doctor.mode = "EDIT"; if (textTohave.Text == "IN") { radioButtonOut.Checked = true; } else if (textTohave.Text == "OUT") { radioButtonIn.Checked = true; } labelDOCID.Text = Convert.ToString(dataGridView1[0, e.RowIndex].Value); textselectDepart.Text = Convert.ToString(dataGridView1[1, e.RowIndex].Value); textTohave.Text = Convert.ToString(dataGridView1[2, e.RowIndex].Value); textDocName.Text = Convert.ToString(dataGridView1[3, e.RowIndex].Value); textQualification.Text = Convert.ToString(dataGridView1[4, e.RowIndex].Value); textDesignation.Text = Convert.ToString(dataGridView1[5, e.RowIndex].Value); textAddress.Text = Convert.ToString(dataGridView1[6, e.RowIndex].Value); textPhoneLand.Text = Convert.ToString(dataGridView1[7, e.RowIndex].Value); textMobile.Text = Convert.ToString(dataGridView1[8, e.RowIndex].Value); textEmailId.Text = Convert.ToString(dataGridView1[9, e.RowIndex].Value); textSpecialAcheivement.Text = Convert.ToString(dataGridView1[10, e.RowIndex].Value); textPreviousHistory.Text = Convert.ToString(dataGridView1[11, e.RowIndex].Value); numericUpDownF1.Text = Convert.ToString(dataGridView1[13, e.RowIndex].Value); numericUpDownF2.Text = Convert.ToString(dataGridView1[14, e.RowIndex].Value); numericUpDownT1.Text = Convert.ToString(dataGridView1[15, e.RowIndex].Value); numericUpDownT2.Text = Convert.ToString(dataGridView1[16, e.RowIndex].Value); label21.Text = "EDIT"; if (label21.Text == "EDIT") { if (labelDOCID.Text != "0") { Common c = new Common(); SqlConnection con = new SqlConnection(c.GetConString()); cmd = new SqlCommand("Select DOCTOR_Table.photo from DOCTOR_Table where DOCTOR_Table.DocID='" + labelDOCID.Text.Trim() + "'", con); con.Open(); DataSet ds = new DataSet(); da = new SqlDataAdapter(cmd); byte[] MyData = new byte[0]; da.Fill(ds, "s"); DataRow myRow; myRow = ds.Tables["s"].Rows[0]; MyData = (byte[])myRow["photo"]; MemoryStream stream = new MemoryStream(MyData); pictureBox1.Image = Image.FromStream(stream); con.Close(); } } else { MessageBox.Show("SYSTEM ERROR!!"); } } else { MessageBox.Show("Please Select any Record for Edit...", "Records"); } } else if (dataGridView1.Columns[e.ColumnIndex].HeaderText == "DELETE") { if (!(MessageBox.Show("Record Deleted Warning.", "Are You Sure Want To Delete The Record!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)) return; if (id > 0) { Common c = new Common(); SqlConnection con = new SqlConnection(c.GetConString()); SqlCommand cmd = new SqlCommand("delete from DOCTOR_Table Where DocID=" + id + " ", con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); clearall(); databind(); MessageBox.Show("DATA DELETE IN DATABASE", "DATABASE MASSAGE", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Error !!!"); } } }

Manish Singh · Answer

hello.......... Prasanna shah Please see the url : http://www.dreamincode.net/forums/topic/32351-obtaining-field-value-from-datagrid-on-double-click/ I hope help to you....

datagridview to picturebox

Answers (2)