DataList and ItemTemplate

[Paul]

I am trying to use a DataList and the ItemTemplate.

I am binding the Datalist to a SQL query that gives me a list of Items with
a Parent Category.

I want to loop through all the items, but only print the Parent Category
once, regardless of how many child items are in it.

So my perfect output would look something like:

Category A
Item 1
Item 2
Item 3

Category B
Item 1

Category C
Item 1
Item 2
Can I use the ItemTemplate to produce this type of output?

I know that I can easily get this type of output
Category A
Item 1

Category A
Item 2

Category A
Item 3

Category B
Item 1

Category B
Item 2

Category C
Item 1
....

It does not appear that I can embed ASP code within the ItemTemplate tags?
If I try, then it says that I have not declared the Container object, which
holds the Item and Category values.

Am I missing something easy here?

[brians[MCSD]]

Hello Paul,

If I were you, I'd look at the ItemDataBound event for the datalist. I do
something similar for a blog I keep. I want to list the blog entry and
any/all comments:

blogentry1
comment1
comment2
blogentry2
comment3
comment4

While it's not the exact same situation as you have since the comments are
uniquely tied to a blogentry, it's similar.

In the ItemDataBound event, you can get your categoryid and then look up any
item(s) which may belong to it. Something along these lines:
=-=-=-=-=-=-
if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
Label lbl = (System.Web.UI. WebControls.Hyp erLink)
e.Item.FindCont rol("lblCategor y");
if (lbl != null)
{
... find any items which match this category and list them
}

}
=-=-=-=-=-
A deeper explanation of the ItemDataBound event with a sample can be found at
http://www.codeproject.com/aspnet/ItemCreated.asp. Or do a search in google:
http://www.google.com/search?hl=en&q=itemdatabound for more.

--
brians
http://www.limbertech.com
"Paul" wrote:

I am trying to use a DataList and the ItemTemplate.

I am binding the Datalist to a SQL query that gives me a list of Items with
a Parent Category.

I want to loop through all the items, but only print the Parent Category
once, regardless of how many child items are in it.

So my perfect output would look something like:

Category A
Item 1
Item 2
Item 3

Category B
Item 1

Category C
Item 1
Item 2
Can I use the ItemTemplate to produce this type of output?

I know that I can easily get this type of output
Category A
Item 1

Category A
Item 2

Category A
Item 3

Category B
Item 1

Category B
Item 2

Category C
Item 1
...

It does not appear that I can embed ASP code within the ItemTemplate tags?
If I try, then it says that I have not declared the Container object, which
holds the Item and Category values.

Am I missing something easy here?

[Elton W]

Hi Paul,

The better way to achieve it is to use another list control (DataList,
DataGrid, or Repeater) nested in the DataList. In outer DataList, it loops
thru Categories. And in the inner list control, it binds a data source with
Items associated with a Category.

HTH

Elton Wang
"Paul" wrote:

I am trying to use a DataList and the ItemTemplate.

I am binding the Datalist to a SQL query that gives me a list of Items with
a Parent Category.

I want to loop through all the items, but only print the Parent Category
once, regardless of how many child items are in it.

So my perfect output would look something like:

Category A
Item 1
Item 2
Item 3

Category B
Item 1

Category C
Item 1
Item 2
Can I use the ItemTemplate to produce this type of output?

I know that I can easily get this type of output
Category A
Item 1

Category A
Item 2

Category A
Item 3

Category B
Item 1

Category B
Item 2

Category C
Item 1
...

It does not appear that I can embed ASP code within the ItemTemplate tags?
If I try, then it says that I have not declared the Container object, which
holds the Item and Category values.

Am I missing something easy here?

[Paul]

Thanks for this.

Is there an code example of nested DataLists anyplace? A code example of a
nested DataList that uses a value from the outer Datalist?


"Elton W" wrote:

Hi Paul,

The better way to achieve it is to use another list control (DataList,
DataGrid, or Repeater) nested in the DataList. In outer DataList, it loops
thru Categories. And in the inner list control, it binds a data source with
Items associated with a Category.

HTH

Elton Wang
"Paul" wrote:

I am trying to use a DataList and the ItemTemplate.

I am binding the Datalist to a SQL query that gives me a list of Items with
a Parent Category.

I want to loop through all the items, but only print the Parent Category
once, regardless of how many child items are in it.

So my perfect output would look something like:

Category A
Item 1
Item 2
Item 3

Category B
Item 1

Category C
Item 1
Item 2
Can I use the ItemTemplate to produce this type of output?

I know that I can easily get this type of output
Category A
Item 1

