protected void Page_Load(object sender, EventArgs e)
{
SqlParameter[] Param ={
new SqlParameter("@UserType", SqlDbType.Int),
new SqlParameter("@UserName",SqlDbType.NVarChar)
};
Param[0].Value = 1;
Param[1].Value = "P"; int Count = DbHelper.ExecuteSql("Update tb_user_userinfo Set Account=Account+10 Where UserName Like '%@UserName%'", Param);
Response.Write(Count);
}当用到Like匹配查询时,为何会查不出有效的数据?
{
SqlParameter[] Param ={
new SqlParameter("@UserType", SqlDbType.Int),
new SqlParameter("@UserName",SqlDbType.NVarChar)
};
Param[0].Value = 1;
Param[1].Value = "P"; int Count = DbHelper.ExecuteSql("Update tb_user_userinfo Set Account=Account+10 Where UserName Like '%@UserName%'", Param);
Response.Write(Count);
}当用到Like匹配查询时,为何会查不出有效的数据?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货