Repeater嵌套

最新推荐文章于 2017-07-28 17:45:39 发布

原创最新推荐文章于 2017-07-28 17:45:39 发布 · 880 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #string #cmd #border #object #server

Asp.net 专栏收录该内容

35 篇文章

订阅专栏

前台

后台
using System;
using System.Data;
using System.Drawing;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

/// <summary>
///  ShowAll 的摘要说明。
/// </summary>
public class ShowAll : System.Web.UI.UserControl
{
  protected System.Web.UI.WebControls.Repeater subrpt;
  protected System.Web.UI.WebControls.Repeater rpt;
  public string CategoryID="0";
  public string WebCount="4";

  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(!this.IsPostBack)
   {
    SqlConnection con=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
    SqlDataAdapter cmd1=new SqlDataAdapter("select powername,id from navigationsort where parentid="+CategoryID+" order by orderid desc",con);
    DataSet ds=new DataSet();
    cmd1.Fill(ds,"pt");
    rpt.DataSource=ds.Tables["pt"];
    rpt.DataBind();
    con.Close();
   }
  }

  private void rpt_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e)
  {
   if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
   {
    Repeater subrpt = (Repeater) e.Item.FindControl("subrpt");
    DataRowView rowv = (DataRowView)e.Item.DataItem;
    string ParentId = rowv["id"].ToString();
    subrpt.DataSource=getsub(ParentId);
    subrpt.DataBind();
   }
  }
  private DataSet getsub(string id)
  {
   SqlConnection con=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
   SqlDataAdapter cmd1=new SqlDataAdapter("select top "+WebCount+" title,id from navigation where sortid="+id,con);
   DataSet ds=new DataSet();
   cmd1.Fill(ds);
   con.Close();
   return ds;
  }
}