Telerik Forums
UI for ASP.NET MVC Forum
0 answers
40 views

Hi, I have this list of thousands of employees from our Database and will be displayed in a Grid via ViewModel. Im using Custom Binding with paging to fetch only specific number of records per page to reduce the loading time of the grid thats why the ServerOperation = true.

My problem is that, how can I customize or recreate the request filters? Since FullName and Address does not exists in the Employees table. I'm getting error whenever i use search.

 

public class Employee
    {
        public string EmployeeID { get; set; }

        public string LastName { get; set; }
        public string FirstName { get; set; }

        public string Street { get; set; }
        public string City { get; set; }
        public string Province { get; set; }

        public string TelephoneNo { get; set; }

        public string FullName
        {
            get
            {
                return String.Format("{0}, {1}", LastName, FirstName ?? "");
            }
        }

        public string Address
        {
            get
            {
                return String.Format("{0} {1} {2}", Street, City, Province);
            }
        }
    }

@(Html.Kendo().Grid<Employee>()
    .Name("gridEmployees")
    .ToolBar(toolbar =>
    {
        toolbar.Search();
    })
    .Columns(column =>
    {
        column.Bound(c => c.EmployeeID);
        column.Bound(c => c.FullName);
        column.Bound(c => c.Address);
        column.Bound(c => c.TelephoneNo);
    })
    .Filterable()
    .AutoBind(false)
    .DataSource(ds =>
    {
        ds.Ajax()
        .ServerOperation(true)
        .PageSize(10)
        .Model(m => m.Id(c => c.EmployeeID))
        .Read(r => r.Action("Read", "Employees"));
    })
)

        
DPA
Top achievements
Rank 1
 asked on 19 Jan 2024
0 answers
28 views

Hi!

I have this large data from a Table with related tables and I'm currently using Custom Binding to apply paging, sorting and more importantly filtering to load smaller data sets. 

And my problem is on the below link, no paging example was documented.  Can you please help me with this?

ASP.NET MVC Data Grid Component Custom Binding - Telerik UI for ASP.NET MVC

DPA
Top achievements
Rank 1
 asked on 18 Jan 2024
1 answer
37 views

I have this grid with Edit and Destroy column command buttons. As I click the Delete/Destroy button it instantly calls the Destroy action without waiting for the delete confirmation. How can I solve this?

 

@(Html.Kendo().Grid<Models.ViewModel>()
        .Name("grid")
        .EnableCustomBinding(true)
        .Columns(columns =>
        {
            columns.Command(command =>
            {
                command.Edit();
                command.Destroy();
            }).Width(180);
            columns.Bound(p => p.Sorting).Width(100).Filterable(false);
            columns.Bound(p => p.Code).Width(200).Filterable(true);
            columns.Bound(p => p.Description).Filterable(true);
        })
        .ToolBar(toolbar =>
        {
            toolbar.Search();
        })
        .Editable(editable => editable.Mode(GridEditMode.PopUp).DisplayDeleteConfirmation(true))
        .Filterable()
        .Pageable()
        .DataSource(dataSource => dataSource
            .Ajax()
            .Events(events => events.Error("error_handler"))
            .Model(model => model.Id(p => p.Id))
            .Read("gridReadDataSource", "MyGrid")
            .Update("gridEditDataSource", "MyGrid")
            .Destroy("gridDeleteDataSource", "MyGrid")
        )
)
Anton Mironov
Telerik team
 answered on 03 Jan 2024
3 answers
481 views

Hi, I would like to know if there is a way to load a PDF stored as VARBINARY(MAX) in a SQL Server Filestream field.

Thank you in advance.

 

Ivan Danchev
Telerik team
 updated answer on 02 Jan 2024
1 answer
25 views

Hello,

for a new project we're considering ASP.NET MVC, or React (Kendo React)

 

We like to create a scheduler with multiple users next to each other, per day.

In attachment is an drawing of the expected result.

Is this feasable with Telerik Scheduler, with drag and drop availabilities to move appointments between users?

Thanks,

 

Jeroen

Georgi
Telerik team
 answered on 26 Dec 2023
1 answer
65 views

Hello,

I have been having issues with Visual Studio 2022 (17.7 and 17.8) crashing when running a 'Find and Replace' or when trying to merge a file using GIT. After submitting the issue to the Visual Studio support team, we discovered that either the Telerik MVC or Core extension is the cause. 

Is anyone else experiencing this issue? If so, is it being fixed in the next release?

 

Thanks

Vesko
Telerik team
 answered on 22 Dec 2023
1 answer
26 views

I recently updated the Kendo library to 2023.3.1114.545 from 2022.3.  I did not change any code other than the style sheets.  My grids are showing a long drop down with the page numbers even though I do not specify it and other options like page records per page do not show.  Plus, the refresh button doesn't show.

