Possible New Feature

Hi Rolando,

As I understand you have your own database with events data and you need to display them in the CalendarControl.

In this case you cannot use DataBase data provider which is shipped with the Calendar control because it is designed to work with Access DB and expects some predefined DB tables structure.

We already got some questions about how to connect calendar control to custom database. To make this process more universal data providers mechanism will be reorganized in the next versions.

But for the current version (and for the future to) you can use another technique described below.
It is quite easy and straightforward but for big amounts of events in the database it will have not very good performance results (load speed and memory usage).
But for a few thousands events it works fine. Of course, in the new versions this problem will be fixed.


So, to use your custom database, you have to write your own function to populate CalendarControl from the DB and catch events like EventAdded, EventChanged, EventDeleted to update your DB contents when user makes some changes in the calendar.

Look at the example below which illustrates this idea:

void Populate(LPCTSTR pcszUserName)
{
    pWndCalendar->GetDataProvider()-& gt;RemoveAllEvents();
    
    // Read events for the specified user from your DB here
    // objEventsCollection - recordset object with events data

    while( !objEventsCollection->GetbEOF() )
    {
        DWORD dwEventID = <objEventsCollection("EventID")> or XTP_CALENDAR_UNKNOWN_EVENT_ID;

        CXTPCalendarEventPtr ptrEvent = CXTPCalendarData::CreateNewEvent(dwEventID);
               
        ptrEvent->SetStartTime = ...
        ...

        pWndCalendar->GetDataProvider().AddEvent(ptrEvent);
    }

    pWndCalendar->Populate();
}

Also you can advise to the following calendar notifications to update database:
    XTP_NC_CALENDAREVENTWASADDED
    XTP_NC_CALENDAREVENTWASDELETED
    XTP_NC_CALENDAREVENTWASCHANGED

Please see also Calendar Demo project and documentation how to work with them.

Also, look at the similar questions at http://forum.codejock.com/forum_posts.asp?TID=2735&PN=1

--
WBR,
Serge

Rolando,

Yes, it's clear what do you need. We are preparing almost identical piece of functionality for further releases. Currently you can only filter events coming into Calendar control in some customized manner. One of possible solutions is what I've mentioned above.

--
WBR,
Serge

Rolando,

That should be your code, not a patch to Calendar sources. And you can insert it anywhere as you like , even inside Calendar class.

It can be a member of class derived from calendar, or a member of your view or dialog class, or even a global function, if this is convenient for you.

--
WBR,
Serge