Note: during the execution of the current Web request, abnormal untreated, please check the stack trace, to learn about the errors and mistakes in the code of the source of detailed information,

Exception details: System. The Data. SqlClient. SqlException: ') 'near a syntax error,

The error source:


Line 1198: the if (mustCloseConnection)
Line 1199: connection. The Close ();
Line 1200: throw;
Line 1201:}
Line 1202:}

The source file: C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea markets, Shopping \ Common \ SqlHelper line cs: 1200
[SqlException x80131904 (0) : ') 'near a syntax error,]
System. The Data. SqlClient. SqlConnection. one rror (SqlException exception, Boolean breakConnection, Action ` wrapCloseInAction) 1 + 2573902
System. The Data. SqlClient. SqlInternalConnection. one rror (SqlException exception, Boolean breakConnection, Action ` wrapCloseInAction) 1 + 6015690
System. The Data. SqlClient. TdsParser. ThrowExceptionAndWarning (TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) + 297
System. The Data. SqlClient. TdsParser. TryRun (RunBehavior RunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& DataReady) + 4291
System. The Data. SqlClient. SqlDataReader. TryConsumeMetaData () + 59
System. The Data. SqlClient. SqlDataReader. Get_MetaData () + 91
System. The Data. SqlClient. SqlCommand. FinishExecuteReader (SqlDataReader ds, RunBehavior RunBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) + 446
System. The Data. SqlClient. SqlCommand. RunExecuteReaderTds (CommandBehavior cmdBehavior, RunBehavior RunBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& Task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) + 2698
System. The Data. SqlClient. SqlCommand. RunExecuteReader (CommandBehavior cmdBehavior, RunBehavior RunBehavior, Boolean returnStream, String method, TaskCompletionSource ` 1 completion, Int32 timeout, Task& Task, Boolean& UsedCache, Boolean asyncWrite, Boolean inRetry) + 1540
System. The Data. SqlClient. SqlCommand. RunExecuteReader (CommandBehavior cmdBehavior, RunBehavior RunBehavior, Boolean returnStream, String method) + 65
System. The Data. SqlClient. SqlCommand. ExecuteReader (CommandBehavior behaviors, String method) + 251
System. The Data. SqlClient. SqlCommand. ExecuteReader (CommandBehavior behaviors) + 84
Shopping. Data. SqlHelper. ExecuteReader (SqlConnection connection, SqlTransaction transaction, CommandType CommandType, String commandText, SqlParameter [] commandParameters) in C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea markets, Shopping \ Common \ SqlHelper cs: 1200
Shopping. Data. SqlHelper. ExecuteReader (CommandType CommandType, String commandText, SqlParameter [] commandParameters) in C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea markets, Shopping \ Common \ SqlHelper cs: 1261
Shopping. Data. SqlHelper. ExecuteReader (String commandText) in C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea markets, Shopping \ Common \ SqlHelper cs: 1215
Shopping. DAL. UserProvider. GetUserList (String condition) in C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea markets, Shopping \ DAL \ Shopping_User cs: 274
Shopping. UserBLL. GetUserList (String condition) in C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea markets, Shopping \ the BLL \ Shopping_User cs: 123
Shopping. Web. ShoppingCartEx. Page_Load (Object sender, EventArgs e) in C: \ Users \ \ Desktop \ 12575 graduation design, the campus flea market and Shopping. Web \ ShoppingCartEx aspx. Cs: 62
System. Web. Util. CalliEventHandlerDelegateProxy. Callback (Object sender, EventArgs e) + 52
System. Web. UI. Control the onl oad (EventArgs e) + 97
System. Web. UI. Control. LoadRecursive () + 61
System. Web. UI. Page. ProcessRequestMain (Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) + 693

CodePudding user response:

') 'near a syntax error
Don't ask, you'll know it in the SQL statement printed,
Learn to debug

CodePudding user response:

Shopping_User. Cs line 123, GetUserList (String condition) a breakpoint, the condition of the input String may have a problem,

CodePudding user response:

Should be written by SQL wrong perception problem

CodePudding user response:

Prompt clearly, execute the SQL statement wrong grammar

CodePudding user response:

There is a special character string conversions

CodePudding user response:

SQL statement has a problem, break point out and have a look

CodePudding user response:

SQL to separate out and carry out first