当前位置: 代码迷 >> ASP.NET >> 利用Repeater控件显示主-从关系数据表 出现异常,请帮忙分析
  详细解决方案

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

热度:656   发布时间:2013-02-25 00:00:00.0
利用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" /><b><font color="#00000">&nbsp;<%# DataBinder.Eval(Container.DataItem,"project_name") %></font></b>
  </td>
</tr>
<tr>
<td>
<span style="display: block;background-color:#e6f3fc;PADDING-LEFT: 15px;" id="submenu<%# Container.ItemIndex %>">
<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> <br />
</itemtemplate>
</asp:repeater>
</span>
</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);  
  相关解决方案