Link to MS Access
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=15349
Printed Date: 11 May 2024 at 9:50pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Link to MS Access
Posted By: visualise01
Subject: Link to MS Access
Date Posted: 12 October 2009 at 1:10pm
Does anyone have any samples linking to a MS Access Database with VB. NET frontend?
|
Replies:
Posted By: SuperMario
Date Posted: 13 October 2009 at 2:49pm
|
Our VB.NET calendar sample shows exactly how to do this. Run the sample, choose File->Open and select MS Access Database.
|
Posted By: visualise01
Date Posted: 16 October 2009 at 2:29pm
There must be a simpler example availabe - I have used the code supplied with the examples, but cant get it to work. All I want to do it be able to add new calendar events to the calendar and database and have existing events load into the calendar from the database, also have recurring work.
I dont want options to pick datasource.
|
Posted By: SuperMario
Date Posted: 16 October 2009 at 3:52pm
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\Program Files\Codejock Software\ActiveX\Xtreme SuitePro ActiveX v13.2.0\Samples\Calendar\events.mdb';"
If CalendarControl.DataProvider.IsOpen Then
CalendarControl.DataProvider.Save()
End If
CalendarControl.SetDataProvider(strConnectionString)
If Not CalendarControl.DataProvider.Open Then
If Not CalendarControl.DataProvider.Create Then
System.Diagnostics.Debug.Assert(False, "")
End If
End If
CalendarControl.Populate()
|
|