Server Error in '/' Application.

列名 'l_cityid' 无效。

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: 列名 'l_cityid' 无效。

Source Error:


Line 371:        Dim V_11 As Integer = 0
Line 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"
Line 373:        Dim Dr_11 As SqlDataReader = General.DataList(SqlStr_11,0)
Line 374:        If Dr_11.Read Then
Line 375:          Do

Source File: D:\wwwroot\zstours\destination\show.aspx    Line: 373

Stack Trace:


[SqlException (0x80131904): 列名 'l_cityid' 无效。]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   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.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   TourEx.DBUtility.DbHelper.ExecuteReader(DbConnection connection, DbTransaction transaction, CommandType commandType, String commandText, DbParameter[] commandParameters, DbConnectionOwnership connectionOwnership) +657
   TourEx.DBUtility.DbHelper.ExecuteReader(CommandType commandType, String commandText, DbParameter[] commandParameters) +338
   TourEx.DBUtility.DbHelper.ExecuteReader(CommandType commandType, String commandText) +45
   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 D:\wwwroot\zstours\destination\show.aspx:373
   System.Web.UI.Control.InitRecursive(Control namingContainer) +140
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +480


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1