[RESOLVED] Templatefield with label (adding asecending numbers)

[ggodwin]

Please see the below link.
Notice the far left column does not have text in the header and also notice that the ranking starts with number "0". Rather than "1".

If anyone can see my code and see where I went wrong I would be greatly appreciated.

I would like the header to have the work "Rank" in the fist row of the first column.

http://visualboxscore.com/cfb/team_s...l_offense.aspx

<%@ Page Language="C#" MasterPageFile="~/AppMaster.master" Title="visualboxscore - CFB Total Offense" %>
<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="mainCopy">
<script runat="server">

  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {

        if (e.Row.RowType == DataControlRowType.DataRow)
        {

            int row = e.Row.RowIndex + (GridView1.PageSize * GridView1.PageIndex);

            ((Label)e.Row.FindControl("Rank")).Text = row.ToString();


        } 
    }

</script>
<div class="container" style="height: 80%">
    <br>
    <asp:GridView ID="GridView1" AllowSorting="true" runat="server" DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound"
      SkinID="booksSkin" AutoGenerateColumns="False" HorizontalAlign="Left">
      <Columns>
        <asp:TemplateField>
            <itemtemplate>
                <asp:Label ID="Rank" runat="server" Text="Rank"></asp:Label>
            </itemtemplate>
        </asp:TemplateField>
        <asp:BoundField HeaderText="Team" DataField="team" ItemStyle-HorizontalAlign="Center"/>
        <asp:BoundField HeaderText="Plays/Gm" DataField="total_plays" ItemStyle-HorizontalAlign="Center" SortExpression="total_plays" />
        <asp:BoundField HeaderText="Total Yards" DataField="total_yds" ItemStyle-HorizontalAlign="Center" SortExpression="total_yds" />
        <asp:BoundField HeaderText="YPP" DataField="yds_per_play" ItemStyle-HorizontalAlign="Center" SortExpression="yds_per_play" />
      </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      SelectCommand="SELECT [team], [total_plays], [total_yds], [yds_per_play], [punt_no], [total_first_downs] FROM [team_avg] ORDER BY [total_yds] DESC"
       ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>" />
</div>
</asp:Content>

[mendhak]

Because .NET is 0 based, you need to increment it by +1.

 ((Label)e.Row.FindControl("Rank")).Text = (row+1).ToString();

To get "Rank" into your header, use the HeaderTemplate.

<asp:TemplateField>
            <HeaderTemplate>
                Rank
            </HeaderTemplate>
            <itemtemplate>
                <asp:Label ID="Rank" runat="server" Text="Rank"></asp:Label>
            </itemtemplate>
        </asp:TemplateField>

[ggodwin]

Thank you!!!!

[mendhak]

No problem, add resolved please.

[ggodwin]

What would be the best way to get the text in the header to align in the center?

[mendhak]

Try
<HeaderStyle HorizontalAlign="Center" />

(Just before the <HeaderTemplate>)

[ggodwin]

menhak,
Does this command work for the entire header? or just the column that has the cell that is using the header template?

I am assuming I should change all my headers to follow this same command. Does this question make sense?

[Harsh Gupta]

menhak,
Does this command work for the entire header? or just the column that has the cell that is using the header template?

I am assuming I should change all my headers to follow this same command. Does this question make sense?

That command will work for this particular column only. In order to add effect to all columns, add <HeaderStyle> just before you start <Column> nodes.

<asp:GridView id="something" runat="server" ...>

<HeaderStyle HorizontalAlign="Center" />

<Columns>
...
</Columns>
</asp:GridView>

[ggodwin]

Thanks Harsh this thread is resolved