ASP.NET中repeater嵌套实现代码(附源码)

发布时间:2022-04-16 发布网站:脚本宝典
脚本宝典收集整理的这篇文章主要介绍了ASP.NET中repeater嵌套实现代码(附源码)脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
1.A,运行效果图
 
1.B,代码(主要代码摘要)
/App_Code/DBConnection.cs
/App_Code/CategoryInfo.cs
复制代码 代码如下:

using System.Collections.Generic;
public class CategoryInfo
{
int categoryid;
string categoryname;
string categorydesc;
IList<Articleinfo> articles;
/// <summary>
/// 1,子嵌套数据
/// </summary>
public IList<ArticleInfo> Articles
{
get { return articles; }
set { articles = value; }
}
public int Categoryid
{
get { return categoryid; }
set { categoryid = value; }
}
public string Categoryname
{
get { return categoryname; }
set { categoryname = value; }
}
public string Categorydesc
{
get { return categorydesc; }
set { categorydesc = value; }
}
public CategoryInfo()
{
}
public CategoryInfo(int categoryid, string categoryname, string categorydesc,IList<ArticleInfo> articles)
{
this.categoryid = categoryid;
this.categoryname = categoryname;
this.categorydesc = categorydesc;
this.articles = articles;
}
}

/App_Code/ArticleInfo.cs
/App_Code/CategoryOPEr.cs
复制代码 代码如下:

using System.Data;
using System.Data.SQLClient;
using System.Collections.Generic;
public class CategoryOper
{
public static IList<CategoryInfo> SelectAll()
{
IList<CategoryInfo> allcate = new List<CategoryInfo>();
string sql = "select category.categoryid,categoryname,categorydesc,id,tITle,author From category inner join article on category.categoryid=article.categoryid order by category.categoryid";
SqlConnection con = new DBConnection().Con;
SqlCommand com = new SqlCommand();
com.Connection = con;
com.COMmandText = sql;
com.CommandType = CommandType.Text;
con.Open();
SqlDataReader sdr = com.ExecuteReader();
int tempcategoryid=0;
CategoryInfo cate=null;
while (sdr.Read())
{
int categoryid=sdr.GetInt32(0);
//如果类别改变则创建一个新的 cate 对象
if(categoryid!=tempcategoryid)
{
cate = new CategoryInfo(sdr.GetInt32(0), sdr.GetString(1), sdr.GetString(2), new List<ArticleInfo>());
allcate.Add(cate);
tempcategoryid = categoryid; //把新类别编号付给标识
}
ArticleInfo art = new ArticleInfo(sdr.GetInt32(3), sdr.GetString(4), sdr.GetString(5));
cate.Articles.Add(art);
}
con.Close();
return allcate;
}
public CategoryOper()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
}

/App_Code/ArticleOper.cs
,6
/Default.aspx
复制代码 代码如下:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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">
<div style="text-align:center">
<asp:Repeater ID="RepCate" runat="server">
<HeaderTemplate>
<table border="1">
<tr>
<td>分类编号</td>
<td>分类名称</td>
<td>分类描述</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#Eval("categoryid") %></td>
<td><%#Eval("categoryname") %></td>
<td><%#Eval("categorydesc") %></td>
</tr>
<tr>
<td>本类新闻</td>
<td colspan="2">
<asp:Repeater ID="RepArticle" runat="server" DataSource='<%#Eval("articles") %>' >
<HeaderTemplate>
<table border="1" style="background-color:#00FF00;">
<tr>
<td>新闻编号</td>
<td>新闻标题</td>
<td>新闻作者</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#Eval("id") %></td>
<td>
<asp:HyperLink ID="Hl1" runat="server" Text='<%#Eval("title") %>' navigateUrl='<%#string.Format("ShowArticle.aspx?id={0}",Eval("id") ) %>' ></asp:HyperLink>
</td>
<td><%#Eval("author") %></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</div>
</form>
</body>
</html>

/Default.aspx.cs
复制代码 代码如下:

using System;
public partial class _Default : System.Web.UI.Page
{
PRivate void BindCategory()
{
RepCate.DataSource = CategoryOper.SelectAll();
RepCate.DataBind();
}
protected void Page_Load(object sender, Eventargs e)
{
if (!IsPostBack)
{
BindCategory();
}
}
}

/web.config
1.C,资源下载

脚本宝典总结

以上是脚本宝典为你收集整理的ASP.NET中repeater嵌套实现代码(附源码)全部内容,希望文章能够帮你解决ASP.NET中repeater嵌套实现代码(附源码)所遇到的问题。

如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。
标签:repeater