Home Unanswered Active Tags New Question

Set up a calendar using VB.Net and a SQL Server database

I have been trying now for two weeks to set up a calendar using VB.Net and a SQL Server database. I can display events from my database - that's exciting. I have not been able to update the calendar or navigate to a new month. I tried following the tutorials on binding the Navigator to the calendar, etc. No luck. The tutorials are written with VB, but they use SQLite. I don't know how to convert that to SQL Server nor how to convert the working Demo from C# to VB. It this point I feel stuck and am ready to throw in the towel. Any suggestions?

Asked by Efraim Lezak 1 year ago.
Replies
throw in the towel
Comment posted by Random Dude With A Top Hat That Likes Pizza, Chickens and even more!!!11 1 year ago.
Im kidding.
Can you explain a little more what your problem is exactly? Post some example of code that doesn't work and we'll try to help you.
Comment posted by Random Dude With A Top Hat That Likes Pizza, Chickens and even more!!!11 1 year ago.

It's good to know someone cares. I'll hold onto the towel for now. Ok here's some code that works to display events from my SqlDataSource. I would be very happy if it can do two more things: update an event and navigate to another month. Clicking on theDayPilotMonth does nothing. For navigation I tried both the Javascript and the DayPilotNavigator. The Navigator moves but not the DayPilotMonth.

<script runat="server">

Sub DayPilotMonth1_Command(ByVal Sender As Object, ByVal E As DayPilot.Web.Ui.Events.CommandEventArgs) Handles DayPilotMonth1.Command

Select Case E.Command
case "next"
DayPilotMonth1.StartDate = DayPilotMonth1.StartDate.AddMonths(1)

case "previous"
DayPilotMonth1.StartDate = DayPilotMonth1.StartDate.AddMonths(-1)

case "today"
DayPilotMonth1.StartDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1)

End Select


DayPilotMonth1.DataBind()
DayPilotMonth1.Update()
End Sub

</script>

<div id="toolbar" style="width:100%">
<a href="javascript:dpm.commandCallBack('previous');">&#x25c4;</a>
<a href="javascript:dpm.commandCallBack('next');">&#x25ba;</a>
<a href="javascript:dpm.commandCallBack('this');">This Month</a>
</div>


<DayPilot:DayPilotMonth ID="DayPilotMonth1" runat="server" BackColor="#FFFFD5"
BorderColor="Black" CellHeaderBackColor="" CellHeaderFontColor="#000000"
CssClass=""
DataSourceID="SqlDataSourceDP"
DataTextField="name" DataValueField="id" StartDate="2010-08-01" DataStartField="eventstart" DataEndField="eventend"
EventStartTime="false"
EventEndTime="false"
EventBackColor="White"
ClientObjectName="dpm"
OnCommand="DayPilotMonth1_Command"
EventBorderColor="Black" EventFontColor="#000000" EventTimeFontColor="Gray"
HeaderBackColor="#ECE9D8" HeaderFontColor="#000000" InnerBorderColor="#CCCCCC"
NonBusinessBackColor="#FFF4BC" WeekStarts="Auto"
Width="100%" />
<DayPilot:DayPilotNavigator ID="DayPilotNavigator1" runat="server" BackColor="#FFFFD5"
BoundDayPilotID="DayPilotMonth1"
ShowMonths="3"
CssClassPrefix="navigator_silver_"
DataSourceID="SqlDataSourceDP"
DataTextField="name" DataValueField="id" StartDate="2010-08-01" DataStartField="eventstart" DataEndField="eventend"
EventStartTime="false"
EventEndTime="false"
Width="100%" />

<asp:SqlDataSource ID="SqlDataSourceDP" runat="server"
ConnectionString="<%$ ConnectionStrings:KLConnectionString %>"
SelectCommand="SELECT [id], [name], [eventstart], [eventend] FROM [event]"
UpdateCommand="UPDATE [event] SET [name] = @name, [eventstart] = @eventstart, [eventend] = @eventend WHERE [id] = @id">
<UpdateParameters>
<asp:Parameter Name="id" Type="Object" />
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="eventstart" Type="Datetime" />
<asp:Parameter Name="eventend" Type="Datetime" />
</UpdateParameters>
</asp:SqlDataSource>

Thanks.

Comment posted by Efraim Lezak 1 year ago.

How about this one. Its using the MS SQL server

http://www.daypilot.org/tutorial-calendar-sqlserver.html

/M

Comment posted by MONO 1 year ago.

It took some work to get past a few error messages, and it works! Thanks.

I replaced ScriptManager with

<AjaxToolkit:ToolkitScriptManager ID="smContent" EnablePageMethods="true" EnableScriptGlobalization="true" EnableScriptLocalization="true" EnablePartialRendering="true" CombineScripts="false" runat="server"></AjaxToolkit:ToolkitScriptManager>

On the VB side I needed to add two lines at the top:

Imports System.Data
Imports System.Data.SqlClient

Comment posted by Efraim Lezak 1 year ago.
Yay!
Comment posted by Bbq 1 year ago.
New Reply
This reply is
Your name (optional):

DayPilot for ASP.NET WebForms, DayPilot for ASP.NET MVC, DayPilot for Java