Hi,

Do you plan to use custom items to store this additional data?

Regards,
Meppy

Unfortunately this is not possible due to how data-binding currently works - when the calendar is saved to the database all existing database records are discarded and recreated anew. Therefore any extra information is lost.

A possible solution would be to use a custom item type that will store these extra fields in its custom properties. When saving and loading from the database the additional information will be saved/loaded along with the other item properties. To make this work I had to make some adjustments to the control (more specifically, I had to enable it to load custom items during data-binding, which was not previously possible). A sample illustrating how this is done can be downloaded from the link below (the updated control dlls are included in the sample):

https://mindfusion.eu/_samples/_sample_DataBinding.zip

The sample uses a custom item (MyItem) with a single property (Test), which is intended to store a previously defined field 'test' in the database. The point of interest is the SetupItemProperties method. Along with the standard item properties it adds a new mapping between the new database field and the items' custom property:

this._calendar.ItemsDataPropertyMap.Add(new BoundProperty("test", "Test", PropertyType.Value)); 

Also note that the new ItemsDataPropertyMap.DestinationItemType property is set to typeof(MyItem) to instruct the data-binding engine what type of items to create when loading from the database.

However, using custom items can cause some implications, as outlined in the following topic:
http://www.mindfusion.eu/onlinehelp/planner/index.htm?Tutorial_4.htm

Let me know if this helps.

Regards,
Meppy

On a second thought, before taking the long road, you can try saving the custom information through the item's Tag property. You may need to change the type of the Tag database field because it loads as string from the default type. If this works you can completely ignore my previous post and continue on with your version of the control.

Regards,
Meppy

Sorry Meppy, you say the save to method discards  the data and creates it anew. How is this done? Is there a way to add a WHERE clause to this?? For example "DELETE FROM Item WHERE Tag Like '" & value & "'".

Okay....I am unsure as to how this is done but am sure I will figure it out.

Thanks.