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

无法绑定由多个部分组成的标识符 "EE.chateau_star"。

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

异常详细信息: System.Data.SqlClient.SqlException: 无法绑定由多个部分组成的标识符 "EE.chateau_star"。

源错误:


行 78:         DataPageWineListByType.ShowRecordCount = pagesize; //每页显示的行数
行 79: 
行 80:         DataPageWineListByType.TotalRecordCount = new S_2_BLL.sp_wine().GetRecordCount(sql); //共有多少行数
行 81:         DataPageWineListByType.QueryString.Remove(0, DataPageWineListByType.QueryString.Length);
行 82:         DataPageWineListByType.QueryString = "page";

源文件: f:\usr\localuser\bgw010007\Wines\WineListByChateau.aspx.cs    行: 80

堆栈跟踪:


[SqlException (0x80131904): 无法绑定由多个部分组成的标识符 "EE.chateau_star"。]
   S_3_DAL_Help.DbHelperSQL.GetSingle(String SQLString) in e:\Develop\4072213\S_3_DAL_Help\DbHelperSQL.cs:445
   S_3_DAL_Sql.sp_wine.GetRecordCount(String strWhere) in e:\Develop\4072213\S_3_DAL_Sql\sp_wine.cs:466
   S_2_BLL.sp_wine.GetRecordCount(String strWhere) in e:\Develop\4072213\S_2_BLL\sp_wine.cs:158
   Wines_WineListByChateau.BindData() in f:\usr\localuser\bgw010007\Wines\WineListByChateau.aspx.cs:80
   Wines_WineListByChateau.Page_Load(Object sender, EventArgs e) in f:\usr\localuser\bgw010007\Wines\WineListByChateau.aspx.cs:44
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +92
   System.Web.UI.Control.LoadRecursive() +54
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772


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