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"));
})
)
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
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>()
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.
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
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
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())
)
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?
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')'
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')'