ASP.NET RSS ASP.NET RSS

Query MS Access data based on week selection on Calendar control in Visual Studio

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Nov 2009
Posts: 1
Reputation: skwilliamson is an unknown quantity at this point 
Solved Threads: 0
skwilliamson skwilliamson is offline Offline
Newbie Poster

Query MS Access data based on week selection on Calendar control in Visual Studio

 
0
  #1
20 Days Ago
I'd like to select a week and pull data based on that week. Data selection starts on line 616.

Thanks.

ASP.NET Syntax (Toggle Plain Text) 
  1. <%@ Page Language="VB" AutoEventWireup="false" Debug="True" %>
  2.  
  3. <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
  4.     Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
  5.  
  6. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  7.  
  8. <html xmlns="http://www.w3.org/1999/xhtml" >
  9. <head runat="server">
  10.     <title>Weekly Reprints</title>
  11. </head>
  12. <body>
  13.     <form id="form1" runat="server">
  14.     <div>
  15.         <table style="width: 736px; height: 456px">
  16.             <tr>
  17.                 <td colspan="3" style="height: 25px; text-align: center">
  18.                     <span style="font-size: 16pt"><strong>Weekly Reprints</strong></span></td>
  19.             </tr>
  20.             <tr>
  21.                 <td colspan="2" style="width: 238px; height: 25px; text-align: left">
  22.                     <asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="Black"
  23.                         DayNameFormat="Shortest" Font-Names="Times New Roman" Font-Size="10pt" ForeColor="Black"
  24.                         Height="144px" NextPrevFormat="FullMonth" TitleFormat="Month" Width="224px" SelectionMode="DayWeek">
  25.                         <SelectedDayStyle BackColor="#CC3333" ForeColor="White" />
  26.                         <SelectorStyle BackColor="#CCCCCC" Font-Bold="True" Font-Names="Verdana" Font-Size="8pt"
  27.                             ForeColor="#333333" Width="1%" />
  28.                         <TodayDayStyle BackColor="#CCCC99" />
  29.                         <OtherMonthDayStyle ForeColor="#999999" />
  30.                         <DayStyle Width="14%" />
  31.                         <NextPrevStyle Font-Size="8pt" ForeColor="White" />
  32.                         <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" ForeColor="#333333"
  33.                             Height="10pt" />
  34.                         <TitleStyle BackColor="Black" Font-Bold="True" Font-Size="13pt" ForeColor="White"
  35.                             Height="14pt" />
  36.                     </asp:Calendar>
  37.                 </td>
  38.                 <td colspan="2" style="height: 25px; text-align: left; width: 249px;">
  39.                     Weekly Total Parts
  40.                 </td>
  41.             </tr>
  42.             <tr>
  43.                 <td colspan="3" style="height: 288px">
  44.                     <table style="border-top-style: outset; border-right-style: outset; border-left-style: outset; border-bottom-style: outset" border="1" frame="border">
  45.                         <tr>
  46.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  47.                             </td>
  48.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  49.                                 2009</td>
  50.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  51.                                 2008</td>
  52.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  53.                                 Goal</td>
  54.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  55.                                 % Actual</td>
  56.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  57.                                 % Goal</td>
  58.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  59.                                 +/- %</td>
  60.                         </tr>
  61.                         <tr>
  62.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  63.                                 Customer Service</td>
  64.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  65.                                 <asp:FormView ID="FormView1" runat="server" DataSourceID="AccessDataSource1">
  66.                                     <EditItemTemplate>
  67.                                         dtDate:
  68.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  69.                                         </asp:TextBox><br />
  70.                                         Ct:
  71.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  72.                                         </asp:TextBox><br />
  73.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  74.                                             Text="Update">
  75.                                         </asp:LinkButton>
  76.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  77.                                             Text="Cancel">
  78.                                         </asp:LinkButton>
  79.                                     </EditItemTemplate>
  80.                                     <InsertItemTemplate>
  81.                                         dtDate:
  82.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  83.                                         </asp:TextBox><br />
  84.                                         Ct:
  85.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  86.                                         </asp:TextBox><br />
  87.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  88.                                             Text="Insert">
  89.                                         </asp:LinkButton>
  90.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  91.                                             Text="Cancel">
  92.                                         </asp:LinkButton>
  93.                                     </InsertItemTemplate>
  94.                                     <ItemTemplate>
  95.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  96.                                     </ItemTemplate>
  97.                                 </asp:FormView>
  98.                             </td>
  99.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  100.                             </td>
  101.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  102.                             </td>
  103.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  104.                             </td>
  105.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  106.                             </td>
  107.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  108.                             </td>
  109.                         </tr>
  110.                         <tr>
  111.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  112.                                 OT/Billing</td>
  113.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  114.                                 <asp:FormView ID="FormView2" runat="server" DataSourceID="AccessDataSource2">
  115.                                     <EditItemTemplate>
  116.                                         dtDate:
  117.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  118.                                         </asp:TextBox><br />
  119.                                         Ct:
  120.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  121.                                         </asp:TextBox><br />
  122.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  123.                                             Text="Update">
  124.                                         </asp:LinkButton>
  125.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  126.                                             Text="Cancel">
  127.                                         </asp:LinkButton>
  128.                                     </EditItemTemplate>
  129.                                     <InsertItemTemplate>
  130.                                         dtDate:
  131.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  132.                                         </asp:TextBox><br />
  133.                                         Ct:
  134.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  135.                                         </asp:TextBox><br />
  136.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  137.                                             Text="Insert">
  138.                                         </asp:LinkButton>
  139.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  140.                                             Text="Cancel">
  141.                                         </asp:LinkButton>
  142.                                     </InsertItemTemplate>
  143.                                     <ItemTemplate>
  144.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  145.                                     </ItemTemplate>
  146.                                 </asp:FormView>
  147.                             </td>
  148.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  149.                             </td>
  150.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  151.                             </td>
  152.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  153.                             </td>
  154.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  155.                             </td>
  156.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  157.                             </td>
  158.                         </tr>
  159.                         <tr>
  160.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  161.                                 Preflight</td>
  162.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  163.                                 <asp:FormView ID="FormView3" runat="server" DataSourceID="AccessDataSource8">
  164.                                     <EditItemTemplate>
  165.                                         dtDate:
  166.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  167.                                         </asp:TextBox><br />
  168.                                         Ct:
  169.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  170.                                         </asp:TextBox><br />
  171.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  172.                                             Text="Update">
  173.                                         </asp:LinkButton>
  174.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  175.                                             Text="Cancel">
  176.                                         </asp:LinkButton>
  177.                                     </EditItemTemplate>
  178.                                     <InsertItemTemplate>
  179.                                         dtDate:
  180.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  181.                                         </asp:TextBox><br />
  182.                                         Ct:
  183.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  184.                                         </asp:TextBox><br />
  185.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  186.                                             Text="Insert">
  187.                                         </asp:LinkButton>
  188.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  189.                                             Text="Cancel">
  190.                                         </asp:LinkButton>
  191.                                     </InsertItemTemplate>
  192.                                     <ItemTemplate>
  193.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  194.                                     </ItemTemplate>
  195.                                 </asp:FormView>
  196.                             </td>
  197.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  198.                             </td>
  199.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  200.                             </td>
  201.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  202.                             </td>
  203.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  204.                             </td>
  205.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  206.                             </td>
  207.                         </tr>
  208.                         <tr>
  209.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  210.                                 Manual Edit</td>
  211.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  212.                                 <asp:FormView ID="FormView4" runat="server" DataSourceID="AccessDataSource4">
  213.                                     <EditItemTemplate>
  214.                                         dtDate:
  215.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  216.                                         </asp:TextBox><br />
  217.                                         Ct:
  218.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  219.                                         </asp:TextBox><br />
  220.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  221.                                             Text="Update">
  222.                                         </asp:LinkButton>
  223.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  224.                                             Text="Cancel">
  225.                                         </asp:LinkButton>
  226.                                     </EditItemTemplate>
  227.                                     <InsertItemTemplate>
  228.                                         dtDate:
  229.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  230.                                         </asp:TextBox><br />
  231.                                         Ct:
  232.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  233.                                         </asp:TextBox><br />
  234.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  235.                                             Text="Insert">
  236.                                         </asp:LinkButton>
  237.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  238.                                             Text="Cancel">
  239.                                         </asp:LinkButton>
  240.                                     </InsertItemTemplate>
  241.                                     <ItemTemplate>
  242.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  243.                                     </ItemTemplate>
  244.                                 </asp:FormView>
  245.                             </td>
  246.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  247.                             </td>
  248.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  249.                             </td>
  250.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  251.                             </td>
  252.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  253.                             </td>
  254.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  255.                             </td>
  256.                         </tr>
  257.                         <tr>
  258.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  259.                                 Proof Center</td>
  260.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  261.                                 <asp:FormView ID="FormView5" runat="server" DataSourceID="AccessDataSource7">
  262.                                     <EditItemTemplate>
  263.                                         dtDate:
  264.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  265.                                         </asp:TextBox><br />
  266.                                         Ct:
  267.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  268.                                         </asp:TextBox><br />
  269.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  270.                                             Text="Update">
  271.                                         </asp:LinkButton>
  272.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  273.                                             Text="Cancel">
  274.                                         </asp:LinkButton>
  275.                                     </EditItemTemplate>
  276.                                     <InsertItemTemplate>
  277.                                         dtDate:
  278.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  279.                                         </asp:TextBox><br />
  280.                                         Ct:
  281.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  282.                                         </asp:TextBox><br />
  283.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  284.                                             Text="Insert">
  285.                                         </asp:LinkButton>
  286.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  287.                                             Text="Cancel">
  288.                                         </asp:LinkButton>
  289.                                     </InsertItemTemplate>
  290.                                     <ItemTemplate>
  291.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  292.                                     </ItemTemplate>
  293.                                 </asp:FormView>
  294.                             </td>
  295.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  296.                             </td>
  297.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  298.                             </td>
  299.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  300.                             </td>
  301.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  302.                             </td>
  303.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  304.                             </td>
  305.                         </tr>
  306.                         <tr>
  307.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  308.                                 Data</td>
  309.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  310.                                 <asp:FormView ID="FormView6" runat="server" DataSourceID="AccessDataSource2">
  311.                                     <EditItemTemplate>
  312.                                         dtDate:
  313.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  314.                                         </asp:TextBox><br />
  315.                                         Ct:
  316.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  317.                                         </asp:TextBox><br />
  318.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  319.                                             Text="Update">
  320.                                         </asp:LinkButton>
  321.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  322.                                             Text="Cancel">
  323.                                         </asp:LinkButton>
  324.                                     </EditItemTemplate>
  325.                                     <InsertItemTemplate>
  326.                                         dtDate:
  327.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  328.                                         </asp:TextBox><br />
  329.                                         Ct:
  330.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  331.                                         </asp:TextBox><br />
  332.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  333.                                             Text="Insert">
  334.                                         </asp:LinkButton>
  335.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  336.                                             Text="Cancel">
  337.                                         </asp:LinkButton>
  338.                                     </InsertItemTemplate>
  339.                                     <ItemTemplate>
  340.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  341.                                     </ItemTemplate>
  342.                                 </asp:FormView>
  343.                             </td>
  344.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  345.                             </td>
  346.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  347.                             </td>
  348.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  349.                             </td>
  350.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  351.                             </td>
  352.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  353.                             </td>
  354.                         </tr>
  355.                         <tr>
  356.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  357.                                 Imprint</td>
  358.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  359.                                 <asp:FormView ID="FormView7" runat="server" DataSourceID="AccessDataSource3">
  360.                                     <EditItemTemplate>
  361.                                         dtDate:
  362.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  363.                                         </asp:TextBox><br />
  364.                                         Ct:
  365.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  366.                                         </asp:TextBox><br />
  367.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  368.                                             Text="Update">
  369.                                         </asp:LinkButton>
  370.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  371.                                             Text="Cancel">
  372.                                         </asp:LinkButton>
  373.                                     </EditItemTemplate>
  374.                                     <InsertItemTemplate>
  375.                                         dtDate:
  376.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  377.                                         </asp:TextBox><br />
  378.                                         Ct:
  379.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  380.                                         </asp:TextBox><br />
  381.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  382.                                             Text="Insert">
  383.                                         </asp:LinkButton>
  384.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  385.                                             Text="Cancel">
  386.                                         </asp:LinkButton>
  387.                                     </InsertItemTemplate>
  388.                                     <ItemTemplate>
  389.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  390.                                     </ItemTemplate>
  391.                                 </asp:FormView>
  392.                             </td>
  393.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  394.                             </td>
  395.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  396.                                 10</td>
  397.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  398.                             </td>
  399.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  400.                             </td>
  401.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  402.                             </td>
  403.                         </tr>
  404.                         <tr>
  405.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  406.                                 Shipping</td>
  407.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  408.                                 <asp:FormView ID="FormView8" runat="server" DataSourceID="AccessDataSource9">
  409.                                     <EditItemTemplate>
  410.                                         dtDate:
  411.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  412.                                         </asp:TextBox><br />
  413.                                         Ct:
  414.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  415.                                         </asp:TextBox><br />
  416.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  417.                                             Text="Update">
  418.                                         </asp:LinkButton>
  419.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  420.                                             Text="Cancel">
  421.                                         </asp:LinkButton>
  422.                                     </EditItemTemplate>
  423.                                     <InsertItemTemplate>
  424.                                         dtDate:
  425.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  426.                                         </asp:TextBox><br />
  427.                                         Ct:
  428.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  429.                                         </asp:TextBox><br />
  430.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  431.                                             Text="Insert">
  432.                                         </asp:LinkButton>
  433.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  434.                                             Text="Cancel">
  435.                                         </asp:LinkButton>
  436.                                     </InsertItemTemplate>
  437.                                     <ItemTemplate>
  438.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  439.                                     </ItemTemplate>
  440.                                 </asp:FormView>
  441.                             </td>
  442.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  443.                             </td>
  444.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  445.                                 11</td>
  446.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  447.                             </td>
  448.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  449.                             </td>
  450.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  451.                             </td>
  452.                         </tr>
  453.                         <tr>
  454.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  455.                                 Misc</td>
  456.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  457.                                 <asp:FormView ID="FormView9" runat="server" DataSourceID="AccessDataSource5">
  458.                                     <EditItemTemplate>
  459.                                         dtDate:
  460.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  461.                                         </asp:TextBox><br />
  462.                                         Ct:
  463.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  464.                                         </asp:TextBox><br />
  465.                                         <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
  466.                                             Text="Update">
  467.                                         </asp:LinkButton>
  468.                                         <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  469.                                             Text="Cancel">
  470.                                         </asp:LinkButton>
  471.                                     </EditItemTemplate>
  472.                                     <InsertItemTemplate>
  473.                                         dtDate:
  474.                                         <asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
  475.                                         </asp:TextBox><br />
  476.                                         Ct:
  477.                                         <asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
  478.                                         </asp:TextBox><br />
  479.                                         <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
  480.                                             Text="Insert">
  481.                                         </asp:LinkButton>
  482.                                         <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
  483.                                             Text="Cancel">
  484.                                         </asp:LinkButton>
  485.                                     </InsertItemTemplate>
  486.                                     <ItemTemplate>
  487.                                         <asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
  488.                                     </ItemTemplate>
  489.                                 </asp:FormView>
  490.                             </td>
  491.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  492.                             </td>
  493.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  494.                             </td>
  495.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  496.                             </td>
  497.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  498.                             </td>
  499.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  500.                             </td>
  501.                         </tr>
  502.                         <tr>
  503.                             <td style="width: 100px; text-align: center; vertical-align: middle;">
  504.                             </td>
  505.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  506.                             </td>
  507.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  508.                             </td>
  509.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  510.                             </td>
  511.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  512.                             </td>
  513.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  514.                             </td>
  515.                             <td style="width: 100px; vertical-align: middle; text-align: center;">
  516.                             </td>
  517.                         </tr>
  518.                     </table>
  519.                 </td>
  520.             </tr>
  521.             <tr>
  522.                 <td rowspan="2" style="width: 100px">
  523.                     &nbsp; &nbsp;&nbsp;&nbsp;
  524.                 </td>
  525.                 <td colspan="2" style="width: 238px">
  526.                     <table>
  527.                         <tr>
  528.                             <td style="width: 100px; background-color: aqua; text-align: center">
  529.                                 Line</td>
  530.                             <td style="width: 100px; background-color: aqua; text-align: center">
  531.                                 Parts</td>
  532.                             <td style="width: 100px; background-color: aqua; text-align: center">
  533.                                 Reprints</td>
  534.                             <td style="width: 100px; background-color: aqua; text-align: center">
  535.                                 %</td>
  536.                         </tr>
  537.                         <tr>
  538.                             <td style="width: 143px">
  539.                                 Ws-Social</td>
  540.                             <td style="width: 100px">
  541.                             </td>
  542.                             <td style="width: 100px">
  543.                             </td>
  544.                             <td style="width: 100px">
  545.                             </td>
  546.                         </tr>
  547.                         <tr>
  548.                             <td style="width: 143px">
  549.                                 Dm-Social</td>
  550.                             <td style="width: 100px">
  551.                             </td>
  552.                             <td style="width: 100px">
  553.                             </td>
  554.                             <td style="width: 100px">
  555.                             </td>
  556.                         </tr>
  557.                         <tr>
  558.                             <td style="width: 143px">
  559.                                 Ws-Xmas</td>
  560.                             <td style="width: 100px">
  561.                             </td>
  562.                             <td style="width: 100px">
  563.                             </td>
  564.                             <td style="width: 100px">
  565.                             </td>
  566.                         </tr>
  567.                         <tr>
  568.                             <td style="width: 143px">
  569.                                 Dm-Xmas</td>
  570.                             <td style="width: 100px">
  571.                             </td>
  572.                             <td style="width: 100px">
  573.                             </td>
  574.                             <td style="width: 100px">
  575.                             </td>
  576.                         </tr>
  577.                         <tr>
  578.                             <td style="width: 143px">
  579.                                 Total</td>
  580.                             <td style="width: 100px">
  581.                             </td>
  582.                             <td style="width: 100px">
  583.                             </td>
  584.                             <td style="width: 100px">
  585.                             </td>
  586.                         </tr>
  587.                     </table>
  588.                 </td>
  589.             </tr>
  590.             <tr>
  591.                 <td colspan="2" style="width: 238px; height: 88px">
  592.                     &nbsp;
  593.                     <table>
  594.                         <tr>
  595.                             <td style="width: 100px; background-color: aqua; text-align: center">
  596.                                 Orders</td>
  597.                             <td style="width: 100px; background-color: aqua; text-align: center">
  598.                                 Reprints</td>
  599.                             <td style="width: 100px; background-color: aqua; text-align: center">
  600.                                 %</td>
  601.                         </tr>
  602.                         <tr>
  603.                             <td style="width: 100px; text-align: center">
  604.                             </td>
  605.                             <td style="width: 100px; text-align: center">
  606.                             </td>
  607.                             <td style="width: 100px; text-align: center">
  608.                             </td>
  609.                         </tr>
  610.                     </table>
  611.                 </td>
  612.             </tr>
  613.         </table>
  614.  
  615.     </div>
  616.         <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/MPD.mdb"
  617.             SelectCommand="SELECT * FROM [qryRpCs1] WHERE ([dtDate] = ?)">
  618.             <SelectParameters>
  619.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  620.                     Type="DateTime" />
  621.             </SelectParameters>
  622.         </asp:AccessDataSource>
  623.         <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/MPD.mdb"
  624.             SelectCommand="SELECT * FROM [qryRpData1] WHERE ([dtDate] = ?)">
  625.             <SelectParameters>
  626.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  627.                     Type="DateTime" />
  628.             </SelectParameters>
  629.         </asp:AccessDataSource>
  630.         <asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/MPD.mdb"
  631.             SelectCommand="SELECT * FROM [qryRpImprint1] WHERE ([dtDate] = ?)">
  632.             <SelectParameters>
  633.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  634.                     Type="DateTime" />
  635.             </SelectParameters>
  636.         </asp:AccessDataSource>
  637.         <asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/MPD.mdb"
  638.             SelectCommand="SELECT * FROM [qryRpMe1] WHERE ([dtDate] = ?)">
  639.             <SelectParameters>
  640.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  641.                     Type="DateTime" />
  642.             </SelectParameters>
  643.         </asp:AccessDataSource>
  644.         <asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/MPD.mdb"
  645.             SelectCommand="SELECT * FROM [qryRpMisc1] WHERE ([dtDate] = ?)">
  646.             <SelectParameters>
  647.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  648.                     Type="DateTime" />
  649.             </SelectParameters>
  650.         </asp:AccessDataSource>
  651.         <asp:AccessDataSource ID="AccessDataSource6" runat="server" DataFile="~/MPD.mdb"
  652.             SelectCommand="SELECT * FROM [qryRpOt1] WHERE ([dtDate] = ?)">
  653.             <SelectParameters>
  654.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  655.                     Type="DateTime" />
  656.             </SelectParameters>
  657.         </asp:AccessDataSource>
  658.         <asp:AccessDataSource ID="AccessDataSource7" runat="server" DataFile="~/MPD.mdb"
  659.             SelectCommand="SELECT * FROM [qryRpPfCtr1] WHERE ([dtDate] = ?)">
  660.             <SelectParameters>
  661.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  662.                     Type="DateTime" />
  663.             </SelectParameters>
  664.         </asp:AccessDataSource>
  665.         <asp:AccessDataSource ID="AccessDataSource8" runat="server" DataFile="~/MPD.mdb"
  666.             SelectCommand="SELECT * FROM [qryRpPreflight1] WHERE ([dtDate] = ?)">
  667.             <SelectParameters>
  668.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  669.                     Type="DateTime" />
  670.             </SelectParameters>
  671.         </asp:AccessDataSource>
  672.         <asp:AccessDataSource ID="AccessDataSource9" runat="server" DataFile="~/MPD.mdb"
  673.             SelectCommand="SELECT * FROM [qryRpShipping1] WHERE ([dtDate] = ?)">
  674.             <SelectParameters>
  675.                 <asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
  676.                     Type="DateTime" />
  677.             </SelectParameters>
  678.         </asp:AccessDataSource>
  679.         <br />
  680.     </form>
  681. </body>
  682. </html>
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



.net 2.0 3.5 ajax alltypeofvideos appliances asp asp.net beginner box browser businesslogiclayer button c# c#gridviewcolumn cac checkbox class compatible confirmationcodegeneration content contenttype countryselector courier dataaccesslayer database datagrid datagridview datalist deployment development dgv dialog dropdownlist dropdownmenu dynamic dynamically edit embeddingactivexcontrol fileuploader fill findcontrol flash flv forms gridview gudi homeedition iis javascript jquery list listbox menu microsoft mouse mssql nameisnotdeclared news novell numerical opera order panelmasterpagebuttoncontrols problem radio ratings redirect registration relationaldatabases reportemail schoolproject search security serializesmo.table sessionvariables silverlight smoobjects software sql sql-server ssl tracking treeview validatedate validation vb.net videos vista visual-studio visualstudio vs2008 web webapplications webarchitecture webdevelopment webprogramming webservice xml xsl
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC