利用Repeater控件显示主－从关系数据表出现异常，请帮忙分析

2012-08-07

利用Repeater控件显示主－从关系数据表出现错误，请帮忙分析利用Repeater控件显示主－从关系数据表页面代码：

利用Repeater控件显示主－从关系数据表出现错误，请帮忙分析
利用Repeater控件显示主－从关系数据表
页面代码：
<asp:repeater id="ParentRepeater" runat="server"
onitemcreated="ParentRepeater_ItemCreated">
<ItemTemplate>
<tr>
<td style="display:block;PADDING-LEFT: 15px;" height="32" background="images/LeftBg.jpg" id="cellbar<%# Container.ItemIndex%>" onclick="menuClick( 'submenu<%# Container.ItemIndex %>','cellbar<%# Container.ItemIndex %>')">
<img src="images/i15_fav.gif" border="0" align="middle" /> <%# DataBinder.Eval(Container.DataItem,"project_name") %>
</td>
</tr>
<tr>
<td>
">
<asp:repeater id="ChildRepeater" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("Operation") %>'>
<itemtemplate>
<img src="images/right.gif" border="0" align="middle" />
<a style="height:18px" href='<%# DataBinder.Eval(Container.DataItem,"OBJ_NAME") %>' target="mainpage"
onclick='showPosition("<%# ProjectName %> → <%# DataBinder.Eval(Container.DataItem,"action_name")%>");'><%# DataBinder.Eval(Container.DataItem,"action_name")%>
</a> 
</itemtemplate>
</asp:repeater>

</td>
</tr>
</ItemTemplate>
</asp:repeater>

CS代码：
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;

public partial class LeftMenu : System.Web.UI.Page
{
private string projectName;
//protected System.Web.UI.WebControls.Repeater ParentRepeater;

public string ProjectName
{
get { return projectName; }
}

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string sql;
MySqlConnection conn = new MySqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["dlxjConnectionString"].ConnectionString;
conn.Open();

sql = string.Format("select project_id,project_name from projectinfo");
MySqlDataAdapter myda = new MySqlDataAdapter(sql, conn);
DataSet myds = new DataSet();
myda.Fill(myds, "project");

//sql = string.Format("select o.OBJ_ID,o.PROJECT_ID,o.ACTION_NAME,OBJ_NAME FROM objectinfo o,userprivates u,privategroup p WHERE u.Privates_ID=p.Private_ID AND p.Obj_ID=o.OBJ_ID AND u.User_ID='{0}'" , Session["UserBh"].ToString());
sql = string.Format("select o.OBJ_ID,o.PROJECT_ID,o.ACTION_NAME,OBJ_NAME FROM objectinfo o,userprivates u,privategroup p WHERE u.Privates_ID=p.Private_ID AND p.Obj_ID=o.OBJ_ID AND u.User_ID='000000'");
MySqlDataAdapter myda2 = new MySqlDataAdapter(sql, conn);

myda2.Fill(myds, "obj");

DataColumn parentCol, childCol;
parentCol = myds.Tables["project"].Columns["project_id"];
childCol = myds.Tables["obj"].Columns["project_id"];
myds.Relations.Add("Operation", parentCol, childCol);

ParentRepeater.DataSource = myds.Tables["project"].DefaultView;
ParentRepeater.DataBind();

conn.Close();
}
}

protected void ParentRepeater_ItemCreated(object sender, RepeaterItemEventArgs e)
{
projectName = ((DataRowView)e.Item.DataItem)["project_name"].ToString();
}

}

现在运行提示 DataBinding:“System.Data.DataRow”不包含名为“OBJ_NAME”的属性。
我将页面代码打红部分注释掉，可以成功运行，也显示出了主菜单的选项，子菜单也有了图片显示，而且刚好子菜单里的图片数量就是我子菜单中的数目，也就是说，后台的数据库已经读取出来了，但是就是不能显示到页面上。
请高人帮忙指点，谢谢

[解决办法]
……<asp:repeater id="ChildRepeater" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("Operation") %>'>
……

代码改成一下代码即可
……
<asp:repeater id="ChildRepeater" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).CreateChildView("Operation") %>'>

热点排行

asp.net

利用Repeater控件显示主－从关系数据表 出现异常，请帮忙分析

利用Repeater控件显示主－从关系数据表出现异常，请帮忙分析