Originally Posted by alykins
Yes I can view the code. I can add a label but I don't understand how to perform a caculation on the query itself. Here's the datasource if it helps?
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:TransfersConnectionString %>"
SelectCommand="SELECT [Player], [Position], [Previous Club] AS Previous_Club, [Transfer Fee] AS Transfer_Fee, [New Club] AS New_Club, [Type], [League], [Window] FROM [Summer_2001_2011] WHERE ([Player] = @Player)">
<asp:ControlParameter ControlID="player" Name="Player" PropertyName="Text"