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

simple working example of scheduler fetching information from sql

9 Answers 298 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Jonas
Top achievements
Rank 1
Jonas asked on 10 Oct 2014, 06:46 AM
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

9 Answers, 1 is accepted

Sort by
0
Accepted
Vladimir Iliev
Telerik team
answered on 10 Oct 2014, 07:33 AM
Hi Jonas,

You can check the following step-by-step guide of how to bind the Scheduler to table in the DataBase using EntityFramework:
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):


Regards,
Vladimir Iliev
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Jonas
Top achievements
Rank 1
answered on 10 Oct 2014, 08:24 AM
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
0
Jonas
Top achievements
Rank 1
answered on 10 Oct 2014, 09:05 AM
One more question.

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

BR
Jonas
0
Accepted
Vladimir Iliev
Telerik team
answered on 10 Oct 2014, 09:14 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Jonas
Top achievements
Rank 1
answered on 10 Oct 2014, 11:15 AM
Thank you, Vladimir!

I got all things working now :-)

BR
Jonas
0
May
Top achievements
Rank 1
answered on 22 Aug 2018, 01:19 PM
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
0
Dimitar
Telerik team
answered on 24 Aug 2018, 07:10 AM
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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
K.Ramadan
Top achievements
Rank 2
Veteran
answered on 24 Feb 2020, 08:54 AM

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

0
Dimitar
Telerik team
answered on 25 Feb 2020, 07:09 AM

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:

Regards,
Dimitar
Progress Telerik

Get quickly onboarded and successful with your Telerik UI for ASP.NET MVC with the dedicated Virtual Classroom technical training, available to all active customers.
Tags
Scheduler
Asked by
Jonas
Top achievements
Rank 1
Answers by
Vladimir Iliev
Telerik team
Jonas
Top achievements
Rank 1
May
Top achievements
Rank 1
Dimitar
Telerik team
K.Ramadan
Top achievements
Rank 2
Veteran
Share this question
or