列前缀 'container' 与查询中所用的表名或别名不匹配

错误提示如下：“/sss”应用程序中的服务器错误。
--------------------------------------------------------------------------------列前缀 'container' 与查询中所用的表名或别名不匹配。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。异常详细信息: System.Data.SqlClient.SqlException: 列前缀 'container' 与查询中所用的表名或别名不匹配。源错误:
行 28：     dbdelete.connection = dbconn
行 29：     dbdelete.connection.open
行 30：     dbdelete.executenonquery()
行 31：     dbconn.close
行 32：     call builddatalist()
源文件: D:\My document\My Webs\平衡计分卡\留言板\msgnote2.aspx    行: 30 堆栈跟踪:
[SqlException: 列前缀 'container' 与查询中所用的表名或别名不匹配。]
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +180
   ASP.msgnote2_aspx.datalist_delete(Object sender, DataListCommandEventArgs e) in D:\My document\My Webs\平衡计分卡\留言板\msgnote2.aspx:30
   System.Web.UI.WebControls.DataList.OnDeleteCommand(DataListCommandEventArgs e) +110
   System.Web.UI.WebControls.DataList.OnBubbleEvent(Object source, EventArgs e) +247
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
   System.Web.UI.WebControls.DataListItem.OnBubbleEvent(Object source, EventArgs e) +100
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +121
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138
   System.Web.UI.Page.ProcessRequestMain() +1277
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573 数据库：表名：msgboard
主键：msgid  int 4  是自动递增编号的

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

源代码如下：<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.sqlclient" %>
<%@ Page Language="VB" Debug="true" %>
<script language="VB" runat="server">
sub page_load(byval sender as object,byval e as eventargs)
 if not ispostback then
 dim dbconn as sqlconnection
 dim dbcommand as sqldataAdapter
 dim dspagedata as new dataset
 dbconn = new sqlconnection(configurationsettings.appsettings("conn"))
 dbcommand = new sqldataAdapter("select nickname,sex,email,msgtitle,msgcontent,msgtime,ipaddr from msgboard order by msgtime", dbconn)
 dbcommand.fill(dspagedata,"msgboard")
 dldepts.datasource = dspagedata.tables("msgboard").defaultview
 dldepts.databind()
 end if
end sub
sub turn_click(Sender As Object, E As EventArgs)
 Response.redirect("msgnote.aspx")
end sub
sub datalist_delete(sender as object, e as datalistcommandeventargs)
 dim theid as string
 theid = ctype(e.item.findcontrol("lblid"), label).text
 dim dbconn as sqlconnection
 dim dbdelete as new sqlcommand
 dbconn = new sqlconnection(configurationsettings.appsettings("conn"))
 dbdelete.commandtext = "delete from msgBoard where " _
 & "msgid = " & theid
 dbdelete.connection = dbconn
 dbdelete.connection.open
 dbdelete.executenonquery()
 dbconn.close
 call builddatalist()
end sub
sub builddatalist()
 dim dbconn as sqlconnection
 dim dbcommand as sqldataAdapter
 dim dspagedata as new dataset
 dbconn = new sqlconnection(configurationsettings.appsettings("conn"))
 dbcommand = new sqldataAdapter("select nickname,sex,email,msgtitle,msgcontent,msgtime,ipaddr from msgboard order by msgtime", dbconn)
 dbcommand.fill(dspagedata,"msgboard")
 dldepts.datasource = dspagedata.tables("msgboard").defaultview
 dldepts.databind()
end sub</script>
<html>
<body>
<form runat = "server">
 
<asp:label id = "lblmessage" font-size = "12pt" font-bold = "true" font-name = "lucida console" text="这里是管理员页面，以下是该留言板的所有留言" runat = "server"/>
                          
<asp:button id = "return" text=" 添加留言 " onclick= "turn_click" runat ="server"/>
 
<asp:DataList id = "dldepts" runat = "server" ondeletecommand = "datalist_delete" repeatcolumns=1 repeatdirection = "vertical" repeatlayout = "table" gridlines = "both" backcolor = "darkred" borderwidth=3 bordercolor = "darkgreen">
 <headerstyle
 backcolor = "darkred"
 forecolor = "lightyellow"
 font-bold = "true"
 />
 <HeaderTemplate>
 利益相关体者留言板
 </HeaderTemplate>
 <itemtemplate>
 留言页：
 <asp:label id = "lblid" runat = "server" text = 'databinder.eval(container.dataitem,"msgid")' visible = "false" />

 <%#" 主题：" _
 & databinder.eval(container.dataitem,"msgtitle") _
 & " 内容：" _
 & databinder.eval(container.dataitem,"msgcontent") _
 & " 昵称：" _
 & databinder.eval(container.dataitem,"nickname") _
 & "   性别： " _
 & databinder.eval(container.dataitem,"sex") _
 & " 电子邮件：" _
 & databinder.eval(container.dataitem,"email") _
 & " 发贴时间：" _
 & databinder.eval(container.dataitem,"msgtime") _
 & " " _
 & databinder.eval(container.dataitem, "ipaddr")
 %>
 
 <asp:linkbutton id = "butdelete" text = "删除该留言" commandname = "delete" runat = "server"/>
 </itemtemplate>
 <alternatingitemstyle
 backcolor = "lightgreen"
 forecolor = "darkblue"
 />
 <alternatingitemtemplate>
 留言页：
 <asp:label id = "lblid" runat = "server" text = 'databinder.eval(container.dataitem,"msgid")' visible = "false" />
 <%#"主题：" _
 & databinder.eval(container.dataitem,"msgtitle") _
 & " 内容：" _
 & databinder.eval(container.dataitem,"msgcontent") _
 & " 昵称：" _
 & databinder.eval(container.dataitem,"nickname") _
 & "   性别： " _
 & databinder.eval(container.dataitem,"sex") _
 & " 电子邮件：" _
 & databinder.eval(container.dataitem,"email") _
 & " 发贴时间：" _
 & databinder.eval(container.dataitem,"msgtime") _
 & " " _
 & databinder.eval(container.dataitem, "ipaddr")
 %>
 
 <asp:linkbutton id = "butdelete" text = "删除该留言" commandname = "delete" runat = "server"/>
 </alternatingitemtemplate>
 <separatortemplate>
 ******   ******   ******   ******   ******   ******   ******   ******   ******   ******
 </separatortemplate>
 <footerstyle
 backcolor = "darkred"
 forecolor = "lightyellow"
 font-bold = "true"
 />
 <footertemplate>
 留言就此结束，谢谢
 </footertemplate>
