Bind schedulecontrol

[Paurnima]

Hi,
I am using schedule control to save appointments in sql server database.
I have a data-table which contains all saved appointment records.
I want to assign that data-table records to the schedule control.
How to do this?Please give me any suggestion.
I am using .Net-framework- 3.5 and sync fusion version-10.403.0.53.



Thank You and Regards,
Paurnima.

[Venkatesh Sundaram]

Hi Paurnima,

Thank you for using Syncfusion products.

Please refer the below sample link. In this sample, we are using the data table from the MS Access to the schedule control.

By using MDB_ScheduleDataProvider  class you can assign the data table to the ScheduleControl. See the code:

MDB_ScheduleDataProvider scheduleProvider = new MDB_ScheduleDataProvider("..\\..\\ScheduleData.mdb");

scheduleControl1.DataSource = scheduleProvider;
this.scheduleControl1.ScheduleType = ScheduleViewType.Month;


Sample for your reference:
http://www.syncfusion.com/downloads/support/directtrac/133232/ze/CS-940128338

Please let me know if this helps.

Regards,
Venkat.

[Paurnima]

Thanks for reply.
I am using sqlserver-2008 database.
You provided the sample using MS Access database.
Could you please upgrade the sample into sqlserver database.
Thank You and Regards,




Paurnima.

[Venkatesh Sundaram]

Hi Paurnima,

Sorry for the inconvenience.


We have tried to bind the SQL database to the Schedule control but we are unable to get the proper suggestion for the reported scenario. Can you provide a simple sample with the SQL? This will help us determine how best we can help you.


Regards,
Venkat.