datagridview to picturebox

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 !!!");

}

2 Replies

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

Tanmoy Singha13y ago
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 Singh14y ago
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....