Server Error in '/' Application.

There was a problem getting a list of celebrityHeights Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' ORDER BY cm desc'.

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.ApplicationException: There was a problem getting a list of celebrityHeights Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' ORDER BY cm desc'.

Source Error:


Line 621:        catch (SqlException ex)
Line 622:        {
Line 623:            throw new ApplicationException("There was a problem getting a list of celebrityHeights " + ex.Message);
Line 624:        }
Line 625:    }

Source File: C:\Websites\MrHeightProject\MrHeightProject\App_Code\database.cs    Line: 623

Stack Trace:


[ApplicationException: There was a problem getting a list of celebrityHeights Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' ORDER BY cm desc'.]
   database.GetCategoryCelebs(String category) in C:\Websites\MrHeightProject\MrHeightProject\App_Code\database.cs:623
   category.Page_Load(Object sender, EventArgs e) in C:\Websites\MrHeightProject\MrHeightProject\category.aspx.cs:26
   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.4700.0