User828474466 posted
The ASPX PAge is as follows :
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="runrate.aspx.vb" Inherits="UserDetails.runrate" %>
<%@ Register assembly="System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" namespace="System.Web.UI.DataVisualization.Charting" tagprefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
<script type="text/javascript">
function popupCalendar() {
var dateField = document.getElementById('dateField');
// toggle the div
if (dateField.style.display == 'none')
dateField.style.display = 'block';
else
dateField.style.display = 'none';
}
</script>
<script type="text/javascript">
function popupCalendar2() {
var dateField2 = document.getElementById('dateField2');
// toggle the div
if (dateField2.style.display == 'none')
dateField2.style.display = 'block';
else
dateField2.style.display = 'none';
}
</script>
<style type="text/css">
.style1
{
text-align: left;
}
.style3
{
width: 100%;
}
.style4
{
font-family: Arial, Helvetica, sans-serif;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div class="style1">
<div class="style1">
<div class="style1">
<br />
</div>
</div>
<div class="style1">
From: <asp:TextBox ID="Date1" runat="server"></asp:TextBox>
<img src="\images\cal.jpg" onclick="popupCalendar()" />
To: <asp:TextBox ID="Date2" runat="server"></asp:TextBox>
<img src="\images\cal.jpg" onclick="popupCalendar2()" />
<div id="dateField" style="display:none;">
<asp:Calendar id="CalDate" OnSelectionChanged="calDate_SelectionChanged" Runat="server" />
</div>
<div id="datefield2" style="display:none;">
<asp:Calendar id="CalDate2" OnSelectionChanged="calDate2_SelectionChanged" Runat="server" />
</div>
<br class="style4" />
<br />
<br />
<table class="style3">
<tr>
<td>
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
<tr style="background-color: #FFFBD6;color: #333333;">
<td>
<asp:Label ID="Installed_ByLabel" runat="server"
Text='<%# Eval("Installed_By") %>' />
</td>
<td>
<asp:Label ID="Expr2Label" runat="server" Text='<%# Eval("Expr2") %>' />
</td>
<td>
<asp:Label ID="Expr1Label" runat="server" Text='<%# Eval("Expr1") %>' />
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr style="background-color: #FAFAD2;color: #284775;">
<td>
<asp:Label ID="Installed_ByLabel" runat="server"
Text='<%# Eval("Installed_By") %>' />
</td>
<td>
<asp:Label ID="Expr2Label" runat="server" Text='<%# Eval("Expr2") %>' />
</td>
<td>
<asp:Label ID="Expr1Label" runat="server"
Text='<%# Eval("Expr1") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<EmptyDataTemplate>
<table runat="server"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;">
<tr>
<td>
No data was returned.</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr style="">
<td>
<asp:Button ID="InsertButton" runat="server" CommandName="Insert"
Text="Insert" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Clear" />
</td>
<td>
<asp:TextBox ID="Installed_ByTextBox" runat="server"
Text='<%# Bind("Installed_By") %>' />
</td>
<td>
<asp:TextBox ID="Expr2TextBox" runat="server"
Text='<%# Bind("Expr2") %>' />
</td>
<td>
<asp:TextBox ID="Expr1TextBox" runat="server"
Text='<%# Bind("Expr1") %>' />
</td>
</tr>
</InsertItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table ID="itemPlaceholderContainer" runat="server" border="1"
style="background-color: #FFFFFF;border-collapse: collapse;border-color: #999999;border-style:none;border-width:1px;font-family: Verdana, Arial, Helvetica, sans-serif;">
<tr runat="server" style="background-color: #FFFBD6;color: #333333;">
<th runat="server">
Count</th>
<th runat="server">
Engineer</th>
<th runat="server">
Date</th>
</tr>
<tr ID="itemPlaceholder" runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server"
style="text-align: center;background-color: #FFCC66;font-family: Verdana, Arial, Helvetica, sans-serif;color: #333333;">
</td>
</tr>
</table>
</LayoutTemplate>
<EditItemTemplate>
<tr style="background-color: #FFCC66;color: #000080;">
<td>
<asp:Button ID="UpdateButton" runat="server" CommandName="Update"
Text="Update" />
<asp:Button ID="CancelButton" runat="server" CommandName="Cancel"
Text="Cancel" />
</td>
<td>
<asp:TextBox ID="Installed_ByTextBox" runat="server"
Text='<%# Bind("Installed_By") %>' />
</td>
<td>
<asp:TextBox ID="Expr2TextBox" runat="server"
Text='<%# Bind("Expr2") %>' />
</td>
<td>
<asp:TextBox ID="Expr1TextBox" runat="server"
Text='<%# Bind("Expr1") %>' />
</td>
</tr>
</EditItemTemplate>
<SelectedItemTemplate>
<tr style="background-color: #FFCC66;font-weight: bold;color: #000080;">
<td>
<asp:Label ID="Installed_ByLabel" runat="server"
Text='<%# Eval("Installed_By") %>' />
</td>
<td>
<asp:Label ID="Expr2Label" runat="server" Text='<%# Eval("Expr2") %>' />
</td>
<td>
<asp:Label ID="Expr1Label" runat="server"
Text='<%# Eval("Expr1") %>' />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
</td>
<td>
<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1" Height="388px"
Width="473px">
<Legends>
<asp:Legend Name="Legend1" Title="Pc Run Rate">
</asp:Legend>
</Legends>
<Series>
<asp:Series Name="Series1" XValueMember="Expr2" YValueMembers="Installed_By"
ChartType="StackedColumn" Legend="Legend1" LegendText="Pc Installs"
IsValueShownAsLabel="True">
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1">
<Area3DStyle Enable3D="True" />
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
</td>
</tr>
</table>
<br />
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:refreshConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:refreshConnectionString2.ProviderName %>"
SelectCommand="SELECT COUNT(*) AS Installed_By, Installed_By AS Expr2, Date_Installed AS Expr1 FROM Buildprocess WHERE (Date_Installed BETWEEN @Date1 and @Date2
GROUP BY Installed_By, Date_Installed">
</asp:SqlDataSource>
<div class="style1">
<br />
<br />
</div>
</div>
</form>
</body>
</html>
The Code PAge is :
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Sub calDate_SelectionChanged(ByVal sender As Object, ByVal e As EventArgs)
Dim dt1 As DateTime
dt1 = Convert.ToDateTime(CalDate.SelectedDate.ToString("d"))
Date1.Text = dt1
End Sub
Sub calDate2_SelectionChanged(ByVal sender As Object, ByVal e As EventArgs)
Dim dt2 As DateTime
dt2 = Convert.ToDateTime(CalDate2.SelectedDate.ToString("d"))
Date2.Text = dt2
End Sub
Cheers Andy
Access Database SQL Query between two dates Datagrid
