This is my first project using the UltraGanttView so I'm still learning.
I've got my database tables for Projects and Tasks set up. Not sure I have the field values accurate. I saw in the help where it lists the fields but not types or sizes.
When I use the DataBinding sample and display tasks, it shows fine. I can modify the tasks and then save back to this table and it so far it seems to save all fields except the Resources. The resource will display on screen, then I save. If i restart the project the resource is not there now where all other changed properties are. I can't view the values in AllProperties in sql since it is binary.
Should the AllProperties field be a different type or be larger? Also, am I supposed to be populating the Resources box in some way for it to match up? If so, how to I load the possible Resources?
Thanks for any help.
There is no way to know the number of bytes that will be required to save a Task because its object graph can vary in size depending on which properties are set and the values to which they are set. For example, the Name property has no restrictions on its length so it was set to a string that is 64K in length, that much additional space would be need to store that property value. Task exposes a Tag property, which could be set to jut about anything, so this could affect the size of the resulting byte array as well.
From what I remember, varbinary supports a variably sized byte array, up to (I think) 8Kb. Usually this is more than sufficient to store a Task.
If someone has info on how big the AllProperties field should be, I can still use that but I found my answer to the Resources issue.
I have to set the available resources as part of the ultraCalendarInfo object Owners property. After that, the names show up in the the Resources list and it will select the ones I saved.