MS Access Database

The following table structure should be used to persist data for appointments.

DataTablesStructure_Appointments

The following table structure should be used to persist data for resources.

DataTablesStructure_Resources

NOTE

It is not necessary to define a relation between these tables, because ASPxScheduler simply stores the appropriate Resources.ResourceID field value in the Appointments.ResourceID field if all data fields are mapped correctly.

NOTE

If resource sharing is enabled (the SchedulerStorage.Appointments.ResourceSharing property is set to true), the ResourceID field will hold XML string data, so its data type and size should be changed as required to hold the XML text.

See Also