Error in updating products on datagridview c#

Chidiebere Mgbemena

I got this error below while trying to update product table:

Unclosed quotation mark after the character string " where ProID=''. Incorrect syntax near "where ProID =''.

My codes:

private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
con.Open();
cmd = new SqlCommand("UPDATE tbl_Products SET ProName='" +txtProName.Text+"' where ProID='"+txtProID.Text+"' ", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Product Info Saved...");
fillGrid();
cleartext();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
con.Close();
{
}
}
private void cleartext()
{
txtProID.Text = "";
txtProName.Text = "'";
}
}
}

Please help me find the unclosed quotation

thanks

2 Replies

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

Jignesh Kumar6y ago
Accepted answer
Hi,

Please try below code, If your prodId column in Int then convert to Int
con.Open();
string prodId = txtProID.Text;
string prodName= txtProName.Text;
cmd = new SqlCommand("UPDATE tbl_Products SET ProName=@ProName where ProID=@ProID", con);
cmd.Parameters.AddWithValue("@ProName", prodName);
cmd.Parameters.AddWithValue("@ProID", prodId);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Product Info Saved...");
fillGrid();
cleartext();
Chidiebere Mgbemena6y ago
@Jignesh many thanks, the codes solved the error. Am grateful. Also kindly check my question on "Add button not adding products to gridview". Check my codes. Thanks