Telerik Forums
UI for ASP.NET Core Forum
2 answers
949 views

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.

Shawn
Top achievements
Rank 1
 answered on 04 Mar 2019
4 answers
3.3K+ views

 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");
            })
        )
)
Shawn
Top achievements
Rank 1
 answered on 04 Mar 2019
2 answers
974 views

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.

 

 

 

Reid
Top achievements
Rank 2
 answered on 01 Mar 2019
8 answers
185 views

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.

Chris
Top achievements
Rank 1
 answered on 26 Feb 2019
4 answers
870 views

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"))

 

 

Viktor Tachev
Telerik team
 answered on 25 Feb 2019
4 answers
205 views

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");

 

 

 

Marin Bratanov
Telerik team
 answered on 22 Feb 2019
3 answers
133 views

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.

Jimmy
Top achievements
Rank 1
Iron
Veteran
 answered on 22 Feb 2019
2 answers
428 views
How can we disable the Excel and PDF grid toolbar buttons if there is no record count?
Reid
Top achievements
Rank 2
 answered on 21 Feb 2019
1 answer
2.2K+ views

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?


Tsvetomir
Telerik team
 answered on 21 Feb 2019
3 answers
292 views

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>
Tsvetomir
Telerik team
 answered on 21 Feb 2019
Narrow your results
Selected tags
Tags
+? more
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?