带有参数的SQL查询中的通配符(Wildcard in SQL Query with Parameters)
我正在使用ASP.NET MVC，我想在我的@stype中添加通配符，如下所示：％@ stype％，但我不知道在我的代码中将它放在哪里，只是注释如果你想看到更多的我的代码，请帮忙。
楷模：
public class SearchParameters { public string sarcode { get; set; } public string stype { get; set; } public SearchParameters() { this.sarcode = string.Empty; this.stype = string.Empty; } internal List<SqlParameter> ToSqlParameterList() { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@sarcode", this.sarcode ?? string.Empty)); parameters.Add(new SqlParameter("@stype", this.stype ?? string.Empty)); return parameters; } }询问
SELECT sarcode,stype,amount,filterno FROM tblsar WHERE ((sarcode = @sarcode OR @sarcode = '') AND (stype = @stype OR @stype = ''))使用Javascript
var table = $('#SARDatatable').DataTable({ "processing": true, dom: "<'row'<'col-sm-6'l><'col-sm-6'f>>" + "<'row'<'col-sm-12'tr>>" + "<'row'<'col-sm-2'i><'col-sm-5'B><'col-sm-5'p>>", buttons: [ 'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5', 'print' ], "ajax": { "url": '/Home/GetAllSAR', "type": "POST", "datatype": "json", "data": function (d) { d.searchParameters = {}; d.searchParameters.sarcode = $('#txtSAR').val(); d.searchParameters.stype = $('#txtSType').val(); } }, "columns": [ { "data": "sarcode", "autoWidth": true }, { "data": "stype", "autoWidth": true }, { "data": "amount", "autoWidth": true }, { "data": "filterno", "autoWidth": true } ] });I am using ASP.NET MVC, I would like to put wildcard in my @stype like this: %@stype%, but I don't know where to put it here in my code, just comment if you want to see more of my code, please help.
Models:
public class SearchParameters { public string sarcode { get; set; } public string stype { get; set; } public SearchParameters() { this.sarcode = string.Empty; this.stype = string.Empty; } internal List<SqlParameter> ToSqlParameterList() { List<SqlParameter> parameters = new List<SqlParameter>(); parameters.Add(new SqlParameter("@sarcode", this.sarcode ?? string.Empty)); parameters.Add(new SqlParameter("@stype", this.stype ?? string.Empty)); return parameters; } }Query
SELECT sarcode,stype,amount,filterno FROM tblsar WHERE ((sarcode = @sarcode OR @sarcode = '') AND (stype = @stype OR @stype = ''))Javascript
var table = $('#SARDatatable').DataTable({ "processing": true, dom: "<'row'<'col-sm-6'l><'col-sm-6'f>>" + "<'row'<'col-sm-12'tr>>" + "<'row'<'col-sm-2'i><'col-sm-5'B><'col-sm-5'p>>", buttons: [ 'copyHtml5', 'excelHtml5', 'csvHtml5', 'pdfHtml5', 'print' ], "ajax": { "url": '/Home/GetAllSAR', "type": "POST", "datatype": "json", "data": function (d) { d.searchParameters = {}; d.searchParameters.sarcode = $('#txtSAR').val(); d.searchParameters.stype = $('#txtSType').val(); } }, "columns": [ { "data": "sarcode", "autoWidth": true }, { "data": "stype", "autoWidth": true }, { "data": "amount", "autoWidth": true }, { "data": "filterno", "autoWidth": true } ] });最满意答案
我建议改用CHARINDEX。 例如
WHERE CHARINDEX(@sarcode, sarcode) > 0I would suggest using CHARINDEX instead. For example
WHERE CHARINDEX(@sarcode, sarcode) > 0更多推荐
发布评论