Category A
Item 2

Category A
Item 3

Category B
Item 1

Category B
Item 2

Category C
Item 1
...

It does not appear that I can embed ASP code within the ItemTemplate tags?
If I try, then it says that I have not declared the Container object, which
holds the Item and Category values.

Am I missing something easy here?

[Elton W]

Following code is not tested:

<asp:DataList id="CategoryLis t" runat="server" RepeatDirection =Vertical>
<ItemTemplate >
Category: <%# DataBinder.Eval (Container.Data Item,
"Category_Field _Name") %><br>
<asp:DataList ID="ItemList" Runat=server
RepeatDirection =Vertical>
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item,
"Item_Field_Nam e") %>
</ItemTemplate>
</asp:DataList>
</ItemTemplate>
</asp:DataList>
In CategoryList_It emDataBound

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
// Suppose you use DataTable, or DataView, or DataSet as Data Source
DataRowView drv = (DataRowView)e. Item.DataItem;
string Category = drv["Category_Field _Name"].ToString();
DataTable itemTable = GetItems(Catego ry);
DataList itemList = (DataList)e.Ite m.FindControl(" ItemList");
itemList.DataSo urce = itemTable;
itemList.DataBi nd();
}

HTH

Elton Wang

"Paul" wrote:

Thanks for this.

Is there an code example of nested DataLists anyplace? A code example of a
nested DataList that uses a value from the outer Datalist?


"Elton W" wrote:

Hi Paul,

The better way to achieve it is to use another list control (DataList,
DataGrid, or Repeater) nested in the DataList. In outer DataList, it loops
thru Categories. And in the inner list control, it binds a data source with
Items associated with a Category.

HTH

Elton Wang
"Paul" wrote:

I am trying to use a DataList and the ItemTemplate.

I am binding the Datalist to a SQL query that gives me a list of Items with
a Parent Category.

I want to loop through all the items, but only print the Parent Category
once, regardless of how many child items are in it.

So my perfect output would look something like:

Category A
Item 1
Item 2
Item 3

Category B
Item 1

Category C
Item 1
Item 2
Can I use the ItemTemplate to produce this type of output?

I know that I can easily get this type of output
Category A
Item 1

Category A
Item 2

Category A
Item 3

Category B
Item 1

Category B
Item 2

Category C
Item 1
...

It does not appear that I can embed ASP code within the ItemTemplate tags?
If I try, then it says that I have not declared the Container object, which
holds the Item and Category values.

Am I missing something easy here?

[Paul]

Thank you for this. I may be getting closer.

The problem with this is that each DataList is databinded to a SQL query
(which you do not show here). The DataSource is a DataReader object.

The inner DataList is binded to a SQL query that uses a value from the outer
DataList. (i.e. select * from items where category = x).

So I am not sure how the inner DataList could be dynamic in that sense.

Also, I use VB.Net, not C. So I am unsure what C's "In" statement equivalent
is in VB?

TIA.

"Elton W" wrote:

Following code is not tested:

<asp:DataList id="CategoryLis t" runat="server" RepeatDirection =Vertical>
<ItemTemplate >
Category: <%# DataBinder.Eval (Container.Data Item,
"Category_Field _Name") %><br>
<asp:DataList ID="ItemList" Runat=server
RepeatDirection =Vertical>
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item,
"Item_Field_Nam e") %>
</ItemTemplate>
</asp:DataList>
</ItemTemplate>
</asp:DataList>
In CategoryList_It emDataBound

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
// Suppose you use DataTable, or DataView, or DataSet as Data Source
DataRowView drv = (DataRowView)e. Item.DataItem;
string Category = drv["Category_Field _Name"].ToString();
DataTable itemTable = GetItems(Catego ry);
DataList itemList = (DataList)e.Ite m.FindControl(" ItemList");
itemList.DataSo urce = itemTable;
itemList.DataBi nd();
}

HTH

Elton Wang

"Paul" wrote:

Thanks for this.

Is there an code example of nested DataLists anyplace? A code example of a
nested DataList that uses a value from the outer Datalist?


"Elton W" wrote:

Hi Paul,

The better way to achieve it is to use another list control (DataList,
DataGrid, or Repeater) nested in the DataList. In outer DataList, it loops
thru Categories. And in the inner list control, it binds a data source with
Items associated with a Category.

HTH

Elton Wang
"Paul" wrote:

