UPDATE 表名 SET 列名=新值 where 条件;
stringbuilder
public static string UPDATEBYID(string tablename, params string [] values)
{
StringBuilder sb1 = new StringBuilder("UPDATE " + tablename + "SET");
int NUM = values.Length;
StringBuilder sb2 = new StringBuilder();
for (int i = 0; i < NUM; i++)
{
sb2.Append("[" + values[i] + "]=@" + values[i]+",");
}
sb2.Remove(sb2.Length - 1, 1);
sb1.Append(sb2).Append("WHERE DI=@ID");
return sb1.ToString();
}