<center> <asp:Calendar runat="server" id="Calendar1" BackColor="White" BorderColor="Black" BorderStyle="Double" FirstDayOfWeek="Monday" ForeColor="Black" DayNameFormat="Full"> <WeekendDayStyle Font-Bold="True" /> </asp:Calendar></center><br /><br /><center> <asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="Rate_Source" BackColor="White" BorderColor="Black" BorderStyle="Double"> <AlternatingRowStyle BackColor="#99CCFF" BorderColor="Black" /> <Columns> <asp:boundfield DataField="FXCurrency" HeaderText="Currency" SortExpression="FXCurrency"> </asp:boundfield> <asp:boundfield DataField="DateTimeUpdated" HeaderText="Date & Time Updated" SortExpression="DateTimeUpdated"> </asp:boundfield> <asp:boundfield DataField="CashBuy" HeaderText="Cash Buy" SortExpression="CashBuy"> </asp:boundfield> </Columns> <HeaderStyle BackColor="#66CCFF" /> </asp:GridView></center><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"> <SelectParameters> <asp:controlparameter ControlID="Calendar1" PropertyName="SelectedDate" Name="newparameter" /> </SelectParameters></asp:SqlDataSource>