update query executed but record not updated

Atul Rokade

Hi all,

Iam doing one task where i want to executed update query i have table name is Medicine_Available_Detail here iam storing total medicine available column name is Availability,I have one datagridview where im putting Quantity of that Medicine after user enter Quantity of particular medicine then it table update as Availability-Quantity for that medicine i written a code but its executed but record not updated

private void dataGridView1_RowLeave(object sender, DataGridViewCellEventArgs e)

{

int quantity = Convert.ToInt16(dataGridView1.Rows[e.RowIndex].Cells["Quantity"].Value);

cmd = new OleDbCommand("update Medicine_Available_Detail set [Availability]=[Availability]-@Quantity where [Medicine_Name]=@Medicine_Name", con);

cmd.Parameters.AddWithValue("@Quantity", quantity);

cmd.Parameters.AddWithValue("@Medicine_Name", medicinename);

con.Open();

int n = cmd.ExecuteNonQuery();

con.Close();

}

4 Replies

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

Bryian Tan9y ago
Have you try print out the query and run it on the SQL server to see how it behave?

var q = cmd.CommandText ;
+1
Amit Gupta9y ago
Yes, agreed with @Bryian, you can also confirmed whether the value of n>0

int n = cmd.ExecuteNonQuery();

As query seems fine, there may not be updated at the front end level.
+2
Atul Rokade9y ago
yes i check @Bryian actually previuosally it was work fine but recently dont know what happen why its not working
+1
Bryian Tan9y ago
Did you check if it updated in the backend (database)? but not display the udpated value on the Grid?
+1