Asp.net 嵌套数据绑定 repeater 主从数据嵌套【转】

Asp.net 嵌套数据绑定 repeater 主从数据嵌套

(2009-02-08 15:58:57)

转载

标签：

杂谈

分类：Asp.net

自动获取数据库中的主从关系数据，以下是获取省份及省份对应的城市，代码如下：

重点：DataSource ='<%#Getawd(eval_r("pid").ToString()) %>' 调用GetCity方法获取子类

嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/None.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif">protected void Page_Load(object sender, EventArgs e)
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif">    {
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">        if (!Page.IsPostBack)
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">             BindGrid();
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif">     }
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/None.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif">    //获取大类的类别
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/None.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif">    protected void BindGrid()
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif">    {
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">        string cmdText = "select pid, pname from pro";
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">         DataTable dt = vc.GetDataTable(cmdText );
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">         Repeater1.DataSource = dt;
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">         Repeater1.DataBind();
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif">     }
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/None.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif">    //获取小类内容
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/None.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/None.gif">    protected DataTable GetCity(string   id)
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif">    {
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">        string cmdText = "select city_name from city where promo_id = " + id + "";
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">         DataTable dt = vc.GetDataTable(cmdText);
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif">        return dt;
Asp.net <wbr alt= 嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif" align=top twffan="done" real_src="http://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif">     }

实现效果如下：
嵌套数据绑定 repeater 主从数据嵌套" style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; LIST-STYLE-TYPE: none; BORDER-RIGHT-WIDTH: 0px" height=342 alt="Asp.net 嵌套数据绑定 repeater 主从数据嵌套" src="https://images.cnblogs.com/cnblogs_com/chy710/adonetbind.JPG" width=201 border=0 twffan="done" real_src="http://images.cnblogs.com/cnblogs_com/chy710/adonetbind.JPG">

posted on 2010-08-03 08:32 忙碌ｄｅ代码阅读(449) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

梦想璀璨

公告

Asp.net 嵌套数据绑定 repeater 主从数据嵌套

杂谈