当前位置:Gxlcms > 数据库问题 > MySqlParameter

MySqlParameter

时间:2021-07-01 10:21:17 帮助过:2人阅读

执行带参数的SQL增删改语句 /// SQL增删改语句 /// 参数集合 /// 返回更新的记录数 public int ExecuteNonQuery(string sql, params MySqlParameter[] args) { int res; using (comm = new MySqlCommand(sql, GetConn())) { comm.Parameters.AddRange(parms); res = comm.ExecuteNonQuery(); } return res; }

update

MySqlParameter[] args = new MySqlParameter[] {
     
new MySqlParameter("@height", Request.Form["height"]), new MySqlParameter("@weight", Request.Form["weight"]) };
var sql =
"update status set height=@height,weight=@weight where code =2";

db.ExecuteNonQuery(sql,args);


 

MySqlParameter

标签:

人气教程排行