'/' 應用程式中發生伺服器錯誤。

,System.Exception: getDataTable ERROR! , System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'OR'.
  於 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  於 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  於 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  於 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  於 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
  於 System.Data.SqlClient.SqlDataReader.get_MetaData()
  於 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  於 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
  於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
  於 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
  於 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
  於 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  於 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  於 ADPage.LinkLayer.DBDataLink.getDataTable()
  於 ADPage.LinkLayer.DBDataLink.getDataTable()
  於 DAL.Comment.getComments(TreeCriteria myCri)

描述: 在執行目前 Web 要求的過程中發生未處理的例外情形。請檢閱堆疊追蹤以取得錯誤的詳細資訊,以及在程式碼中產生的位置。

例外詳細資訊: System.Exception: ,System.Exception: getDataTable ERROR! , System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'OR'.
  於 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  於 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
  於 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  於 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  於 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
  於 System.Data.SqlClient.SqlDataReader.get_MetaData()
  於 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
  於 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
  於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
  於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
  於 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
  於 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
  於 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  於 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
  於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
  於 ADPage.LinkLayer.DBDataLink.getDataTable()
  於 ADPage.LinkLayer.DBDataLink.getDataTable()
  於 DAL.Comment.getComments(TreeCriteria myCri)

原始程式錯誤:


行 196:		TreeCriteria myCri = new TreeCriteria();
行 197:		myCri.Parent_ID = ParentID;
行 198:		DataTable dt = dal.getComments(myCri);
行 199:		if(dt.Rows.Count > 0)
行 200:		{

原始程式檔: c:\Webhost\vhosts\top3.com.tw\httpdocs\forums\Discuss.aspx    行: 198

堆疊追蹤:


[Exception: ,System.Exception: getDataTable ERROR! , System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'OR'.
   於 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   於 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   於 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   於 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   於 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   於 System.Data.SqlClient.SqlDataReader.get_MetaData()
   於 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   於 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   於 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   於 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   於 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   於 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   於 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   於 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   於 ADPage.LinkLayer.DBDataLink.getDataTable()
   於 ADPage.LinkLayer.DBDataLink.getDataTable()
   於 DAL.Comment.getComments(TreeCriteria myCri)]
   DAL.Comment.getComments(TreeCriteria myCri) +537
   ASP.forums_discuss_aspx.dealFlist_In_Comment(String FClass, String ParentID, Boolean isBoardManager, Int32 page) in c:\Webhost\vhosts\top3.com.tw\httpdocs\forums\Discuss.aspx:198
   ASP.forums_discuss_aspx.Page_Init(Object sender, EventArgs e) in c:\Webhost\vhosts\top3.com.tw\httpdocs\forums\Discuss.aspx:132
   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.OnInit(EventArgs e) +99
   System.Web.UI.Page.OnInit(EventArgs e) +12
   System.Web.UI.Control.InitRecursive(Control namingContainer) +333
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378


版本資訊: Microsoft .NET Framework 版本:2.0.50727.3053; ASP.NET 版本:2.0.50727.3053