大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE稳定放心使用
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();
}
}
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
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/183522.html原文链接：https://javaforall.net
