How Can I Subtract The Update Inputed Value In Inventoryout To Inventory?

See more:

C#

//every time i execute the NewBind() it subtract all of the same product name in the inventory out and update the inventory.

private void NewBind()
{
    try
    {
        MySqlConnection con = new MySqlConnection("Server=localhost;UID=root;Database=db_cignal");
        con.Open();
        MySqlCommand cmd = con.CreateCommand();
        cmd.CommandText = "update inventoryOut.TotalPrice = (inventory.TotalPrice - inventoryout.TotalPrice) where inventory.Product = @Products";
        cmd.Parameters.AddWithValue("@Products", cbProductOut.SelectedItem.ToString());
        cmd.Prepare();
        cmd.ExecuteNonQuery();
        BindGridInventory();
        con.Close();
    }
    catch(Exception t)
    {
        MessageBox.Show(t.Message);
    }
}

//sample
inventory DB(lets assume that this is already deducted product 1 10 stocks)

Product 1   100 stocks   1000 Total Price
Product 2   50  stocks   500  Total Price

inventoryOUT BD(let assume the last value is the updated)

Product 1   10  stocks   100  Total Price
Product 1   50  stocks   500  Total Price

..not desired output
newBind():
inventory DB

Product 1   40  stocks    400 Total Price
Product 2   50  stocks    500 total Price

..desired output
newBind():
inventory DB

Product 1   50  stocks    500 Total Price
Product 2   50  stocks    500 total Price