<asp:Calendar runat="server" id="Calendar1" BackColor="White" BorderColor="Black" BorderStyle="Double" FirstDayOfWeek="Monday" ForeColor="Black" DayNameFormat="Full">
<WeekendDayStyle Font-Bold="True" />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="Rate_Source" BackColor="White" BorderColor="Black" BorderStyle="Double">
<AlternatingRowStyle BackColor="#99CCFF" BorderColor="Black" />
<asp:boundfield DataField="FXCurrency" HeaderText="Currency" SortExpression="FXCurrency">
<asp:boundfield DataField="DateTimeUpdated" HeaderText="Date & Time Updated" SortExpression="DateTimeUpdated">
<asp:boundfield DataField="CashBuy" HeaderText="Cash Buy" SortExpression="CashBuy">
<HeaderStyle BackColor="#66CCFF" />
<asp:SqlDataSource runat="server" ID="Rate_Source" ConnectionString="Data Source=;Initial Catalog=;User ID=;Password=" ProviderName="" SelectCommand="SELECT [FXCurrency],[DateTimeUpdated],ROUND([CashBuy],2) as Cashbuy FROM [FXRate2] WHERE(CONVERT(CHAR(10),[DateTimeUpdated],120)=@newparameter) ORDER BY [DateTimeUpdated] desc">
<asp:controlparameter ControlID="Calendar1" PropertyName="SelectedDate" Name="newparameter" />