Repeater Difficulties

[Philip Townsend]

I have a repeater control that writes an HTML table. Itv needs to
display a header in the first row, then a list of records produced from
a SQL table. The header text is also produced from the SQL query. The
items within the <ItemTemplate> section appear as needed, however, the
header text (which is contained in the <HeaderTemplate> section) does
not. Here is the code sample:

<asp:Repeater ID="rptLinks" Runat="server">
<HeaderTemplate>
<tr><td
colspan="2"><%#DataBinder.Eval(Container.DataItem, "sectionTitle")%></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr style="font-size:8pt">
<td width="10"><img src="images/bullet.gif" vspace="1"
hspace="1"></td>
<td width="140"><a
href="abs.aspx?pgID=<%#DataBinder.Eval(Container.D ataItem,"pageID")%>"><
%#DataBinder.Eval(Container.DataItem,"pageTitle")% ></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>

The repeater object is bound to a Dataset in the following:
String PType = Request.QueryString["pgID"].ToString();
DataSet ds = new DataSet();
SqlConnection cnx = new
SqlConnection(ConfigurationSettings.AppSettings["mainconn"].ToString());
SqlCommand cmd = cnx.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "prLeftNavLinks";
cmd.Parameters.Add("@pageID",SqlDbType.Int);
cmd.Parameters["@pageID"].Value = Int32.Parse(PType);

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds,"links");
rptLinks.DataSource = ds;
rptLinks.DataBind();

da.Dispose();
cmd.Dispose();
cnx.Dispose();

Any ideas as to why the headertext does not render in the repeater
control? Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Michael]

Well if you want an idea, I don't belive you can use that
<%#DataBinder.Eval(Container.DataItem,"sectionTitl e")%> stuff in the
HeaderTemplate, because there is no data there to be looked at yet. What I
believe you can do is pop an asp control in there and set that value from
code.

<HeaderTemplate>
<tr><td
colspan="2"><asp:label id="mySectionLabel" runat="server" /></td>
</tr>
</HeaderTemplate>

then somewhere down in your code

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds,"links");
mySectionLabel.text = ds.myDataTableName(0).sectionTitle 'Typed Dataset
mySectionLabel.text = ds.tables("myDataTableName").rows(0)("sectionTitle ")
'unTyped Dataset (I think that syntax is correct..I took one look at that
and learned how to use typed Datasets :) )
rptLinks.DataSource = ds;
rptLinks.DataBind();


"Philip Townsend" <pt*******@v1tech.com> wrote in message
news:Oj**************@TK2MSFTNGP11.phx.gbl...

I have a repeater control that writes an HTML table. Itv needs to
display a header in the first row, then a list of records produced from
a SQL table. The header text is also produced from the SQL query. The
items within the <ItemTemplate> section appear as needed, however, the
header text (which is contained in the <HeaderTemplate> section) does
not. Here is the code sample:

<asp:Repeater ID="rptLinks" Runat="server">
<HeaderTemplate>
<tr><td
colspan="2"><%#DataBinder.Eval(Container.DataItem, "sectionTitle")%></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr style="font-size:8pt">
<td width="10"><img src="images/bullet.gif" vspace="1"
hspace="1"></td>
<td width="140"><a
href="abs.aspx?pgID=<%#DataBinder.Eval(Container.D ataItem,"pageID")%>"><
%#DataBinder.Eval(Container.DataItem,"pageTitle")% ></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>

The repeater object is bound to a Dataset in the following:
String PType = Request.QueryString["pgID"].ToString();
DataSet ds = new DataSet();
SqlConnection cnx = new
SqlConnection(ConfigurationSettings.AppSettings["mainconn"].ToString());
SqlCommand cmd = cnx.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "prLeftNavLinks";
cmd.Parameters.Add("@pageID",SqlDbType.Int);
cmd.Parameters["@pageID"].Value = Int32.Parse(PType);

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds,"links");
rptLinks.DataSource = ds;
rptLinks.DataBind();

da.Dispose();
cmd.Dispose();
cnx.Dispose();

Any ideas as to why the headertext does not render in the repeater
control? Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!