How to update datagridview cell value in Windows form c#

Jyoti Jodha

Don't show any error....

cmd = new SqlCommand("update cmpny_dtl set c_name=@c_name ,adrs=@adrs, c_phone=@c_phone, logo=@logo , state_id=@state_id where id=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@c_name", CmpnyName_txt.Text);
cmd.Parameters.AddWithValue("@adrs", Adrs_txt.Text);
cmd.Parameters.AddWithValue("@c_phone", CmpnyPhone_txt.Text);
cmd.Parameters.AddWithValue("@state_id", STATE_comboBox.SelectedValue);
if (pictureBox1.Image != null)
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] photo = ms.ToArray();
cmd.Parameters.AddWithValue("@logo", photo);
}
else
{
cmd.Parameters.AddWithValue("@logo", (pictureBox1.Image == null) ? (object)DBNull.Value : pictureBox1.Image).SqlDbType = SqlDbType.Image;
}
int k = cmd.ExecuteNonQuery();
cmd.ExecuteNonQuery();
con.Close();
if (k > 0)
{
MessageBox.Show(k.ToString() + "Record Inserted Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("A record with a user name already exists", CmpnyName_txt.Text);
}

2 Replies

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

Rafnas T P9y ago
Accepted answer
hi,
after looking your code I found that you are executing commands two times, please remove one
cmd = new SqlCommand("update cmpny_dtl set c_name=@c_name ,adrs=@adrs, c_phone=@c_phone, logo=@logo , state_id=@state_id where id=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@c_name", CmpnyName_txt.Text);
cmd.Parameters.AddWithValue("@adrs", Adrs_txt.Text);
cmd.Parameters.AddWithValue("@c_phone", CmpnyPhone_txt.Text);
cmd.Parameters.AddWithValue("@state_id", STATE_comboBox.SelectedValue);
if (pictureBox1.Image != null)
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] photo = ms.ToArray();
cmd.Parameters.AddWithValue("@logo", photo);
}
else
{
cmd.Parameters.AddWithValue("@logo", (pictureBox1.Image == null) ? (object)DBNull.Value : pictureBox1.Image).SqlDbType = SqlDbType.Image;
}
int k = cmd.ExecuteNonQuery(); //execute 1
cmd.ExecuteNonQuery(); //execute 2
con.Close();
if (k > 0)
{
MessageBox.Show(k.ToString() + "Record Inserted Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("A record with a user name already exists", CmpnyName_txt.Text);
}
0
Rafnas T P9y ago
hi,
I think his code is correct, what is the problem, is it inserting records check your DB.
0