Server Error in '/' Application.

Error in Like operator: the string pattern '%;Sri%20Lanka;%' is invalid.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.EvaluateException: Error in Like operator: the string pattern '%;Sri%20Lanka;%' is invalid.

Source Error:


Line 1927:                //else
Line 1928:                dsViewSuppyManu = new DataView(ds.Tables[0]);
Line 1929:                dsViewSuppyManu.RowFilter = "country not in('" + oCountry + "') and supply_country like '%;" + oCountry + ";%'  and status='Approved' and " + _filed + "_featured=1 and  " + _filed + "_type=1";
Line 1930:                _dtCheckSManus = dsViewSuppyManu.ToTable();
Line 1931:                dsViewSuppyManu.Sort = "" + _filed + "_supply_sort_order desc, display_name asc";

Source File: c:\inetpub\wwwroot\pcbdirectory.com\App_Code\FrontEnd.cs    Line: 1929

Stack Trace:


[EvaluateException: Error in Like operator: the string pattern '%;Sri%20Lanka;%' is invalid.]
   System.Data.LikeNode.AnalyzePattern(String pat) +1463147
   System.Data.LikeNode.Eval(DataRow row, DataRowVersion version) +352
   System.Data.BinaryNode.Eval(ExpressionNode expr, DataRow row, DataRowVersion version, Int32[] recordNos) +22
   System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos) +13179
   System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version) +27
   System.Data.BinaryNode.Eval(ExpressionNode expr, DataRow row, DataRowVersion version, Int32[] recordNos) +22
   System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos) +12780
   System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version) +27
   System.Data.BinaryNode.Eval(ExpressionNode expr, DataRow row, DataRowVersion version, Int32[] recordNos) +22
   System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos) +12780
   System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version) +27
   System.Data.BinaryNode.Eval(ExpressionNode expr, DataRow row, DataRowVersion version, Int32[] recordNos) +22
   System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos) +12780
   System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version) +27
   System.Data.DataExpression.Invoke(DataRow row, DataRowVersion version) +67
   System.Data.Index.AcceptRecord(Int32 record, IFilter filter) +125
   System.Data.Index.InitRecords(IFilter filter) +278
   System.Data.Index..ctor(DataTable table, IndexField[] indexFields, Comparison`1 comparison, DataViewRowState recordStates, IFilter rowFilter) +497
   System.Data.DataTable.GetIndex(IndexField[] indexDesc, DataViewRowState recordStates, IFilter rowFilter) +239
   System.Data.DataView.UpdateIndex(Boolean force, Boolean fireEvent) +256
   System.Data.DataView.UpdateIndex(Boolean force) +18
   System.Data.DataView.SetIndex2(String newSort, DataViewRowState newRowStates, IFilter newRowFilter, Boolean fireEvent) +113
   System.Data.DataView.SetIndex(String newSort, DataViewRowState newRowStates, IFilter newRowFilter) +20
   System.Data.DataView.set_RowFilter(String value) +165
   PCB.FrontEnd.GetAllManufacturerCache(String oCountry, String oState, String oCity, String specValue, String oOrderBy, String oSortOrder, Int32 topLimit, Int32 pages, Int32& TotalCount, String type, String manufacture_supply, String t_sort_order, String f_sort_order, String t_type, DataSet ds, Int32 isFiltercountry, DataTable& dtManuSpec) in c:\inetpub\wwwroot\pcbdirectory.com\App_Code\FrontEnd.cs:1929
   directory_design.GetAllManufacturesCache() in c:\inetpub\wwwroot\pcbdirectory.com\directory\design.aspx.cs:968
   directory_design.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\pcbdirectory.com\directory\design.aspx.cs:254
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4330.0