hey,
i am making a baseball website that displays players stats throughout
thier career. i want to be able to show a total row at the bottom of
the grid view, i have read tutorials on how to do it for one, but when
i try to use more than one i get confused. here is what i have now
<asp:GridView ID="GridView1" runat="server" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="Stats"
OnRowDataBound="detailsGridView_RowDataBound">
<Columns>
<asp:BoundField DataField="Year"
HeaderText="Year" SortExpression="Year" />
<asp:BoundField DataField="Team"
HeaderText="Team" SortExpression="Team" />
<asp:BoundField DataField="League"
HeaderText="League"
SortExpression="League" />
<asp:BoundField DataField="W" HeaderText="W"
SortExpression="W" />
<asp:BoundField DataField="L" HeaderText="L"
SortExpression="L" />
<asp:BoundField DataField="G" HeaderText="G"
SortExpression="G" />
<asp:BoundField DataField="GS" HeaderText="GS"
SortExpression="GS" />
<asp:BoundField DataField="CG" HeaderText="CG"
SortExpression="CG" />
<asp:BoundField DataField="ShO"
HeaderText="ShO" SortExpression="ShO" />
<asp:BoundField DataField="SV" HeaderText="SV"
SortExpression="SV" />
<asp:BoundField DataField="OutsPitched"
HeaderText="OutsPitched"
SortExpression="OutsPitched" />
<asp:BoundField DataField="H" HeaderText="H"
SortExpression="H" />
<asp:BoundField DataField="ER" HeaderText="ER"
SortExpression="ER" />
<asp:BoundField DataField="HR" HeaderText="HR"
SortExpression="HR" />
<asp:BoundField DataField="BB" HeaderText="BB"
SortExpression="BB" />
<asp:BoundField DataField="K" HeaderText="K"
SortExpression="K" />
<asp:BoundField DataField="OBA"
HeaderText="OBA" SortExpression="OBA" />
<asp:BoundField DataField="ERA"
HeaderText="ERA" SortExpression="ERA" />
<asp:BoundField DataField="IBB"
HeaderText="IBB" SortExpression="IBB" />
<asp:BoundField DataField="WP" HeaderText="WP"
SortExpression="WP" />
<asp:BoundField DataField="HB" HeaderText="HB"
SortExpression="HB" />
<asp:BoundField DataField="BK" HeaderText="BK"
SortExpression="BK" />
<asp:BoundField DataField="BFP"
HeaderText="BFP" SortExpression="BFP" />
<asp:BoundField DataField="GF" HeaderText="GF"
SortExpression="GF" />
<asp:BoundField DataField="R" HeaderText="R"
SortExpression="R" />
</Columns>
</asp:GridView>
<br />
<asp:SqlDataSource ID="Stats" runat="server"
ConnectionString="<%$ ConnectionStrings:BaseballDatabase %>"
ProviderName="<%$
ConnectionStrings:BaseballDatabase.ProviderName %>"
SelectCommand="SELECT * FROM [PitchingStats] WHERE ([PlayerID] = ?)
ORDER BY [Year]">
<SelectParameters>
<asp:QueryStringParameter Name="PlayerID"
QueryStringField="playerID" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
right now they are just bound fields, but i think i need to use
template fields but then i start getting confused. any help would be
greatly appreciated. thanks
