Hello.

I am using the UI for ASP.NET MVC Grid version 2016.3.914.545 with Telerik DataAccess version 2016.1.224.1 with a MSSQLLocalDB for development.

As long as there is no filter or group used in the grid everything is working. If the user filters, even a simple "=", the request times out. Using the DataAccess Profiler I found the reason. The generated SQL statement reads all records. Not only the required 10. Which takes about three minutes with subsequent requests to get the detailed data.

The grid config in my view:

The read service:

In the controller itself nothing special happens:

The SQL generated after setting a filter:

The grid filter, Workplace.Label="Something", is missing and the TOP() statement is missing. Seems Like ToDataSourceResult wants to laod everything into memory and do the filtering itself.

How can I convince ToDataSourceResult from taking only the needed and filterd 10 rows? Does it help if I add the filters in my where clause as request filters?

Side note for the DataAccess team: I configured logging of the stack trace, but the profiler says there is none. My configuration:

Kind regards

Bernd

Hi,

I am using a date picker to edit the date displayed on my grid.

The problem is while saving the date it gets saved as shown in the attachment.

I just want it to be saved in the format (mm/dd/yyyy) and I dont want those extra labels such as indian standard time etc.

Can anyone help?

Regards,

Adhip

 

Save State

Load State

 

Thanks All

This works:

This doesn't:

 

 

In the second example, the script never hit, so the parameter never got populated in our controller.  (In both cases, our Read controller action was hit, but the "AdditionalParam" parameter was only populated in the first example)

We tried putting the script in our main js file, putting it on our view page, and putting it directly inline in the .Data call, none of which worked.

Any thoughts why?  Any help would be greatly appreciated! :)

 

 

Hi,
My goal is to save the grid settings (filter, sort, group,page, pagesize) in a cache or in a database and restore it.
I am able to save the grid setting but not able to apply it back. 
I save the grid setting on grid databound call

var grid = $("#DocumentGrid").data().kendoGrid;
var dataSource = grid.dataSource;

var state = {
                page: dataSource.page(),
                pageSize: dataSource.pageSize(),
                sort: dataSource.sort(),
                group: dataSource.group(),
                filter: dataSource.filter()
            };

            $.ajax(
                 "/controller/SaveGridSettings", {
                     data: dataSource.transport.parameterMap(state, "read")
                 });
In the controller, i am saving it in a dictionary where "string" is a GUID and saving the setting as a Kendo.Mvc.UI.DataSourceRequest

Dictionary<string, Kendo.Mvc.UI.DataSourceRequest>

For testing purpose, i created a button click event to apply the settings.
To read the grid setting and apply it, i tried the following and it didn't work
var grid = $("#DocumentGrid").data().kendoGrid;
        var dataSource = grid.dataSource;
        $.get("/controller/GetGridSettings", {
            Id:  id <-- Passed in during the call
        }).done(function (data) {
                         dataSource.query(data);
                      //dataSource.filter(data.Filters);  <-- Also tried this way
                     //dataSource.sort(data.Sorts);
        });
I want to apply the saved setting when the users navigate to different page and come back to the page with the grid and when they log out and log back in.

Any help is appreciated.

Thanks,
Dinesh

Hi,

 

is there a way (like in PivotGrid for ASP.NET AJAX) to persist a pivot grid on the server.

Usage: the user drags columns around till he has the desired result - with save he can persist this "view" on the server. Later he can recall this "view" to have the same PivotGrid configuration again.

 

Manfred

Hey Guys

 

Just busy adding custom validation to my solution and came across this issue.

I used the example of adding custom validation for Dates provided here  and change it to support time between and using TimeSpans.

Please ignore how crappy the coding is, I am not a javascript coder, so I just bash my way through it! 

Hi

 

