<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
Dim ds As New DataSet()
Protected Sub Page_Load(Src As [Object], E As EventArgs)
'Note: The following two lines of code should be on the same line.
Dim connectionstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("aspnet_calendar.mdb") + ";"
Dim sql As String = "select * from events"
'Create a DataAdapter
Dim da As New OleDbDataAdapter(sql, connectionstring)
'Fill the DataSet (ds)
da.Fill(ds, "events")
End Sub
Protected Sub eventscalendar_DayRender(Src As [Object], E As DayRenderEventArgs)
'use a StringBuilder object for optimized string concatenation
Dim strEvents As New StringBuilder()
strEvents.Append("<span style=""font-size:80%"">")
Dim row As DataRow
For Each row In ds.Tables("events").Rows
Dim eventdate As DateTime = CType(row("eventdate"), DateTime)
If eventdate.Equals(E.Day.Date) Then
strEvents.Append(("<br />" + row("eventtext") + "<br />" + row("startingtime")))
End If
Next row
'Close off the string in the strEvents StringBuilder
strEvents.Append("</span>")
'Add the string to the cell in a LiteralControl
E.Cell.Controls.Add(New LiteralControl(strEvents.ToString()))
End Sub 'eventscalendar_DayRender
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<form runat="server">
<asp:calendar BackColor="#FFFFCC" DayHeaderStyle-BackColor="#FFFFFF" DayStyle-HorizontalAlign="right" Font-Size="16" Height="100%" ID="eventcalendar" NextPrevStyle-BackColor="#99FFCC" runat="server" ShowDayHeader="true" ShowGridLines="true" ShowNextPrevMonth="true" TitleFormat="MonthYear" TitleStyle-ForeColor="#0000FF" WeekendDayStyle-BackColor="#FFCCFF" Width="100%"
OnDayRender="eventscalendar_DayRender" align="center"></asp:calendar>
</form >
</div>
</body>
</html>
asp.net event calendar time display problem
Reply With Quote