Server Error in '/' Application.

Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' ) order by sortC 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.Data.SqlClient.SqlException: Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' ) order by sortC desc'.

Source Error:


Line 106:            where += ")";
Line 107:        }
Line 108:        List<mo.products> modelList = pro.getModelListWhere("top 20",where);
Line 109:        if (modelList.Count <= 0)
Line 110:        {

Source File: c:\ftp\cnyltattoo\ProShow.aspx.cs    Line: 108

Stack Trace:


[SqlException (0x80131904): Incorrect syntax near 's'.
Unclosed quotation mark after the character string ' ) order by sortC desc'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1968698
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4907227
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +293
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +70
   opDal.Sqlcs.SqlReader(String sqlstr) in F:\张丽修改网站\修改的网站修改\rongTian_cn\荣天\opDal\Sqlcs.cs:78
   dal.products.setDr(String strSql) in F:\张丽修改网站\修改的网站修改\rongTian_cn\荣天\dal\products.cs:130
   dal.products.getModelListWhere(String strTop, String strWhere) in F:\张丽修改网站\修改的网站修改\rongTian_cn\荣天\dal\products.cs:117
   ProShow.binKey(String key) in c:\ftp\cnyltattoo\ProShow.aspx.cs:108
   ProShow.bin() in c:\ftp\cnyltattoo\ProShow.aspx.cs:52
   ProShow.Page_Load(Object sender, EventArgs e) in c:\ftp\cnyltattoo\ProShow.aspx.cs:22
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.9055; ASP.NET Version:2.0.50727.9051