Hello,
I have a Grid with the editable mode set to "PopUp" and I've provided a template file for it. In my template file I'm using a Kendo ComboBox to allow the user to select from a list of US States, and in edit mode I would expect it to set the value to the selected record's StateId. Unfortunately, when the edit popup appears the State is not selected in the ComboBox that matches the value in the grid's selected record. However, as soon as I click on the ComboBox's down arrow the value gets populated. I'm not sure what I'm doing wrong. Am I missing a step somewhere? Any help is appreciated. Thanks.
Here's the code for my grid:
@(Html.Kendo().Grid<PARRE.Models.Project> () .Name("Projects") .Columns(columns => { columns.Bound(c => c.ProjectName).Width(200); columns.Bound(c => c.ProjectDescription); columns.Bound(c => c.Address).Width(200); columns.Bound(c => c.City).Width(160); columns.ForeignKey(f => f.StateId, (System.Collections.IEnumerable)ViewData["StatesList"], "StateId", "StateAbbr").Width(100); columns.Bound(c => c.ZipCode).Width(120); columns.Bound(c => c.ContactName).Width(160); columns.Bound(c => c.PhoneNumber).Width(135); columns.Bound(c => c.Email).Width(160); columns.Command(command => { command.Edit().Text(" "); command.Destroy().Text(" "); }).Width(170); }) .HtmlAttributes(new { style = "height: 100%; width: 100%;" }) .Scrollable() .Groupable() .Sortable() .Pageable(pageable => pageable .Refresh(true) .PageSizes(true) .ButtonCount(5)) .Filterable() .ToolBar(toolbar => toolbar.Create()) .Editable(editable => editable.Mode(GridEditMode.PopUp).TemplateName("_ProjectCreate").Window(x => x.Title("Add/Edit Project").Width(700))) .DataSource(dataSource => dataSource .Ajax() .PageSize(20) .Events(events => { events.Error("error_handler"); }) .Model(model =>{ model.Id(p => p.ProjectID); model.Field(p => p.ProjectID).Editable(false); }) .ServerOperation(false) .Read(read => read.Action("List", "Projects")) .Update(update => update.Action("Update", "Projects")) .Create(create => create.Action("Create", "Projects")) .Destroy(destroy => destroy.Action("Delete", "Projects")) )
Here's the code for the ComboBox
@(Html.Kendo().ComboBoxFor(model => model.StateId) .AutoBind(false) .BindTo((System.Collections.IEnumerable)ViewData["StatesList"]) .DataTextField("StateAbbr") .DataValueField("StateId") .Filter(FilterType.Contains) .HtmlAttributes(new { style = "width: 70px; background-color: white;" }) .Placeholder("...") .ClearButton(false))
Here's the code in the Controller to get the list of states:
public IActionResult Index() { PopulateStates(); return View(); } private void PopulateStates() { IQueryable<USStates> usStates = _context.USStates.Select(s => new USStates { StateId = s.StateId, StateAbbr = s.StateAbbr }).OrderBy(o => o.StateId); ViewData["StatesList"] = usStates.ToList(); }
Regards,
Shawn A.
Hello,
I'm very new to developing in ASP.NET Core and Telerik's Keno UI. I'm trying to find documentation on how I can change the title of a grid popup window when I click on the "Add New Record" button on top of the Grid. Currently, the word "Edit" is displayed even though the operation is for "insert". How do I go about changing the title of a popup add/edit window for a Grid?
Here's my code:
@(Html.Kendo().Grid<MyApp.Models.Project> () .Name("Projects") .Columns(columns => { columns.Bound(c => c.ProjectName).Width(100); columns.Bound(c => c.ProjectDescription).Width(100); columns.Bound(c => c.Address); columns.Bound(c => c.City).Width(100); columns.Bound(c => c.State).Width(100); columns.Bound(c => c.ZipCode).Width(50); columns.Bound(c => c.ContactName); columns.Bound(c => c.PhoneNumber); columns.Bound(c => c.Email); }) .HtmlAttributes(new { style = "height: 380px;" }) .Scrollable() .Groupable() .Sortable() .Pageable(pageable => pageable .Refresh(true) .PageSizes(true) .ButtonCount(5)) .ToolBar(toolbar => toolbar.Create()) .Editable(editable => editable.Mode(GridEditMode.PopUp).TemplateName("_ProjectCreate")) .DataSource(dataSource => dataSource .Ajax() .PageSize(20) .Events(events => { events.Error("error_handler"); }) .ServerOperation(false) .Read(read => read.Action("GetProjects", "Projects")) .Create(create => { create.Action("Create", "Projects"); }) ))I am having trouble with the header text of a column where there is a client template in place. I want to not show any text in that column. But if I set .Title("") or .Title(string.Empty) it shows the column name anyway.
Here is the markup for that column :
columns.Bound(a => a.ProductBuyLink).ClientTemplate("<a href='" + "#= ProductBuyLink #" + "' target=blank>" + "<img title='Buy Now' alt='Buy Now' height=25 src='../../images/shoppingcart_24.png'/></a>").Width(63).Title("").Sortable(false).Locked(true);
I have searched and found many solutions that do not work.
https://www.telerik.com/forums/get-column-header-title
https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.headertemplate
Like this does not work :
$("#grid thead").find("[data-field='ProductBuyLink'] .k-link").html("");
If I use the code in the line above for another column not using a Client Template it works. So the issue has to do with columns with a client template defined.
Please advise.
How exactly can we get the virtualization working? The demo is missing a lot of code. There is also no information on how to send the antiForgery token, and no way to set the action to GET, in case you didn't want to post. Please post a complete working example with virtualization on autocomplete.
Thank you.
Hi - we have a ASP.NET Core application. It has a grid in which we are prefiltering a default for one column. The filtering works fine but the .k-grid-filter class for that column does not have the k-active-state class applied as it does when we manually click the icon to filter. So the user can not see that a default filter is applied when grid is rendered.
How can we implement this - show the default filter with class applied that lets the user know that the column has filter applied
we are using the latest 2019 version of Telerik UI for ASP.NET Core.
the default filter is applied to the datasource in this way:
.Filter(f => f.Add(cr => cr.Ccrstatus).IsNotEqualTo("Rejected").And().IsNotEqualTo("Open"))

My Home view contains a grid. When a row in the grid is clicked, a window is displayed in an iframe with a spreadsheet on it.
<div> @(Html.Kendo().Window() .Name("timecard") .Modal(true) .Actions(actions => actions.Close()) .Draggable(false) .LoadContentFrom("Timecard") .Events(events => events .Open("timecard_OnOpen") .Close("timecard_OnClose") ) .Iframe(true) .Width(1650) .Height(800) .Visible(false) .Deferred(true) )</div>
In the Open event I am using an ajax call to the controller to get data to fill the spreadsheet. Once I have the data I want to populate the spreadsheet. The spreadsheet is somewhat complex with frozen rows, merged cells, etc. so I can't use a datasource. My issue is that I cannot get access to the spreadsheet on the iFrame window to populate it with the data.
function timecard_OnOpen(e){ $.ajax({ url: '@Url.Action("Load", "Timecard")', type: 'POST', data: { id: employee_key }, success: timecard_LoadTimecardSuccess });}function timecard_LoadTimecardSuccess(data){ var window = $("#timecard").getKendoWindow(); var spreadsheet = $("#timecardSpreadsheet").data("kendoSpreadsheet");}
The var spreadsheet is undefined. I want to be able to do something like this:
var spreadsheet = $("#timecardSpreadsheet").data("kendoSpreadsheet");
var sheet = spreadsheet.activeSheet();
var range = sheet.range('B12'); // Spreadsheet cell name
range.value("TEST");
Hi
I have a simple grid that allow add records and one of my read only field is DateTime.Today with localized format of "dd/MM/yyyy".
When i post the record to server i got invalid date error i.e. "The value '2/19/2019 4:00:16 PM' is not valid for Date.
I tried changing the DateTime..Now.ToString("MM/dd/yyyy") but same error still show.
Can anyone help? thanks.
I want to display an enumeration variables in TreeList Column , for example :
public enum TrafficType
{
[Display(Name = "Car-1")]
Car = 1,
[Display(Name = "Train-2")]
Train = 2,
[Display(Name = "Airplane-3")]
Airplane = 4
}
If Telerik Grid, I can write code as follows:
columns.Bound(p => p.Category).ClientTemplate("#=Category.CategoryName#").Width(180);
But for Treelist, how can I do?
Hi I am using the grid in asp.net core 2.1 excellent product by the way however i am having an issue its the inline popup is display more fields than i have defined in my grid layout for example
In my grid I would be expecting just the five columns here but its displaying the entire model in the popup. Also how does one use dapper for the crud operations is that possible as I am using stored procs to keep my site fast and clean to acehieve this.
Also how do i color the command buttons is that simple enough?
columns.Bound(p => p.Name).Filterable(false);
columns.Bound(p => p.Description);
columns.Bound(p => p.ActivityDate).Format("{0:MM/dd/yyyy}");
columns.Bound(p => p.EmployeeName);
columns.Bound(p => p.Status);
@(Html.Kendo().Grid<FuelActivityTrackerDal.Models.ActivityHeader>() .Name("grid") .Columns(columns => { columns.Bound(p => p.Name).Filterable(false); columns.Bound(p => p.Description); columns.Bound(p => p.ActivityDate).Format("{0:MM/dd/yyyy}"); columns.Bound(p => p.EmployeeName); columns.Bound(p => p.Status); columns.Command(command => { command.Edit(); command.Destroy(); }).Width(160); }) .ToolBar(toolbar => toolbar.Create()) .Editable(editable => editable.Mode(GridEditMode.PopUp)) .Pageable() .Sortable() .Scrollable() .Filterable() .HtmlAttributes(new { style = "height:550px;" }) .DataSource(dataSource => dataSource .Ajax() .PageSize(Model.Count()) .Read(read => read.Action("Activity_Read", "Activity")) ))<script type="text/javascript"> function error_handler(e) { if (e.errors) { var message = "Errors:\n"; $.each(e.errors, function (key, value) { if ('errors' in value) { $.each(value.errors, function () { message += this + "\n"; }); } }); alert(message); } }</script>