Error:too many characters in character literal

See more:

C#

ASP.NET

DevExpress

Hi all,
I'm having problem when deploying my web application.
My application runs fine in website application, but when i convert to web application project, its showing some errors when i compile.

The error shows as - Too many characters in character literal in sql query,

where i m using dataset in my application to filter search in my developer express report.So,the error is from .xsd file,from sql query :

example:

<CommandText>
SELECT TOP (100) PERCENT CSGNDTL.ItemCode AS MBBTag, 
       CAST(GRDTL.SerialNoList AS nvarchar(30)) AS SerialNumber, 
       GRDTL.UDF_FANumber AS FANumber, GRDTL.UDF_CSCManagedNumber AS CSCManagedCode, 
       Item.Description AS ModelNo, Item.Desc2 AS ModelName, 
       ItemType.Description AS Classification, 
       Location.Location + ' - ' + Location.Description AS Location, 
       CSGN.CreatedUserID AS ApproveBy, CSGN.CreatedTimeStamp AS ApproveDate,
       Item.UDF_OwnerShip
FROM CSGN 
INNER JOIN CSGNDTL ON CSGN.DocKey = CSGNDTL.DocKey 
INNER JOIN GRDTL ON CSGNDTL.ItemCode = GRDTL.ItemCode 
INNER JOIN Debtor ON CSGN.DebtorName = Debtor.CompanyName 
INNER JOIN Item ON CSGNDTL.ItemCode = Item.ItemCode 
INNER JOIN Location ON CSGNDTL.Location = Location.Location 
INNER JOIN ItemType ON Item.UDF_Classification = ItemType.ItemType 
INNER JOIN SerialNoTrans ON CSGNDTL.DtlKey = SerialNoTrans.DtlKey 
WHERE (CSGN.Description = 'ACTIVE') AND (Location.Location LIKE @Location) 
ORDER BY ApproveDate DESC
</CommandText>

the error shows at wherever i use the ' - ' and 'ACTIVE'

anyone knows what causing this error?