This is a migrated thread and some comments may be shown as answers.

Database Structure

4 Answers 178 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Philip
Top achievements
Rank 1
Philip asked on 14 Feb 2008, 12:26 AM
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

Sort by
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
    <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> 
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
0
Peter
Telerik team
answered on 15 Feb 2008, 01:39 PM
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
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
0
Peter
Telerik team
answered on 14 Feb 2011, 01:56 PM
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
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.
Tags
Scheduler
Asked by
Philip
Top achievements
Rank 1
Answers by
Philip
Top achievements
Rank 1
Peter
Telerik team
Michael
Top achievements
Rank 1
Share this question
or