query指定范围提取数据_嵌套查询和子查询

编程汇总 • 2025-03-22 13:40 • 阅读 28

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

query指定范围提取数据_嵌套查询和子查询

相关推荐