Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select week in calendar control to query data from Access

Status
Not open for further replies.
skwilliamson

skwilliamson

Technical User
Nov 3, 2009
1
US
I'd like to select a week on my calendar control and pull data based on that week.

<%@ Page Language="VB" AutoEventWireup="false" Debug="True" %>

<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
<html xmlns=" >
<head runat="server">
<title>Weekly Reprints</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="width: 736px; height: 456px">
<tr>
<td colspan="3" style="height: 25px; text-align: center">
<span style="font-size: 16pt"><strong>Weekly Reprints</strong></span></td>
</tr>
<tr>
<td colspan="2" style="width: 238px; height: 25px; text-align: left">
<asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="Black"
DayNameFormat="Shortest" Font-Names="Times New Roman" Font-Size="10pt" ForeColor="Black"
Height="144px" NextPrevFormat="FullMonth" TitleFormat="Month" Width="224px" SelectionMode="DayWeek">
<SelectedDayStyle BackColor="#CC3333" ForeColor="White" />
<SelectorStyle BackColor="#CCCCCC" Font-Bold="True" Font-Names="Verdana" Font-Size="8pt"
ForeColor="#333333" Width="1%" />
<TodayDayStyle BackColor="#CCCC99" />
<OtherMonthDayStyle ForeColor="#999999" />
<DayStyle Width="14%" />
<NextPrevStyle Font-Size="8pt" ForeColor="White" />
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" ForeColor="#333333"
Height="10pt" />
<TitleStyle BackColor="Black" Font-Bold="True" Font-Size="13pt" ForeColor="White"
Height="14pt" />
</asp:Calendar>
</td>
<td colspan="2" style="height: 25px; text-align: left; width: 249px;">
Weekly Total Parts
</td>
</tr>
<tr>
<td colspan="3" style="height: 288px">
<table style="border-top-style: outset; border-right-style: outset; border-left-style: outset; border-bottom-style: outset" border="1" frame="border">
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
2009</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
2008</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Goal</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
% Actual</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
% Goal</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
+/- %</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Customer Service</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
<asp:FormView ID="FormView1" runat="server" DataSourceID="AccessDataSource1">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
OT/Billing</td>
<td style="width: 100px; text-align: center; vertical-align: middle;">
<asp:FormView ID="FormView2" runat="server" DataSourceID="AccessDataSource2">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Preflight</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView3" runat="server" DataSourceID="AccessDataSource8">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Manual Edit</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView4" runat="server" DataSourceID="AccessDataSource4">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Proof Center</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView5" runat="server" DataSourceID="AccessDataSource7">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Data</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView6" runat="server" DataSourceID="AccessDataSource2">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Imprint</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView7" runat="server" DataSourceID="AccessDataSource3">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
10</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Shipping</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView8" runat="server" DataSourceID="AccessDataSource9">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
11</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
Misc</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
<asp:FormView ID="FormView9" runat="server" DataSourceID="AccessDataSource5">
<EditItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
dtDate:
<asp:TextBox ID="dtDateTextBox" runat="server" Text='<%# Bind("dtDate") %>'>
</asp:TextBox><br />
Ct:
<asp:TextBox ID="CtTextBox" runat="server" Text='<%# Bind("Ct") %>'>
</asp:TextBox><br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="CtLabel" runat="server" Text='<%# Bind("Ct") %>'></asp:Label>
</ItemTemplate>
</asp:FormView>
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
<tr>
<td style="width: 100px; text-align: center; vertical-align: middle;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
<td style="width: 100px; vertical-align: middle; text-align: center;">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td rowspan="2" style="width: 100px">
&nbsp; &nbsp;&nbsp;&nbsp;
</td>
<td colspan="2" style="width: 238px">
<table>
<tr>
<td style="width: 100px; background-color: aqua; text-align: center">
Line</td>
<td style="width: 100px; background-color: aqua; text-align: center">
Parts</td>
<td style="width: 100px; background-color: aqua; text-align: center">
Reprints</td>
<td style="width: 100px; background-color: aqua; text-align: center">
%</td>
</tr>
<tr>
<td style="width: 143px">
Ws-Social</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 143px">
Dm-Social</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 143px">
Ws-Xmas</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 143px">
Dm-Xmas</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 143px">
Total</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
<td style="width: 100px">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" style="width: 238px; height: 88px">
&nbsp;
<table>
<tr>
<td style="width: 100px; background-color: aqua; text-align: center">
Orders</td>
<td style="width: 100px; background-color: aqua; text-align: center">
Reprints</td>
<td style="width: 100px; background-color: aqua; text-align: center">
%</td>
</tr>
<tr>
<td style="width: 100px; text-align: center">
</td>
<td style="width: 100px; text-align: center">
</td>
<td style="width: 100px; text-align: center">
</td>
</tr>
</table>
</td>
</tr>
</table>

</div>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpCs1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpData1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpImprint1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpMe1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpMisc1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource6" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpOt1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource7" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpPfCtr1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource8" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpPreflight1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AccessDataSource9" runat="server" DataFile="~/MPD.mdb"
SelectCommand="SELECT * FROM [qryRpShipping1] WHERE ([dtDate] = ?)">
<SelectParameters>
<asp:ControlParameter ControlID="Calendar1" Name="dtDate" PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:AccessDataSource>
<br />
</form>
</body>
</html>
 
Sort by date Sort by votes
The first thing I am going to tell you is to get rid of the DataSource control. They may seem like a good idea, but cause problems whenever you try to do something more complicated than they were designed for. Also, you canno't debug them.
Next, to get the values of the selected week, you need to use: System.Web.UI.WebControls.SelectedDatesCollection. I am not sure what version of Access you are using but I would use a stored procedure if you could and pass in a string of dates from the collection.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AhmedAzizBarbary
  • Locked
  • Question
How to read data response body after success login razor page ?
Replies
0
Views
412
AhmedAzizBarbary
AhmedAzizBarbary
Makumbi256
  • Locked
  • Question
How to make days vertical and grid view editable using asp.net vb
Replies
0
Views
293
Makumbi256
Makumbi256
G12Consult
  • Locked
  • Question
Retrieve data from JSON
Replies
1
Views
350
gmmastros
gmmastros
AhmedAzizBarbary
  • Locked
  • Question
How to pass list of checkboxes not checked on page model razor page?
Replies
0
Views
444
AhmedAzizBarbary
AhmedAzizBarbary
a6green
  • Locked
  • Question
How to configure AT&T / Avaya Definity G3 incoming ISDN trunk
Replies
2
Views
407
a6green
a6green

Part and Inventory Search

Sponsor

Back
Top