simple working example of scheduler fetching information from sql

[Jonas]

Hello

I'm a total beginner with Telerik and I'm having problems binding the scheduler to at database for showing events. Is there somebody who knows of a step-by-step tutorial for making that connection or could tell me step-by-step how I should do it (preferably with a working example).

BR
Jonas

[Vladimir Iliev]

Hi Jonas,

You can check the following step-by-step guide of how to bind the Scheduler to table in the DataBase using EntityFramework:

• Scheduler: Ajax Editing

Also for your convenience I recorded small screencast which demonstrates the exact steps from the above guide in action (in the screencast I'm using VS2013, EntityFramework v.5):

• Ajax editing guide screencast

Regards,
Vladimir Iliev
Telerik

 

 

[Jonas]

Hello Vladimir

Thank you!

I found that page myself about 5 minutes before your post. :-)

And thank you so much for the screencast

BR
Jonas

[Jonas]

One more question.

Where can I find the sample database that you are using?

BR
Jonas

[Vladimir Iliev]

Hi Jonas,

The sample DataBase can be found in the following path under your Telerik UI for ASP.NET MVC installation folder:

• ..\UI for ASP.NET MVC Q2 2014\wrappers\aspnetmvc\Examples\VS2012\Kendo.Mvc.Examples\App_Data\Sample.mdf

Regards,
Vladimir Iliev
Telerik

 

 

[Jonas]

Thank you, Vladimir!

I got all things working now :-)

BR
Jonas

[May]

So far this post has been helpful but where can I find the database?   There is no example folder here: C:\Program Files (x86)\Progress\Telerik UI for ASP.NET MVC R2 2018\wrappers\aspnetmvc

[Dimitar]

Hello May,

I have provided a detailed explanation on how to resolve the issue in your other support thread on the same topic. I would suggest to continue our communication there in order to prevent thread duplication.

Regards,
Dimitar
Progress Telerik

[K.Ramadan]

So i did exactly what Vladimir IIiev in the Clip did. and it didn't work.

in the Read Method in Controllers

 

 public ActionResult Cal_Read([DataSourceRequest]DataSourceRequest request/*, KommunikationViewModel kommunikation*/)
        {

            using (var testDB = new KARAM_RAMADANEntities())
            {
                IQueryable<KommunikationViewModel> tasks = testDB.KOMMUNIKATIONEN.ToList().Select(eventy => new KommunikationViewModel()
                {
                    ID = eventy.SID_KOMMUNIKATIONEN,
                    Title = eventy.BETREFF,
                    Start = /*eventy.BEGINN */DateTime.SpecifyKind(eventy.BEGINN, DateTimeKind.Utc),
                    End = /*eventy.ENDE,*/    DateTime.SpecifyKind(eventy.ENDE, DateTimeKind.Utc),
                    StartTimezone = eventy.BEGINN_STD,
                    EndTimezone = eventy.ENDE_STD,
                    Description = eventy.BEMERKUNG,
                    IsAllDay = eventy.ALLDAYY,
                    RecurrenceId = eventy.STRINID1
                }).AsQueryable();

                return Json(tasks.ToDataSourceResult(request));
            }
        }

 

it reading the records from the database but it's not showing them !!

I Really need help here .. I'm trying like for a week now and have no results

[Dimitar]

Hi,

I am not able to determine the cause for the issue by reviewing just a code snippet of the Read method. I would suggest to open a separate support thread where you could send us an isolated example that demonstrates the issue so that we can examine it further and provide you with more efficient assistance.

You could also review the official Demos of the Scheduler for ASP.NET MVC and inspect how the widget is configured and also observe the end-point implementation:

• https://demos.telerik.com/aspnet-mvc/scheduler

Regards,
Dimitar
Progress Telerik