Codejock Developer Community : DataProvider http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 13 May 2026 04:19:39 +0000 Sun, 06 Nov 2005 07:40:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=2735 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[DataProvider : I agree Kind Regards René BechmannRBC...]]> http://forum.codejock.com/forum_posts.asp?TID=2735&PID=9449&title=dataprovider#9449 Author: RBCDATA
Subject: 2735
Posted: 06 November 2005 at 7:40am

I agree

Kind Regards

René Bechmann
RBC Data

]]> Sun, 06 Nov 2005 07:40:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=2735&PID=9449&title=dataprovider#9449 <![CDATA[DataProvider : Thanks Serge, I&#039;ve seen...]]> http://forum.codejock.com/forum_posts.asp?TID=2735&PID=8236&title=dataprovider#8236 Author: flauzer
Subject: 2735
Posted: 19 August 2005 at 11:19am

Thanks Serge,

I've seen Microsoft Access database (so Event, RecurrencePattern,......and other tables)...It would be nice if calendar control will update directly in SQL server. I will also try to investigate around XML feature....

I think that support for SQL will be very useful.....

Thanks.

 

 

 

 

 

]]> Fri, 19 Aug 2005 11:19:42 +0000 http://forum.codejock.com/forum_posts.asp?TID=2735&PID=8236&title=dataprovider#8236 <![CDATA[DataProvider : Hi! To make it working with SQL...]]> http://forum.codejock.com/forum_posts.asp?TID=2735&PID=8230&title=dataprovider#8230 Author: sserge
Subject: 2735
Posted: 19 August 2005 at 8:35am

Hi!

To make it working with SQL server, you should add your own code for saving/retrieving events from/to the database. To do so in VB, you could write own function to populate CalendarControl from the DB
and catch events like EventAdded, EventChanged, EventDeleted to update your array.

Look at the example which illustrates this idea. It's a code mixed with pieces of pseudo-code. Simple copy/paste wouldn't work ;) 


Sub Populate()

      objCalendar.DataProvider.Remov eAllEvents

  

     ' There should be some your collection with events data

     ' In your case this is most likely a recordset which you get from the SQL server

     ' So, iterate this collection

     For each objEvent in objEventsCollection 

            Set objCalendarEvent = objCalendar.DataProvider.CreateEventEx(objEvent.ID)



            objCalendarEvent.StartTime = ...

            ...



            objCalendar.DataProvider.AddEvent  objCalendarEvent    

     Next

  

     objCalendar.Populate

End Sub



Private Sub CalendarControl_EventChanged(ByVal EventID As Long)

     Set objCalendarEvent = objCalendar.DataProvider.GetEvent(EventID)

  

     ' update data in your collection from objCalendarEvent

     ...

End Sub


Let me know if you have more questions on it.

In further versions we'll slightly change this mechanism and will add SQL Server connection sample.

--
Best regards,
Serge]]> Fri, 19 Aug 2005 08:35:30 +0000 http://forum.codejock.com/forum_posts.asp?TID=2735&PID=8230&title=dataprovider#8230 <![CDATA[DataProvider : Is there a way to use DataProviderto...]]> http://forum.codejock.com/forum_posts.asp?TID=2735&PID=8180&title=dataprovider#8180 Author: flauzer
Subject: 2735
Posted: 17 August 2005 at 9:15am

Is there a way to use DataProvider to SQL server 2000 ? (ie Provider=sqloledb ... ?  )

Have you plan this option?

Thanks

 

 

 



Edited by flauzer]]> Wed, 17 Aug 2005 09:15:53 +0000 http://forum.codejock.com/forum_posts.asp?TID=2735&PID=8180&title=dataprovider#8180