Database Structure

5 posts, 0 answers
  1. Philip
    Philip avatar
    54 posts
    Member since:
    Jan 2008

    Posted 13 Feb 2008 Link to this post

    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.
  2. Philip
    Philip avatar
    54 posts
    Member since:
    Jan 2008

    Posted 14 Feb 2008 Link to this post

    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
  3. Peter
    Admin
    Peter avatar
    6637 posts

    Posted 15 Feb 2008 Link to this post

    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
  4. Michael
    Michael avatar
    72 posts
    Member since:
    Mar 2007

    Posted 14 Feb 2011 Link to this post

    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
  5. Peter
    Admin
    Peter avatar
    6637 posts

    Posted 14 Feb 2011 Link to this post

    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.
Back to Top