> I am trying to use a DataList and the ItemTemplate.
>
> I am binding the Datalist to a SQL query that gives me a list of Items with
> a Parent Category.
>
> I want to loop through all the items, but only print the Parent Category
> once, regardless of how many child items are in it.
>
> So my perfect output would look something like:
>
> Category A
> Item 1
> Item 2
> Item 3
>
> Category B
> Item 1
>
> Category C
> Item 1
> Item 2
>
>
> Can I use the ItemTemplate to produce this type of output?
>
> I know that I can easily get this type of output
> Category A
> Item 1
>
> Category A
> Item 2
>
> Category A
> Item 3
>
> Category B
> Item 1
>
> Category B
> Item 2
>
> Category C
> Item 1
> ...
>
> It does not appear that I can embed ASP code within the ItemTemplate tags?
> If I try, then it says that I have not declared the Container object, which
> holds the Item and Category values.
>
> Am I missing something easy here?
>

[Elton W]

In CategoryList_It emDataBound

If e.Item.ItemType = ListItemType.It em Or e.Item.ItemType =
ListItemType.Al ternatingItem Then
' Since you use DataReader as datasource, using
' System.Data.Com mon.DbDataRecor d
Dim record As System.Data.Com mon.DbDataRecor d =
CType(e.Item.Da taItem, System.Data.Com mon.DbDataRecor d)
Dim strCategory As String = record
..Item("Categor y_Field_Name"). ToString
Dim itemTable As DataTable = GetItems("Selec t Item From tabl_name
Where Category = '" + strCategory + "'")
Dim itemList As Datalist = CType(e.Item.Fi ndControl("Item List"),
DataList)
itemList.DataSo urce = itemTable
itemList.DataBi nd()
End If
"Paul" wrote:

Thank you for this. I may be getting closer.

The problem with this is that each DataList is databinded to a SQL query
(which you do not show here). The DataSource is a DataReader object.

The inner DataList is binded to a SQL query that uses a value from the outer
DataList. (i.e. select * from items where category = x).

So I am not sure how the inner DataList could be dynamic in that sense.

Also, I use VB.Net, not C. So I am unsure what C's "In" statement equivalent
is in VB?

TIA.

"Elton W" wrote:

Following code is not tested:

<asp:DataList id="CategoryLis t" runat="server" RepeatDirection =Vertical>
<ItemTemplate >
Category: <%# DataBinder.Eval (Container.Data Item,
"Category_Field _Name") %><br>
<asp:DataList ID="ItemList" Runat=server
RepeatDirection =Vertical>
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item,
"Item_Field_Nam e") %>
</ItemTemplate>
</asp:DataList>
</ItemTemplate>
</asp:DataList>
In CategoryList_It emDataBound

if (e.Item.ItemTyp e == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
// Suppose you use DataTable, or DataView, or DataSet as Data Source
DataRowView drv = (DataRowView)e. Item.DataItem;
string Category = drv["Category_Field _Name"].ToString();
DataTable itemTable = GetItems(Catego ry);
DataList itemList = (DataList)e.Ite m.FindControl(" ItemList");
itemList.DataSo urce = itemTable;
itemList.DataBi nd();
}

HTH

Elton Wang

"Paul" wrote:

Thanks for this.

Is there an code example of nested DataLists anyplace? A code example of a
nested DataList that uses a value from the outer Datalist?


"Elton W" wrote:

> Hi Paul,
>
> The better way to achieve it is to use another list control (DataList,
> DataGrid, or Repeater) nested in the DataList. In outer DataList, it loops
> thru Categories. And in the inner list control, it binds a data source with
> Items associated with a Category.
>
> HTH
>
> Elton Wang
>
>
> "Paul" wrote:
>
> > I am trying to use a DataList and the ItemTemplate.
> >
> > I am binding the Datalist to a SQL query that gives me a list of Items with
> > a Parent Category.
> >
> > I want to loop through all the items, but only print the Parent Category
> > once, regardless of how many child items are in it.
> >
> > So my perfect output would look something like:
> >
> > Category A
> > Item 1
> > Item 2
> > Item 3
> >
> > Category B
> > Item 1
> >
> > Category C
> > Item 1
> > Item 2
> >
> >
> > Can I use the ItemTemplate to produce this type of output?
> >
> > I know that I can easily get this type of output
> > Category A
> > Item 1
> >
> > Category A
> > Item 2
> >
> > Category A
> > Item 3
> >
> > Category B
> > Item 1
> >
> > Category B
> > Item 2
> >
> > Category C
> > Item 1
> > ...
> >
> > It does not appear that I can embed ASP code within the ItemTemplate tags?
> > If I try, then it says that I have not declared the Container object, which
> > holds the Item and Category values.
> >
> > Am I missing something easy here?
> >