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

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

版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/183522.html原文链接：https://javaforall.cn