我一直在为我的工作场所建立一个小型库存系统,并偶然发现了一个我似乎无法解决的错误
private void Update(string num,string name, string quant, string location, string category, string numquery) { // "UPDATE Inventory SET Inventorynumber='"+ num +"',Inventory_Name='"+name+"', Quantity ='"+ quant+"',Location ='"+ location+"' Category ='"+ category+"' WHERE Inventorynumber ='"+ numquery +"';"; string query = "UPDATE Inventory SET Inventorynumber='" + Convert.ToInt16(num) + "',Inventory_Name='" + name + "', Quantity ='" + quant + "',Location ='" + location + "' Category ='" + category + "' WHERE Inventorynumber ='" + Convert.ToInt16(numquery) + "'"; if (this.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = query; cmd.Connection = serverconnection; cmd.ExecuteNonQuery(); this.CloseConnection(); Bind(); } }
我不知道在这里要改变什么.任何帮助,将不胜感激.