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();

            }

        }