Repeater的复杂使用讲解实例子

最新推荐文章于 2026-05-07 10:33:08 发布

原创最新推荐文章于 2026-05-07 10:33:08 发布 · 1k 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#数据库 #null #c

本文通过实例详细展示了ASP.NET中Repeater控件的复杂使用方法，包括嵌套Repeater实现多级供应商数据展示，并提供了完整的代码示例。

Repeater的复杂使用讲解实例子

在CSDN上看到大家问这到这种贴子，晚上回家想了下大概做下了

做得不完全，给大家一种思想吧(用到的嵌套Repeater控件)有些出入，楼主可自已再改动下，

http://topic.csdn.net/u/20080414/22/b54c735c-b2c0-4225-9a25-080d1309b168.html

代码:

<% @ Page Language="C#" AutoEventWireup="true" CodeFile="Test_GridView8.aspx.cs" Inherits="GridView_Test_GridView8" %>

<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >

< html xmlns ="http://www.w3.org/1999/xhtml" >

< head runat ="server" >

< title > 无标题页 </ title >

</ head >

< body >

< form id ="form1" runat ="server" >

< asp:Repeater runat ="server" ID ="objRepeater" >

< HeaderTemplate >

< table >

< tr >

</ tr >

< th >

供应商 </ th >

< th width ="250px" >

供应商2 </ th >

< th >

供应商3 </ th >

< th >

供应商4 </ th >

</ tr > s

</ HeaderTemplate >

< ItemTemplate >

< tr >

< td >

< del >

<% #Eval("CategoryName") %>

</ del >

</ td >

< td >

< asp:Repeater DataSource ='<%#GetChildren() % > ' runat="server">

< ItemTemplate >

< table >

< tr >

< td width ="250px" >

<% #Eval("ProductName") %>

</ td >

< td width ="100px" >

<% #Eval("UnitPrice","{0:c}") %>

</ td >

< td width ="100px" >

< del style ="background-color: Red" >

<% #Eval("UnitsInStock","{0:c}") %>

</ del >

</ td >

</ tr >

</ table >

</ ItemTemplate >

</ asp:Repeater >

</ td >

</ tr >

</ ItemTemplate >

< AlternatingItemTemplate >

</ AlternatingItemTemplate >

< SeparatorTemplate >

</ SeparatorTemplate >

< FooterTemplate >

</ table >

</ FooterTemplate >

</ asp:Repeater >

</ form >

</ body >

</ html >

后代

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

public partial class GridView_Test_GridView8 : System.Web.UI.Page

{

变量

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

GetData(); //加载显示的数据

}

//得到Product表中的数据集

private void GetData()

{

ds = C_Categories.Instance.GetList_Eds(strSql_Categories);

if (ds.Tables[0].Rows.Count > 0)

{

this.objRepeater.DataSource = ds.Tables[0];

//objGridView.DataKeyNames = new string[] { "ProductID" };//主键(注意DataKeyNames 是复数间接告诉我们这里是可以有多个字段即可以是联合主键)

this.objRepeater.DataBind();

}

public DataSet GetChildren()

{

string strSql_Products = "select * from products where categoryid in (select categoryid from categories where categoryid=1)";

return C_Products.Instance.GetList_Eds(strSql_Products);

}

中间操作类方法:

// 常规获得记录

public DataSet GetList_Eds( string strSql)

{

if (strSql != "")

{

return DbHelperSql.ExecuteDataSet(strSql.ToString(), null);

}

else

{

return null;

}

数据库链接:

< appSettings >

< add key = " ConnectionString " value = " Persist Security Info=True;Password=sa;User ID=sa;Initial Catalog=NORTHWIND;Data Source=WANGYONGJUN " />

</ appSettings >

< connectionStrings >

< add name = " NorthwindConnectionString " connectionString = " Persist Security Info=True;Password=sa;User ID=sa;Initial Catalog=NORTHWIND;Data Source=WANGYONGJUN " providerName = " System.Data.SqlClient " />

</ connectionStrings >