“/”应用程序中的服务器错误。

列名 'l_cityid' 无效。

说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 列名 'l_cityid' 无效。

源错误:


行 371:        Dim V_11 As Integer = 0
行 372:        Dim SqlStr_11 As String = "select top 8 l_id,l_name,l_brief,l_previewpic,l_price,l_cityid from " & tableprefix & "Line inner join (select ls_lineid from " & tableprefix & "LineScenery where ls_citypath like '" & info.path & "%' group by ls_lineid) as a on a.ls_lineid = l_id  order by l_tj desc,l_orderid desc,l_id desc"
行 373:        Dim Dr_11 As SqlDataReader = General.DataList(SqlStr_11,0)
行 374:        If Dr_11.Read Then
行 375:          Do

源文件: f:\usr\LocalUser\hyw7449780001\destination\show.aspx    行: 373

堆栈跟踪:


[SqlException (0x80131904): 列名 'l_cityid' 无效。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61
   System.Data.SqlClient.SqlDataReader.get_MetaData() +90
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1406
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +134
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   TourEx.DBUtility.DbHelper.ExecuteReader(DbConnection connection, DbTransaction transaction, CommandType commandType, String commandText, DbParameter[] commandParameters, DbConnectionOwnership connectionOwnership) +654
   TourEx.DBUtility.DbHelper.ExecuteReader(CommandType commandType, String commandText, DbParameter[] commandParameters) +338
   TourEx.DBUtility.DbHelper.ExecuteReader(CommandType commandType, String commandText) +50
   TourEx.DAL.General.DataList(String SqlStr, Int32 Starts) +19
   TourEx.BLL.General.DataList(String SqlStr, Int32 Starts) +5
   ASP.destination_show_aspx.OnInit(EventArgs e) in f:\usr\LocalUser\hyw7449780001\destination\show.aspx:373
   System.Web.UI.Control.InitRecursive(Control namingContainer) +134
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +489


版本信息: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.0.30319.34280