I attached how it looks.

My CSS and script includes:

<link href="@Url.Content("~/Content/classic-silver/classic-silver.css")" rel="stylesheet" />
<link href="@Url.Content("~/Content/kendo/font-icons/index.css")" rel="stylesheet"  type="text/css" />

<script src="@Url.Content("~/Scripts/jquery-3.7.1.min.js")"></script>
<script src="@Url.Content("~/Scripts/kendo/2023.3.1114/jszip.min.js")"></script>
<script src="@Url.Content("~/Scripts/kendo/2023.3.1114/kendo.all.min.js")"></script>
<script src="@Url.Content("~/Scripts/kendo/2023.3.1114/kendo.aspnetmvc.min.js")"></script>

Kendo Grid code:

    @(Html.Kendo().Grid<ListModel>()
        .Name("List")
        .Columns(columns =>
        {
            columns.Bound(e => CaseNumber).Filterable(false).Title("Case Number")
            columns.Bound(e => e.LastName);
            columns.Bound(e => e.FirstName);
        })
        .Sortable()
        .Filterable()
        .Pageable(pageable => pageable
            .Refresh(true)
            .PageSizes(new int[] { 10, 25, 50, 100 })
            .ButtonCount(5))
        .DataSource(ds =>
        {
            ds.Ajax()
                .Read(read => read
                    .Action("Cases_Read", "CasesList")
                )
                .PageSize(25);
        })
        .ToolBar(tools => tools.Excel())
    )
Rey
Top achievements
Rank 2
Iron
Iron
 answered on 18 Dec 2023
0 answers
28 views

Dear Sir/Madam,

Telerik UI for Asp.net MVC and AJAX have been installed in my destkop.

I have created a project for Asp.net MVC with GRID AND MENU interface in visual studio 2017. 

I run dedug mode, the datagrid can't show any column. What's wrong of this?

 

Jacky
Top achievements
Rank 1
 asked on 14 Dec 2023
1 answer
45 views

I am trying to bind the datatable to the MVC grid and using ajax read to get the data. Everything is working as expected until I am trying to convert one of the column to foreignkey column.

Here is my sample code

 @(Html.Kendo().Grid<dynamic>()
                .Name("ReportGrid")
                .Scrollable()
                .Columns(columns =>
                {
                    foreach (var column in Model.TableConfig.MasterColumns)
                    {
                        if (refColumns.Contains(column.ColumnName))
                        {
                            var refData = Model.MetaData.Where(m => m.ColumnName == column.ColumnName).ToList();


                            columns.ForeignKey(column.ColumnName, new SelectList(refData, "DataValue","DataText")).EditorTemplateName("GridForeignKey");


                        }
                        else
                        {
                            columns.Bound(column.ColumnName);
                        }
                        //var c = columns.Bound(column.ColumnName);
                    }                
                })

 

I am getting the below error

 

System.AggregateException: 'One or more errors occurred. ('object' does not contain a definition for 'DataTable ColumnName')'
Mahesh
Top achievements
Rank 1
Iron
 answered on 14 Dec 2023
0 answers
27 views

Adding same question since the header is wrong and I am not able to update

I am trying to bind the datatable to the MVC grid and using ajax read to get the data. Everything is working as expected until I am trying to convert one of the column to foreignkey column.

Here is my sample code

 @(Html.Kendo().Grid<dynamic>()
                .Name("ReportGrid")
                .Scrollable()
                .Columns(columns =>
                {
                    foreach (var column in Model.TableConfig.MasterColumns)
                    {
                        if (refColumns.Contains(column.ColumnName))
                        {
                            var refData = Model.MetaData.Where(m => m.ColumnName == column.ColumnName).ToList();


                            columns.ForeignKey(column.ColumnName, new SelectList(refData, "DataValue","DataText")).EditorTemplateName("GridForeignKey");


                        }
                        else
                        {
                            columns.Bound(column.ColumnName);
                        }
                        //var c = columns.Bound(column.ColumnName);
                    }                
                })

 

I am getting the below error

 

System.AggregateException: 'One or more errors occurred. ('object' does not contain a definition for 'DataTable ColumnName')'
Mahesh
Top achievements
Rank 1
Iron
 asked on 14 Dec 2023
Narrow your results
Selected tags
Tags
+? more
Top users last month
Mark
Top achievements
Rank 1
Yurii
Top achievements
Rank 1
Leland
Top achievements
Rank 2
Iron
Iron
Iron
Hon
Top achievements
Rank 1
Iron
Deltaohm
Top achievements
Rank 3
Bronze
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Mark
Top achievements
Rank 1
Yurii
Top achievements
Rank 1
Leland
Top achievements
Rank 2
Iron
Iron
Iron
Hon
Top achievements
Rank 1
Iron
Deltaohm
Top achievements
Rank 3
Bronze
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?