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

Bind Scheduler with SQL DataBase

6 Answers 320 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
manoj
Top achievements
Rank 1
manoj asked on 09 Jul 2008, 11:50 AM
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

6 Answers, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 09 Jul 2008, 12:33 PM
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
0
manoj
Top achievements
Rank 1
answered on 10 Jul 2008, 04:01 AM
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.
0
Peter
Telerik team
answered on 10 Jul 2008, 08:08 AM
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
0
manoj
Top achievements
Rank 1
answered on 19 Jul 2008, 03:57 AM
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>
0
Peter
Telerik team
answered on 21 Jul 2008, 02:45 PM
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
0
manoj
Top achievements
Rank 1
answered on 22 Jul 2008, 04:08 AM
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.
Tags
Scheduler
Asked by
manoj
Top achievements
Rank 1
Answers by
Peter
Telerik team
manoj
Top achievements
Rank 1
Share this question
or