repeater嵌套查询

repeater嵌套查询。代码如下：

代码

using  System;
using  System.Collections.Generic;
using  System.Linq;
using  System.Web;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Data;

namespace  HxCMS.Site.Controls
{
     public   partial   class  HXCMS_Index_Menu : System.Web.UI.UserControl
    {
        HxCMS.DataProvider.DataProvider dataProvider  =   new  DataProvider.DataProvider();
         protected   void  Page_Load( object  sender, EventArgs e)
        {
            DataTable dt  =  dataProvider.HXCMS_CATEGORY_SearchAny( " and CATEGORY_CONTENT_TYPE_VALUE=1 and CATEGORY_PID=0 " ,  "" ,  "" );
            Repeater1.DataSource  = dt;
            Repeater1.DataMember  =   " CATEGORY_ID " ;
            Repeater1.DataBind();
        }

         protected   void  Repeater1_ItemDataBound( object  sender, RepeaterItemEventArgs e)
        {
             if  (e.Item.ItemType  ==  ListItemType.Item  ||  e.Item.ItemType  ==  ListItemType.AlternatingItem)
            {
                Repeater rpt  =  e.Item.FindControl( " repeater2 " )  as  Repeater;
                DataRowView rowv  =  (DataRowView)e.Item.DataItem;
                 int  pid  =  Convert.ToInt32(rowv[ " CATEGORY_ID " ]);
                rpt.DataSource  =  dataProvider.HXCMS_CATEGORY_SearchAny( " and CATEGORY_CONTENT_TYPE_VALUE=1 and CATEGORY_PID= "   +  pid,  "" ,  "" );
                rpt.DataBind();
            }
        }

 

 

转载于:https://www.cnblogs.com/codingspace/archive/2010/08/17/1801648.html