Untitled

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Moonshot_page_1.Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1 {
            height: 23px;
        }
        .auto-style2 {
            height: 23px;
            width: 200px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <h2>Sales</h2>
            <br />
            <br />
            <br />
            <br />
            <table style="width:100%;">
                <tr>
                    <td class="auto-style2">
                        <asp:Calendar ID="clndStart" runat="server" BackColor="White" BorderColor="White" BorderWidth="1px" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="155px" NextPrevFormat="FullMonth" OnSelectionChanged="clndStart_SelectionChanged" Width="195px">
                            <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
                            <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
                            <OtherMonthDayStyle ForeColor="#999999" />
                            <SelectedDayStyle BackColor="#333399" ForeColor="White" />
                            <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True" Font-Size="12pt" ForeColor="#333399" />
                            <TodayDayStyle BackColor="#CCCCCC" />
                        </asp:Calendar>
                    </td>
                    <td class="auto-style1">
                        <asp:Calendar ID="clndEnd" runat="server" BackColor="White" BorderColor="White" BorderWidth="1px" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="155px" NextPrevFormat="FullMonth" OnSelectionChanged="clndEnd_SelectionChanged" Width="195px">
                            <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
                            <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
                            <OtherMonthDayStyle ForeColor="#999999" />
                            <SelectedDayStyle BackColor="#333399" ForeColor="White" />
                            <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True" Font-Size="12pt" ForeColor="#333399" />
                            <TodayDayStyle BackColor="#CCCCCC" />
                        </asp:Calendar>
                    </td>
                </tr>
            </table>
            <asp:TextBox ID="txtDate1" runat="server"></asp:TextBox>
            <asp:Button ID="btnCalendar" runat="server" Height="22px" OnClick="btnCalendar_Click" Text=". . ." Width="30px" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:TextBox ID="txtDate2" runat="server"></asp:TextBox>
            <asp:Button ID="btnCalendar1" runat="server" Height="22px" OnClick="btnCalendar1_Click" Text=". . ." Width="30px" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:Button ID="btnShow" runat="server" Height="22px" Text="Show" />
            <br />
            <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataKeyNames="InvoiceID" DataSourceID="SqlDataSource1">
                <AlternatingRowStyle BackColor="White" />
                <Columns>
                    <asp:BoundField DataField="InvoiceID" HeaderText="ID" ReadOnly="True" SortExpression="InvoiceID" />
                    <asp:BoundField DataField="InvoiceDate" HeaderText="Date" SortExpression="InvoiceDate" />
                    <asp:BoundField DataField="InvoiceTax" HeaderText="Tax" SortExpression="InvoiceTax" />
                    <asp:BoundField DataField="InvoiceTotal" HeaderText="Total" SortExpression="InvoiceTotal" />
                    <asp:BoundField DataField="StoreID" HeaderText="Store" SortExpression="StoreID" />
                    <asp:BoundField DataField="TransLineID" HeaderText="Transaction ID" SortExpression="TransLineID" />
                    <asp:BoundField DataField="CustomerID" HeaderText="Customer" SortExpression="CustomerID" />
                </Columns>
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#E3EAEB" />
                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                <SortedAscendingCellStyle BackColor="#F8FAFA" />
                <SortedAscendingHeaderStyle BackColor="#246B61" />
                <SortedDescendingCellStyle BackColor="#D4DFE1" />
                <SortedDescendingHeaderStyle BackColor="#15524A" />
            </asp:GridView>
        </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [INVOICE] WHERE (([InvoiceDate] &gt;= @InvoiceDate) AND ([InvoiceDate] &lt;= @InvoiceDate2))">
            <SelectParameters>
                <asp:ControlParameter ControlID="txtDate1" DbType="Date" Name="InvoiceDate" PropertyName="Text" />
                <asp:ControlParameter ControlID="txtDate2" DbType="Date" Name="InvoiceDate2" PropertyName="Text" />
            </SelectParameters>
        </asp:SqlDataSource>
    </form>
</body>
</html>