如何在linq查询中转换unicode

本文关键字：转换 unicode 查询 linq | 更新日期: 2023-09-27 18:13:34

我的数据库中有两个表:InvoiceDetail和ProductDetail。我想编写一个搜索条件，如果我搜索产品或客户，它将显示相关的发票。这是我的searchClickevent代码。

给出错误The query syntax is not valid. Near term '>', line 6, column 136. 

protected void SearchInvoiceButton_Click(object sender, EventArgs e)
{ 
    String WhereClause = "it.UserID==@UserID AND it.IsDeleted == false AND (it.ClientDetail.ClientName LIKE '%' + @SearchTerm + '%') OR (it.InvoiceDetail.Any(p=>p.ItemName))";
    EntityDataSourceInvoice.Where = WhereClause;
    ViewState["InvoiceViewWhereClause"] = WhereClause;
    if (EntityDataSourceInvoice.WhereParameters["SearchTerm"] != null)
    {
        EntityDataSourceInvoice.WhereParameters["SearchTerm"].DefaultValue = SafeSearchLiteral(SearchTextBox.Text.Trim());
    }
    else
    {
        Parameter CategoryParameter = new Parameter("SearchTerm", System.Data.DbType.String, SafeSearchLiteral(SearchTextBox.Text.Trim()));
        CategoryParameter.ConvertEmptyStringToNull = false;
        EntityDataSourceInvoice.WhereParameters.Add(CategoryParameter);
    }        
    InvoiceGrid.DataBind();
    InvoiceGrid.AllowPaging = false;
    InvoiceGrid.AllowPaging = true;
}

如何在linq查询中转换unicode

试试这个:——

我不知道类/表/EntityDatasource结构，但我想这应该工作，改变只是在哪里子句:- 

String WhereClause = "it.UserID==@UserID AND it.IsDeleted == false 
AND ((it.ClientDetail.ClientName LIKE '%' + @SearchTerm + '%') 
OR (it.ItemName LIKE '%'+ @SearchTerm + '%'))";
相关文章：