首页 > 代码库 > MySqlParameter

MySqlParameter

MySqlHelper

// 执行带参数的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