I'm going to create a custom provider since I'm going to have multiple schedules available based on the current GroupID that is logged in. I'd like to create the structure to hold the Scheduler information in my existing SQL Express database. Is there a document somewhere on the site that lays out the table structure that Scheduler needs? Tables/Columns Types, etc...Thanks.
4 Answers, 1 is accepted
0
Philip
Top achievements
Rank 1
answered on 14 Feb 2008, 11:40 PM
I found the table definition in a previous post, so I'm getting there. I think I understand the basic structure of how the whole thing works, but I need a little help connecting the dots on setting this up.
So...from what I understand, there are 3 parts to getting this working.
1. web.config - setup my provider
the type obviously points to the MyDbSchedulerProvider.cs file...and this file needs to reside in my App_Code directory, correct? The connectionStringName - should that point to the connection string I have setup for my database?
2. MyDbSchedulerProvider.cs - just dump this file in App_Code and I'm good to go?
3. webpage.aspx - This where I actually put the <Telerik:RadScheduler> code and reference my ProviderName, making sure that I set ReadOnly="false".
Of course I'll need to modify the sql commands in MyDbSchedulerProvider.cs to match my tables/columns.
Is that it...do I have it correct? Hmmm...sounds a lot easier now that I've written out the steps :) hahaha
So...from what I understand, there are 3 parts to getting this working.
1. web.config - setup my provider
<telerik.web.ui> |
<radScheduler defaultAppointmentProvider="Integrated"> |
<appointmentProviders> |
<add name="SchedulerData" type="Telerik.Web.Examples.Scheduler.MyDbSchedulerProvider" |
connectionStringName="RadSchedulerConnectionString" |
persistChanges="true" /> |
</appointmentProviders> |
</radScheduler> |
</telerik.web.ui> |
2. MyDbSchedulerProvider.cs - just dump this file in App_Code and I'm good to go?
3. webpage.aspx - This where I actually put the <Telerik:RadScheduler> code and reference my ProviderName, making sure that I set ReadOnly="false".
Of course I'll need to modify the sql commands in MyDbSchedulerProvider.cs to match my tables/columns.
Is that it...do I have it correct? Hmmm...sounds a lot easier now that I've written out the steps :) hahaha
0
Hi Philip,
Yes, that's pretty much it. For more details, you can refer to the following resources:
RadScheduler Providers - Overview
Database driven Custom Provider
Database Scheduler Provider online example
Feel free to contact us if you need assistance with implementing this case. We will be happy to help you.
Regards,
Peter
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Yes, that's pretty much it. For more details, you can refer to the following resources:
RadScheduler Providers - Overview
Database driven Custom Provider
Database Scheduler Provider online example
Feel free to contact us if you need assistance with implementing this case. We will be happy to help you.
Regards,
Peter
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Michael
Top achievements
Rank 1
answered on 14 Feb 2011, 10:02 AM
Hi
I'll use Data binding (DataSource property) with custom Advanced form embeded into a RadWindow - customized editing form(s); also I want to alter database structure in this manner:
- In Appointments table: will transform ID type from int to Guid; therefore Appointment business object will have the ID as Guid so is there any issue with binding Scheduler with custom objects? Should I espect unusual behavior in displaying information in RadScheduler?
Thanks
Dan
I'll use Data binding (DataSource property) with custom Advanced form embeded into a RadWindow - customized editing form(s); also I want to alter database structure in this manner:
- In Appointments table: will transform ID type from int to Guid; therefore Appointment business object will have the ID as Guid so is there any issue with binding Scheduler with custom objects? Should I espect unusual behavior in displaying information in RadScheduler?
Thanks
Dan
0
Hi Dan,
There shouldn't be any problems with custom appointment business objects. You can refer to this demo for example. If however, you get any issues, feel free to contact us.
All the best,
Peter
the Telerik team
There shouldn't be any problems with custom appointment business objects. You can refer to this demo for example. If however, you get any issues, feel free to contact us.
All the best,
Peter
the Telerik team
Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.