</asp:DataList>
 
 
</form>
</body>
</html>
请求帮助
<asp:label id = "lblid" runat = "server" text = '<%#Databinder.Eval(Container.DataItem,"msgid")%>' visible = "false" />consider to use DataKey
text = '<%#Databinder.Eval(Container.DataItem,"msgid")%>
Container.DataItem相当于一行数据，"msgid"是那一行某一列名叫MSGID的那一列数据
'<%#Databinder.Eval(Container.DataItem,"msgid")%>
邦定代码错了，<%# ")%> 弄掉了
啊？我改成了 'databinder.eval(container.dataitem,"msgid")'
或者"databinder.eval(container.dataitem,'msgid')"都不行啊
<asp:label id = "lblid" runat = "server" text = <%# DataBinder.Eval(Container.DataItem,"msgid") %> visible = "false" />
这样还不行的话就是其它地方有问题了
主题：<%# DataBinder.Eval(Container.DataItem,"msgtitle") %>
 内容：<%# DataBinder.Eval(Container.DataItem,"msgcontent") %>这样试试(建议注意一下大小写)。
=========================================================
<asp:label id = "lblid" runat = "server" text = 'databinder.eval(container.dataitem,"msgid")' visible = "false" />
=========================================================这里也写错了，应该是：
<asp:label id = "lblid" runat = "server" text = '<%# databinder.eval(container.dataitem,"msgid") %>' visible = "false" />
to: AllenTing() 修改后提示如下错误：
“/sss”应用程序中的服务器错误。
--------------------------------------------------------------------------------DataBinder.Eval：“System.Data.DataRowView”不包含名称为 msgid 的属性。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。异常详细信息: System.Web.HttpException: DataBinder.Eval：“System.Data.DataRowView”不包含名称为 msgid 的属性。源错误:
行 63： <itemtemplate>
行 64： 留言页：
行 65： <asp:label id = "lblid" runat = "server" text = <%# DataBinder.Eval(Container.DataItem,"msgid") %> visible = "false" />
行 66：
行 67： <%#" 主题：" _
源文件: D:\My document\My Webs\平衡计分卡\留言板\msgnote2.aspx 行: 65 堆栈跟踪:
[HttpException (0x80004005): DataBinder.Eval：“System.Data.DataRowView”不包含名称为 msgid 的属性。]
 System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +144
 System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts) +71
 System.Web.UI.DataBinder.Eval(Object container, String expression) +82
 ASP.msgnote2_aspx.__DataBind__control5(Object sender, EventArgs e) in D:\My document\My Webs\平衡计分卡\留言板\msgnote2.aspx:65
 System.Web.UI.Control.OnDataBinding(EventArgs e) +66
 System.Web.UI.Control.DataBind() +26
 System.Web.UI.Control.DataBind() +86
 System.Web.UI.WebControls.DataList.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +127
 System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +686
 System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +49
 System.Web.UI.WebControls.BaseDataList.DataBind() +23
 ASP.msgnote2_aspx.page_load(Object sender, EventArgs e) in D:\My document\My Webs\平衡计分卡\留言板\msgnote2.aspx:14
 System.Web.UI.Control.OnLoad(EventArgs e) +67
 System.Web.UI.Control.LoadRecursive() +35
 System.Web.UI.Page.ProcessRequestMain() +731
--------------------------------------------------------------------------------
版本信息: Microsoft .NET Framework 版本:1.1.4322.573; ASP.NET 版本:1.1.4322.573
to:ldljlq(小刀) 像你说的那样改了后。。也是提示如上面那样的错误。。我痛苦中啊
在你的Select查询语句中把msgid这个字段加进去。
错误已经说得很明显了，没有msgid这个字段，当然会出错了。
已解决，谢谢各位。。错误就是如：birdxxxx所说的。。晕啊。。我还一直以为是哪里的错误，真的是非常谢谢