Hi,

I am binding a datalist from sql. In sql i have a table with the following fields:
prodID,ProductName, CategoryName

I want my datalist to look as follows (but it doesn't):
CategoryNameA =Header
Product 1 =ItemTemplate
Product 2
-------------
CategoryNameB=Headertemplate (from database)
Product 3 =ItemTemplate
Product 4

However, I get the following result:
CategoryNameA =Header
Product 1 =ItemTemplate
Product 2
Product 3
Product 4

I have a datalist such as the following:
<asp:datalist id="PicList" runat="server" Font-Names="Arial" Font-Size="Smaller">
<HeaderTemplate>
<%# dt.Rows(0).Item( "CategoryName") %>
</HeaderTemplate>
<ItemTemplate>
<TABLE BORDER='0' CELLSPACING='0' CELLPADDING='0'>
<TR>
<TD dir='rtl' valign="top">
<%# ImgExist(Container.DataItem("ProductName")) %>
</TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:datalist>


 Dim cmd As SqlCommand

        cmd = objConn.CreateCommand

        cmd.CommandText = "SELECT * FROM CATEGORY INNER JOIN Product ON IDCATEGORY=CATID ORDER BY CATEGORYNAME"



        Dim da As New SqlDataAdapter(cmd)

        dt = New DataTable("ads")



        da.Fill(dt)



        If dt.Rows.Count = 0 Then

            PicList.Visible = False

        Else : PicList.Visible = True

        End If

        PicList.DataSource = dt

        PicList.DataBind()