/// <summary>
/// 修改一条食物信息
/// </summary>
public bool updateFoodinfo(string FoodID, string Foodname, string tag, float Carbohydrate, float Protein, float Fat, float VA, float VE, float VC, float VB6, float VB12, float CA, float FE, float K, float ZN, float DietaryFiber, float Cholesterol, float Energy){
try { string sql = "update Foodinfo set (Foodname,tag,Carbohydrate,Protein,Fat,VA,VE,VC,VB6,VB12,CA,FE,K,ZN,DietaryFiber,Cholesterol,Energy) values ('" + Foodname + "','" + tag + "','" + Carbohydrate + "','" + Protein + "','" + Fat + "','" + VA + "','" + VE + "','" + VC + "','" + VB6 + "','" + VB12 + "','" + CA + "','" + FE + "','" + K + "','" + ZN + "','" + DietaryFiber + "','" + Cholesterol + "','" + Energy + "') where FoodID = '"+ FoodID +"' "; SqlCommand cmd = new SqlCommand(sql, sqlCon);
cmd.ExecuteNonQuery();
cmd.Dispose(); return true;
} catch (Exception) {
return false;
}
}
update的语句哪里有问题吗？

啊哦 格式看起来好难受