Sql="select * from Member where UserName Like '%@Search%' order by ID DESC";
SqlCommand searchCmd=new SqlCommand(Sql,dbConn.myConn);
searchCmd.Parameters.Add("@Search",SqlDbType.NVarChar);
searchCmd.Parameters["@Search"].Value=Search;
当我这样运行找不到结果
Sql="select * from Member where UserName Like '%"+Search+"%' order by ID DESC";
要是改成就可以
什么回事啊
SqlCommand searchCmd=new SqlCommand(Sql,dbConn.myConn);
searchCmd.Parameters.Add("@Search",SqlDbType.NVarChar);
searchCmd.Parameters["@Search"].Value=Search;
当我这样运行找不到结果
Sql="select * from Member where UserName Like '%"+Search+"%' order by ID DESC";
要是改成就可以
什么回事啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货