daigong - 2022/11/15 10:03:27
我们有一个配件库搜索功能，型号需要区分大小写，搜索时候也需要区分大小写，目前根据官方教程写的，但是无法区分大小写，恳请版主指导一下，下面是搜索的核心代码
string xinghao = StringHelper.Format<string>(HttpContext.Current.Request.QueryString["xinghao"]); //获取搜索型号
string condition ="xinghao like @xinghao ";
var dataList = Html.InfoDataList(new { Table = "PeiJian", OrderBy = "stock desc" },condition, new { xinghao= "%" + xinghao+ "%"},pageInfo);
xiyou - 2022/11/15 12:00:50
string condition ="xinghao like @xinghao ";
改为
string condition ="xinghao collate Chinese_PRC_CS_AS like @xinghao ";
daigong - 2022/11/15 16:31:33
:strong:可以了，完美解决问题，感谢指点