Server Error in '/' Application.

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Persian_100_CI_AI" in the equal to operation.

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.SqlClient.SqlException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Persian_100_CI_AI" in the equal to operation.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Persian_100_CI_AI" in the equal to operation.]
   DataAccess.StoredProcedures.sp_searchProductList(String paramstring) +497
   Business.Product.SearchProducts(String paramstring, DataTable& dtPageNumbers, Dictionary`2& dtHeaders) +76
   PaydarFramework.pk.listing.showProducts() +191
   PaydarFramework.pk.listing.Page_Load(Object sender, EventArgs e) +74
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


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