Nested repeaters with a single datatable

[Leon Mayne]

If I have a datatable which looks like this:

Record Id, Group Id, Name
1, 1, Test 1
2, 1, Test 2
3, 2, Test 3
4, 3, Test 4

Is it possible to use nested repeaters to group the information by GroupId?
e.g. displaying something like

Group 1
Test 1
Test 2
Group 2
Test 3
Group 3
Test 4

I normally do this with two datatables inside a dataset and link the group
id column, but in this case I only have a flat datatable like the above.

TIA

--
Leon Mayne
http://leon.mvps.org/

[Munna]

Hi

In Item data bound of repeater populate the nested repeater...

http://www.codeproject.com/KB/aspnet...Repeaters.aspx

Best of luck

Munna
www.munna.shatkotha.com
www.munna.shatkotha.com/blog
www.shatkotha.com

[Eliyahu Goldin]

You can, if you wish, try nested repeaters, but you can easily get away with
just one repeater.

Make an itemtemplate as 2 table rows. Put group id in the top row and record
name and id in the second. Make your data source return records sorted by
group id. Databind the repeater. In the PreRender event loop through the
repeater items and hide all group rows except the first for every group id.
That's it.

A big advantage of this way over nested repeaters is that all record rows
will be aligned nicely since they are all in the same table.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Leon Mayne" <le**@rmvme.mvp s.orgwrote in message
news:BC******** *************** ***********@mic rosoft.com...

If I have a datatable which looks like this:

Record Id, Group Id, Name
1, 1, Test 1
2, 1, Test 2
3, 2, Test 3
4, 3, Test 4

Is it possible to use nested repeaters to group the information by
GroupId? e.g. displaying something like

Group 1
Test 1
Test 2
Group 2
Test 3
Group 3
Test 4

I normally do this with two datatables inside a dataset and link the group
id column, but in this case I only have a flat datatable like the above.

TIA

--
Leon Mayne
http://leon.mvps.org/

[zafar iqbal]

XML File
<?xml version="1.0" encoding="utf-8" ?>
<Groups>
<category GroupId="1">
<Name>Test 1</Name>
<Name>Test 2</Name>
</category>
<category GroupId="2">
<Name>Test 3</Name>
</category>
<category GroupId="3">
<Name>Test 4</Name>
</category>
</Groups>
=============== =============== =============== =======
Now I am going to take repeater control on the form-- -----

<asp:Repeater id="CategoryRep eater" runat="server" OnItemDataBound ="CategoryRepea ter_ItemDataBou nd">
<HeaderTemplate >
<h2>Group Information</h2>
<ul>
</HeaderTemplate>
<FooterTemplate >
</ul>
</FooterTemplate>
<ItemTemplate >
<li><b><%# Eval("GroupID") %></b></li>
<%-- adding one more repeater within this item template --%>
<asp:Repeater id="PlayerRepea ter" runat="server">
<HeaderTemplate >
<ul>
</HeaderTemplate>
<FooterTemplate >
</ul>
</FooterTemplate>
<ItemTemplate >
<li><%# Eval("Name_Text ") %></li>
</ItemTemplate>
</asp:Repeater>
</ItemTemplate>
</asp:Repeater>
=============== =============== =============== ====
next proceed to Code Behind File ----------

using System;
using System.Data;
using System.Configur ation;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;

public partial class _Default : System.Web.UI.P age
{
protected void Page_Load(objec t sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds = new DataSet();
ds.ReadXml(MapP ath("./Group.xml"));
CategoryRepeate r.DataSource = ds;
CategoryRepeate r.DataBind();
}
}
protected void CategoryRepeate r_ItemDataBound (object sender, RepeaterItemEve ntArgs e)
{
RepeaterItem item = e.Item;
if (item.ItemType == ListItemType.It em || item.ItemType == ListItemType.Al ternatingItem)
{
Repeater PlayerRepeater = (Repeater)item. FindControl("Pl ayerRepeater");

DataRowView drv = (DataRowView)it em.DataItem;
PlayerRepeater. DataSource = drv.CreateChild View("category_ Name");

// here u can also bind the Child Repeater with DataTable like
//PlayerRepeater. DataSource = datatableName;
PlayerRepeater. DataBind();
}
}
}