Bind Scheduler with SQL DataBase

[manoj]

Hi,

I am having a application which works with students and teachers using SQL Database.

Now! i want to implement the Task scheduler using RAD Scheduler control.
I want to use the SQL Database as data source for RAD Scheduler control.

Can you help me that how can i modify my database, so that i can attach that with Rad Scheduler control.
I didnt found anything in online help(may be i am missing something).
Please Let me know if anyone have any idea or sample or any link of online help which describe the above problem.

Thanks in advance

[Peter]

Hello Manoj,

I am not sure exactly what you want to achieve and what problems you experience. Could you please be more specific?

I suggest  you review the topics in the Data Binding chapter in the help. Also, you may need to use resources - please, see the topic on Working with Resources.

I hope these articles help you get started.


Best wishes,
Peter
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[manoj]

Hi there,

Thnks for so fast reply.

I just want to use the Scheduler with SQL Database as resource. If you have any sample or any helpfile which describe the use of Scheduker with Database, please let me know.

In online help of Scheduler, there is a chapter that tell that we can use database as resource. but that is not sufficient.

Thanks in advance.

[Peter]

Hi Manoj,

Please, refer to the Defining Resources online example. It shows how to use create resources from SessionDataSources, but you can easily tweak the code to use SqlDataSource. The main idea is clearly illustrated in the example.

Let us know if you experience any difficulties.

All the best,
Peter
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[manoj]

Hi,
I used the manual help for binding the Database as Resource to Scheduler.
I created MyDbSchedulerProvider.vb and DbSchedulerProviderBase.vb as mentioned and added the resource entry in the web.config file.
But now, i am getting run time error that "Cannt create object of DbSchedulerProviderBase".

Here is the part of Web.Config file

<configSections>
        <sectionGroup name="telerik.web.ui">
            <section name="radScheduler"
                     type="Telerik.Web.UI.RadSchedulerConfigurationSection,
                   Telerik.Web.UI, PublicKeyToken=121fae78165ba3d4"
                     allowDefinition="MachineToApplication"/>
        </sectionGroup>

    </configSections>
   
    
    <telerik.web.ui>
        <radScheduler defaultAppointmentProvider="Integrated">
            <appointmentProviders>
                <add name="MyDbSchedulerProvider1"
                     type="Telerik.Web.UI.DbSchedulerProviderBase"
                     fileName="~/App_Code/MyDbSchedulerProvider.vb"
                     persistChanges="true"/>
            </appointmentProviders>
        </radScheduler>
    </telerik.web.ui>

[Peter]

Hello manoj,

For a sample working project of using RadScheduler with a provider class you can look at this kb article. If you still experience problems, please open a support ticket and send us your project so we can test it locally.


Kind regards,
Peter
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[manoj]

Hi there,

I think i got the problem.
Actually i was trying to run the sample(use of sql database with Scheduler) given in documentation in VB.net, and it was not working for me even after several attpemts.

Then for a change, i just tryied in C# and it works in first attempt.

After that I used a online convertor which convert the C# code into VB.net and tryied that and its works in VB.Net.

Than i compared the VB.net code mentioned in the telerik document with the code  converted by online site and i found that there is some mistakes in the telerik converted code.