SHARE
TWEET

Untitled

a guest May 6th, 2019 124 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Moonshot_page_1.Default" %>
  2.  
  3. <!DOCTYPE html>
  4.  
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head runat="server">
  7.     <title></title>
  8.     <style type="text/css">
  9.         .auto-style1 {
  10.             height: 23px;
  11.         }
  12.         .auto-style2 {
  13.             height: 23px;
  14.             width: 200px;
  15.         }
  16.     </style>
  17. </head>
  18. <body>
  19.     <form id="form1" runat="server">
  20.         <div>
  21.             <h2>Sales</h2>
  22.             <br />
  23.             <br />
  24.             <br />
  25.             <br />
  26.             <table style="width:100%;">
  27.                 <tr>
  28.                     <td class="auto-style2">
  29.                         <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">
  30.                             <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
  31.                             <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
  32.                             <OtherMonthDayStyle ForeColor="#999999" />
  33.                             <SelectedDayStyle BackColor="#333399" ForeColor="White" />
  34.                             <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True" Font-Size="12pt" ForeColor="#333399" />
  35.                             <TodayDayStyle BackColor="#CCCCCC" />
  36.                         </asp:Calendar>
  37.                     </td>
  38.                     <td class="auto-style1">
  39.                         <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">
  40.                             <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
  41.                             <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
  42.                             <OtherMonthDayStyle ForeColor="#999999" />
  43.                             <SelectedDayStyle BackColor="#333399" ForeColor="White" />
  44.                             <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True" Font-Size="12pt" ForeColor="#333399" />
  45.                             <TodayDayStyle BackColor="#CCCCCC" />
  46.                         </asp:Calendar>
  47.                     </td>
  48.                 </tr>
  49.             </table>
  50.             <asp:TextBox ID="txtDate1" runat="server"></asp:TextBox>
  51.             <asp:Button ID="btnCalendar" runat="server" Height="22px" OnClick="btnCalendar_Click" Text=". . ." Width="30px" />
  52. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  53.             <asp:TextBox ID="txtDate2" runat="server"></asp:TextBox>
  54.             <asp:Button ID="btnCalendar1" runat="server" Height="22px" OnClick="btnCalendar1_Click" Text=". . ." Width="30px" />
  55. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  56.             <asp:Button ID="btnShow" runat="server" Height="22px" Text="Show" />
  57.             <br />
  58.             <asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataKeyNames="InvoiceID" DataSourceID="SqlDataSource1">
  59.                 <AlternatingRowStyle BackColor="White" />
  60.                 <Columns>
  61.                     <asp:BoundField DataField="InvoiceID" HeaderText="ID" ReadOnly="True" SortExpression="InvoiceID" />
  62.                     <asp:BoundField DataField="InvoiceDate" HeaderText="Date" SortExpression="InvoiceDate" />
  63.                     <asp:BoundField DataField="InvoiceTax" HeaderText="Tax" SortExpression="InvoiceTax" />
  64.                     <asp:BoundField DataField="InvoiceTotal" HeaderText="Total" SortExpression="InvoiceTotal" />
  65.                     <asp:BoundField DataField="StoreID" HeaderText="Store" SortExpression="StoreID" />
  66.                     <asp:BoundField DataField="TransLineID" HeaderText="Transaction ID" SortExpression="TransLineID" />
  67.                     <asp:BoundField DataField="CustomerID" HeaderText="Customer" SortExpression="CustomerID" />
  68.                 </Columns>
  69.                 <EditRowStyle BackColor="#7C6F57" />
  70.                 <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
  71.                 <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
  72.                 <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
  73.                 <RowStyle BackColor="#E3EAEB" />
  74.                 <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
  75.                 <SortedAscendingCellStyle BackColor="#F8FAFA" />
  76.                 <SortedAscendingHeaderStyle BackColor="#246B61" />
  77.                 <SortedDescendingCellStyle BackColor="#D4DFE1" />
  78.                 <SortedDescendingHeaderStyle BackColor="#15524A" />
  79.             </asp:GridView>
  80.         </div>
  81.         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [INVOICE] WHERE (([InvoiceDate] &gt;= @InvoiceDate) AND ([InvoiceDate] &lt;= @InvoiceDate2))">
  82.             <SelectParameters>
  83.                 <asp:ControlParameter ControlID="txtDate1" DbType="Date" Name="InvoiceDate" PropertyName="Text" />
  84.                 <asp:ControlParameter ControlID="txtDate2" DbType="Date" Name="InvoiceDate2" PropertyName="Text" />
  85.             </SelectParameters>
  86.         </asp:SqlDataSource>
  87.     </form>
  88. </body>
  89. </html>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top