Let me paint the picture. I am trying to build an application for the medical domain. Basically creating accounts which are responsible for paying the account. Then dependants linked to an account. And each account has transactions linked to it. That is the basic domain. I am trying to display a grid showing the account information. My architecture is as follows. Using entity framework 6 as my ORM. I have built some DTO's inside a model project that hold all my models which I intend to carry over the wire. I have a seperate asp mvc api project which will act as my data hub for different types of front ends, browser or mobile. At the moment I'm trying to build a front end using MVC 5 using the telerik kendo ui controls to make the ui nice. I'm struggling even after reading various articles on trying to achieve this. I have a method in my web api project which returns a list of accounts which I pasted below. After reading some new articles I've realised that it be better to refactor this method to return the kendo DataSourceResult and accept the modelbinder as a parameter. My question is. How do I pass the practiceid parameter into this method so that it only returns me a list of accounts that belong to the practice the user has logged into. I have also pasted my grid definition below.

[Route("api/Accounts")]public HttpResponseMessage GetAccountsByPractice(int practiceId){     IAccountRepository accountRepository = new AccountRepository("");     try     {         var results = accountRepository.GetAccountsByPractice(new Practice { PracticeId = practiceId });         return Request.CreateResponse(HttpStatusCode.OK, results);     }     catch (Exception)     {         throw;     }}

 

@(Html.Kendo().Grid<Medistat.MedistatWeb.Domain.Model.AccountDTO>()       .Name("accountGrid")       .Columns(columns =>       {           columns.Bound(p => p.AccountNumber);           columns.Bound(p => p.AccountHolderName).Width(100);           columns.Bound(p => p.IdNumber).Width(100);           columns.Bound(p => p.MedicalAidName).Width(100);           columns.Bound(p => p.MedicalAidNumber).Width(100);       })       .ToolBar(tools =>       {           tools.Create();       })       .Sortable()       .Pageable()       .Filterable()       .DataSource(dataSource =>           dataSource             .WebApi()             .Model(model =>             {                 model.Id(p => p.AccountId);             })             .Events(events => events.Error("error_handler"))             .Read(read => read.Url("http://localhost:54510/api/accounts"))             .Create(create => create.Url("http://localhost:54510/api/accounts"))       ))

 

Hi,

Based on the demo in http://demos.telerik.com/aspnet-mvc/dialog/treeview-integration. i am trying to achieve a filter in the treelist control. But the data i am binding in the treelist has about 5000 records, hence the filtering takes about 7 seconds, please advise if the code provided in the demo is suitable for this scenario or do i need to use a different approach.

Also i am using the selected property of the item to decide on the selection in the treelist, and setting the selected item text to a textbox, if i change the textbox would want to unselect the selected item in the treelist, is this possible.

 

I am new to the "MVC" world so I expect that I am doing something wrong.  I am constantly moving between a desktop station and a laptop.  Projects created on one system will not load successfully from Team Foundation Services on the second system.  Both computers have are fully licensed and have all the same levels of .NET and other tools installed.  Both are kept "current" from the "Telerik" and "Microsoft" perspective.

The problem seems to be related to the "Kendo.Mvc.dll".  The computer knows where it is and links and compiles perfectly fine on machine #1.  When I save all to TFS then move to workstation #2 the problems occur.  A complete get of all source code, and subsequent compilation, shows that the computer cannot find "Kendo.Mvc.dll".  The reference shows a small symbol indicating its reference is invalid.  I am forced to manually remove the .DLL, then browse for the .DLL.  This solves the immediate problem however it then reoccurs when I do the reverse (move back to machine #1).  All Telerik/Kendo .DLL's are set to "copy local".

A possible symptom of the problem:  A "upgrade" action causes the upgrade wizard to crash.  It dies reporting that it cannot find the .DLL despite it being present in the respective folders.  If it is of concern, the projects are targeted at .NET Framework 4.6.1.  I appear to be using MVC 5.

Is anyone else having similar issues?  What am I doing wrong?  While this is in no way a showstopper, it is an annoyance I would like to resolve.