Hello,

Is there any solutions to solve my doubt?

Hi su su,

I think you can use custom column for Scheduler database. You can use Account as resources but the column like ResourceName VARCHAR(255), Description VARCHAR(255), Location VARCHAR(255), ResourceColor VARCHAR(255) as resources of your Scheduler (remember you should check for the data type). Altough you can substitute some column like ResourceName to Name or Description to Description like in your database. But still, it's better if you make new column for this matter so your database won't messed up because the scheduler. You can do this to Category table.

After that, you can made a dataset for this table then you can add bind this dataset. You must handle Insert, Update, and Delete for this matter. If you're using ASP.NET product, you can handle SQL statement for Insert, Update, and Delete statement when you configure ISDataSource.

For references, please visit: http://www.intersoftpt.com/Support/WebScheduler/Tutorial/Text/Adding-custom-fields-in-WebScheduler-using-Extensibility-feature/

Hope this helps.

Regards,
Bernard

Hi Bernard,

Thank you for your reply, But I use UXScheduler to do this . ...... my platform is Silverlight...

Hi Bernard,

I did as a sample  below the attachment, it can't run the UxScheduler  successfully, could you please have a look  for me   ,thank you very much!

Hi su su,

It will be the same for UXScheduler. After you binding the model to view, you must mapping the column inside database to each MemberPath. For example, ResourceNameMemberPath="Name". Please consider about the data type for each column in your database with its property. The data type will be the same as in WebScheduler.

I have an sample that can show you how to make Schedule Application using DevForce. I made it using Intersoft ClientUI MVVM Scheduling Application (DevForce). I made this sample using this walkthough  If you're using custom column, in the end of this walkthough, you can map each MemberPath for each column like I mentioned above. You can download the sample here.

Hope this helps.

Regards,
Bernard

Hi Bernard,

I have successfully made a Scheduler sample for custom columns, thank you very much!