Telerik Forums
UI for ASP.NET Core Forum
or
Ask question
All Questions
Unanswered
Answered
2,783 questions
1 answer
272 views
Migrate .net framework to net core 6
I'm migrating net .framework 4.7 using kendo mvc 2017.2 to net core 6, is it possible to use this version with net core 6?
General Discussions
Stoyan
Telerik team
 answered on 12 Jun 2023
1 answer
583 views
Sort order of items in builtin filter for Kendo Grid

I'm using ASP NET CORE.  I have a grid and I enable filtering on a column with .Filterable().  Is there a way to sort the items that appear in the checkbox filter?

EX:

My filter would look like this

  • A
  • B
  • C

And not

  • B
  • C
  • A

When the drop down is displayed.

Filter
Grid
Alexander
Telerik team
 answered on 09 Jun 2023
1 answer
123 views
Spreadsheet - access excel column with letter such as A20

Hi There, 

I'm working on a web app and need to access the Excel column with letters instead of an index. I have gone through the documentation but didn't find how we can access the Excel column with alphabets such as A20

Could you please let me know if you have any functions or not?

 

Thanks,

 

Spreadsheet
Stoyan
Telerik team
 answered on 07 Jun 2023
1 answer
136 views
Nested Grid Event cannot find javascript function

I have a nested grid in a client template. Everything on my pages works great. I would like to refresh the parent grid when the nested gid is updated. The only way I have found to do this is to use the RequestEnd event on the nested grid, so I defined it in the gird's data source:

    <script id="campaignTemplate" type="text/kendo-tmpl">
        @(Html.Kendo().Grid<Campaign>()
                                .Name("grid_#=Id#")
                            .Columns(columns =>
                            {
                                columns.Bound(p => p.Name).Width(200);
                                columns.Bound(p => p.MailDate1).Width(150).Title("Mail Date");
                                columns.Bound(p => p.ProjectedQuantityMailed).Width(100).Title("Quantity");
                                columns.Bound(p => p.ProjectedPercentReturn).Width(50).Title("Percent Return");
                                columns.Bound(p => p.ProjectedNumberOfGifts).Width(50).Title("Gifts");
                                columns.Bound(p => p.ProjectedAverageGiftAmount).Width(50).Title("Average Gift");
                                columns.Bound(p => p.ProjectedGrossIncome).Width(100).Title("Gross Income");
                                columns.Bound(p => p.ProjectedGrossIncomePerThousand).Width(50).Title("Gross Income/M");
                                columns.Bound(p => p.ProjectedTotalCost).Width(100).Title("Cost");
                                columns.Bound(p => p.ProjectedTotalCostPerThousand).Width(100).Title("Cost/M");
                                columns.Bound(p => p.ProjectedNetIncome).Width(100).Title("Net");
                                columns.Bound(p => p.ProjectedNetIncomePerThousand).Width(100).Title("Net/M");
                                columns.Bound(p => p.ProjectedNetIncomePerDonor).Width(100).Title("Net/Donor");
                                columns.Bound(p => p.ProjectedCostPerDollarRaised).Width(100).Title("Per Dollar Raised").Hidden(true);
                                columns.Bound(p => p.ProjectedMonthsToRecoupCost).Width(100).Title("Recoup Months").Hidden(true);
                                columns.Bound(p => p.ProjectedMailshopCost).Width(100).Title("Mail Shop").Hidden(true);
                                columns.Bound(p => p.ProjectedPostageCost).Width(100).Title("Postage").Hidden(true);
                                columns.Bound(p => p.ProjectedCopyCost).Width(100).Title("Copy").Hidden(true);
                                columns.Bound(p => p.ProjectedProofreaderCost).Width(100).Title("Proof Reader").Hidden(true);
                                columns.Bound(p => p.ProjectedArtCost).Width(100).Title("Art").Hidden(true);
                                columns.Bound(p => p.ProjectedListCost).Width(100).Title("List").Hidden(true);
                                columns.Bound(p => p.ProjectedProductionManagementFee).Width(100).Title("Management").Hidden(true);
                                columns.Bound(p => p.ProjectedMergePurgeCost).Width(100).Title("Merge Purge").Hidden(true);
                                columns.Bound(p => p.ProjectedPrintingCost).Width(100).Title("Printing").Hidden(true);
                                columns.Bound(p => p.ProjectedQctCost).Width(100).Title("QCT").Hidden(true);
                            })
                            .ToolBar(toolbar =>
                            {
                                toolbar.Custom().Text("CAMPAIGNS").HtmlAttributes(new { id = "btnCampaignLabel" });
                                toolbar.Create();
                                toolbar.Save();
                            })
                            .Editable(editable => editable.Mode(GridEditMode.InCell))
                            .Navigatable()
                            //.ClientDetailTemplateId("panelTemplate")
                            .ColumnMenu(menu =>
                            {
                                menu.ComponentType("modern");
                                menu.Columns(columns =>
                                {
                                    columns
                                .Sort("asc")
                                .Groups(groups =>
                                {
                                    groups.Add().Title("Summary Costs").Columns(new List<string> { "ProjectedTotalCost" }); ;
                                    groups.Add().Title("Detailed Costs")
                                .Columns(new List<string> { "ProjectedMailshopCost", "ProjectedPostageCost","ProjectedCopyCost","ProjectedProofreaderCost"
                                    ,"ProjectedArtCost","ProjectedListCost","ProjectedProductionManagementFee","ProjectedMergePurgeCost","ProjectedPrintingCost"
                                    ,"ProjectedQctCost"});
                                });
                                });
                            })
                            .DataSource(dataSource => dataSource
                                .Ajax()
                                .PageSize(20)
                                .Model(model =>
                                    {
                                        model.Id(p => p.Id);
                                        model.Field(p => p.Id).Editable(false);
                                        model.Field(p => p.FiscalYearId).Editable(false);
                                        model.Field(p => p.ProjectedNumberOfGifts).Editable(false);
                                        model.Field(p => p.ProjectedGrossIncomePerThousand).Editable(false);
                                        model.Field(p => p.ProjectedNetIncomePerThousand).Editable(false);
                                        model.Field(p => p.ProjectedNetIncome).Editable(false);
                                        model.Field(p => p.ProjectedGrossIncome).Editable(false);
                                        model.Field(p => p.ProjectedTotalCostPerThousand).Editable(false);
                                        model.Field(p => p.ProjectedCostPerDollarRaised).Editable(false);
                                        model.Field(p => p.ProjectedNetIncomePerDonor).Editable(false);
                                    })
                                .Read(read => read.Action("ByProgram", "Campaign", new { programId = "#=Id#" }))
                                .Create(update => update.Action("CreateFromNestedGrid", "Campaign", new { programId = "#=Id#" }))
                                .Update(update => update.Action("Update", "Campaign"))
                                .Destroy(update => update.Action("Delete", "Campaign"))
                                .Events(events => events.RequestEnd("onCampaignRequestEnd"))
                            )
                            .Pageable()
                            .Sortable()
                            .ToClientTemplate()
                    )
                    

    </script>

I have a function defined to handle the event:

    <script type="text/javascript">
         function onCampaignRequestEnd(e) {
            console.log('Campaign grid on request end");
                            var programGrid = $("#programGrid").data("kendoGrid");
            programGrid.dataSource.read();
        }
    </script>

 

No matter where I put this script on the page, I receive this error when expanding the parent grid. I even tried adding it the parent grid and received the same error. I have similar scripts defined in outer pages and have never see this happen:

 

3383:1 Uncaught ReferenceError: onCampaignRequestEnd is not defined
    at eval (eval at <anonymous> (jquery.min.js:2:2668), <anonymous>:1:14151)
    at Object.syncReady (kendo.aspnetmvc.js:983:21)
    at eval (eval at <anonymous> (jquery.min.js:2:2668), <anonymous>:1:7)
    at eval (<anonymous>)
    at jquery.min.js:2:2668
    at Function.globalEval (jquery.min.js:2:2679)
    at Ha (jquery.min.js:3:21263)
    at n.fn.init.after (jquery.min.js:3:23226)
    at n.fn.<computed> [as insertAfter] (jquery.min.js:3:24511)
    at init._toggleDetails (kendo.all.js:312399:21)

 

Grid
Aleksandar
Telerik team
 answered on 07 Jun 2023
1 answer
157 views
LoadContentFrom not working after upgrade to 2023.1.425 version

Hi,

I upgraded Telerik version in our project (Telerik.UI.for.AspNet.Core nuget) from version 2021.2.616 to version 2023.1.425 and since then is for TabStrip component not working LoadContentFrom.

I have in my controller method like this:

public IActionResult GetProductListPartial()
{
     return PartialView("_ProductList");
}

And in my View I have code like this:

 @(Html.Kendo().TabStrip()
                .Name("tabstrip")
                .Items(tabstrip =>
                {
                    tabstrip.Add()
                            .Text(@Localizer["Menu.ProductList"])
                            .Selected(true)
                            .LoadContentFrom("GetProductListPartial", "ProductList")
                            .ContentHtmlAttributes(new { @class = "product-list-tab" });
                }))

When I reworked implementation in the View, then it started to work again:

 @(Html.Kendo().TabStrip()
              .Name("tabstrip")
              .Items(tabstrip =>
              {
                  tabstrip.Add().Text(@Localizer["Menu.ProductList"])
                      .Selected(true)
                       //.LoadContentFrom("GetProductListPartial", "ProductList")
                      .Content(@<text>@await Html.PartialAsync("_ProductList")</text>)
                      .ContentHtmlAttributes(new { @class = "product-list-tab" });
              }))
My point is, I didn't find anywhere, that LoadContentFrom is not supported anymore and also in application it's still buildable and looks like it should work. What is the required change for working it again please?
TabStrip
Alexander
Telerik team
 answered on 31 May 2023
1 answer
139 views
where is the datepicker.dll located
I have Visual Studio 2022 installed and want to use datepicker. Where is the datepicker.dll locate so I can reference it?
Date/Time Pickers
Alexander
Telerik team
 answered on 30 May 2023
1 answer
506 views
Styling for Dialiog in .NET Core

I'm wondering if there is any support for styling a Dialog in the .net core version of telerik that I am trialling right now?  The documentation lists the ability to add a cssclass but that is only for the button, not for the entire dialog itself, I need to replicate previous functionality we were using where a cssclass is applied to the object in javascript when the dialog has been open for a certain amount of time.

This was the only documentation I could find and it's only able to add a class to the button, not the entire dialog.

Configuration, methods and events of Kendo UI Dialog - Kendo UI for jQuery (telerik.com)

Dialog
Styling
Alexander
Telerik team
 answered on 29 May 2023
1 answer
389 views
Using Skip/Take Grid Displays No Records

I have a grid defined as such:

@(Html.Kendo().Grid<AuditViewModel>()
    .Name("AuditLogGrid")
    .Columns(columns =>
    {
        columns.Bound(c => c.Id).Hidden(true);
        columns.Bound(c => c.UserId).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
        columns.Bound(c => c.TableName).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
        columns.Bound(c => c.AuditType).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
        columns.Bound(c => c.KeyValuesValue).Encoded(false).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
        columns.Bound(c => c.OldValuesValue).Encoded(false).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
        columns.Bound(c => c.NewValuesValue).Encoded(false).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
        columns.Bound(c => c.ChangedColumnsValue).HtmlAttributes(new { @class = "k-text-right", style = "vertical-align: text-top" });
    })
    .Pageable(pager => pager.Refresh(true))
    .Sortable()
    .Filterable()
    .NoRecords()
    .DataSource(dataSource => dataSource
        .Ajax()
        .Batch(true)
        .PageSize(10)
        .ServerOperation(true)
        .Events(events => events.Error("error_handler"))
        .Model(model =>
        {
            model.Id(p => p.Id);
            model.Field(p => p.UserId);
            model.Field(p => p.TableName);
            model.Field(p => p.AuditType);
            model.Field(p => p.KeyValuesValue);
            model.Field(p => p.OldValuesValue);
            model.Field(p => p.NewValuesValue);
            model.Field(p => p.ChangedColumnsValue);
        })
        .Read(read => read.Action("GetAuditLogs", "Audit").Data("forgeryToken"))
    ))

And in my "GetAuditLogs" controller methods, I pass in the "request.Page" and "request.PageSize" to calculate Skip and Take.  The EF query call DOES return records (default is set to 10 records) however when returning from the Controller, the Grid displays "No Records"

My controller method is as follows:


[HttpPost]
    [ValidateAntiForgeryToken]
    public async Task<IActionResult> GetAuditLogsAsync([DataSourceRequest] DataSourceRequest request)
    {
        _logger.LogDebug("GetAuditLogsAsync()");
        try
        {
            var logs = await _auditService.GetAsync(null, q => q.OrderByDescending(x => x.DateTime),
                string.Empty, request.Page, request.PageSize);
            var total = await _auditService.CountAsync(null, string.Empty);
            var models = logs.Select(x => new AuditViewModel
            {
                Id = x.Id,
                UserId = x.UserId,
                DateTime = x.DateTime,
                TableName = x.TableName,
                AuditType = x.Type,
                KeyValues = string.IsNullOrWhiteSpace(x.PrimaryKey) ? new Dictionary<string, object>() :
                    JsonSerializer.Deserialize<Dictionary<string, object>>(x.PrimaryKey),
                OldValues = string.IsNullOrWhiteSpace(x.OldValues) ? new Dictionary<string, object>() :
                    JsonSerializer.Deserialize<Dictionary<string, object>>(x.OldValues),
                NewValues = string.IsNullOrWhiteSpace(x.NewValues) ? new Dictionary<string, object>() :
                    JsonSerializer.Deserialize<Dictionary<string, object>>(x.NewValues),
                ChangedColumns = string.IsNullOrWhiteSpace(x.AffectedColumns) ? new List<string>() :
                    JsonSerializer.Deserialize<List<string>>(x.AffectedColumns)
            });

            var result = await models.ToDataSourceResultAsync(request);
            result.Total = total;
            return Json(result);
        }
        catch (Exception ex)
        {
            _logger.LogError($"GetAuditLogsAsync() | error [{ex}]", ex);
            throw;
        }
    }

And the Audit Service "GetAsync" looks like:


public async Task<IEnumerable<Data.Entities.Audit>> GetAsync(
        Expression<Func<Data.Entities.Audit, bool>>? filter = null,
        Func<IQueryable<Data.Entities.Audit>, IOrderedQueryable<Data.Entities.Audit>>? orderBy = null,
        string includeProperties = "",
        int page = 0,
        int pageSize = 0)
    {
        IQueryable<Data.Entities.Audit> query = _dbSet;
        if (filter != null)
        {
            query = query.Where(filter);
        }

        if (!string.IsNullOrWhiteSpace(includeProperties))
        {
            query = includeProperties.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries)
                .Aggregate(query, (current, includeProperty) => current.Include(includeProperty));
        }

        var result = orderBy != null
            ? orderBy(query)
            : query;

        if (page > 0 && pageSize > 0)
        {
            result = result.Skip((page - 1) * pageSize).Take(pageSize);
        }

        return await result.ToListAsync();
    }

I have verified that the returned results ARE correct (based on Id's), but the Grid displays "No Records".  I'd rather not return the ENTIRE dataset to the grid as it is quite large (and the models can be large - this is for auditing so it contains EVERYTHING that was modified).  Is there something I'm missing?
Grid
Mike
Top achievements
Rank 1
Iron
 answered on 28 May 2023
1 answer
193 views
Grid Column Filter/Sort With Client Template

I have a grid defined as thus:

@(Html.Kendo().Grid<SubServiceViewModel>()
    .Name("SubServiceGrid")
    .Columns(columns =>
    {
        columns.Bound(c => c.Id).Hidden(true);
        columns.Bound(c => c.Service)
            .ClientTemplate("#=Service.Value#")
            .Filterable(false)
            .Sortable(false);
        columns.Bound(c => c.Value);
        columns.Bound(c => c.Active).Hidden(true);
        columns.Bound(c => c.Deleted).Hidden(true);
        columns.Command(c => c.Destroy());
    })
    .ToolBar(toolbar =>
    {
        toolbar.Create();
        toolbar.Save();
    })
    .Editable(editable => editable.Mode(GridEditMode.InCell))
    .Pageable(pager => pager.Refresh(true))
    .Sortable()
    .Filterable()
    .NoRecords()
    .DataSource(dataSource => dataSource
        .Ajax()
        .Batch(true)
        .PageSize(10)
        .ServerOperation(true)
        .Events(events => events.Error("error_handler").RequestEnd("onRequestEnd('staticNotifications')"))
        .Model(model =>
        {
            model.Id(p => p.Id);
            model.Field(p => p.Service).DefaultValue(ViewData["defaultService"] as ServiceViewModel);
            model.Field(p => p.Value);
            model.Field(p => p.Active).DefaultValue(EntityLiterals.Yes);
            model.Field(p => p.Deleted).DefaultValue(EntityLiterals.No);
        })
        .Read(read => read.Action("GetSubServices", "SubService").Data("forgeryToken"))
        .Create(create => create.Action("CreateSubServices", "SubService").Data("forgeryToken"))
        .Update(update => update.Action("UpdateSubServices", "SubService").Data("forgeryToken"))
        .Destroy(destroy => destroy.Action("DeleteSubServices", "SubService").Data("forgeryToken"))
    ))

And if I remove the 

.Filterable(true)

I get a JS error when I click the column filter button


Uncaught TypeError: Cannot convert undefined or null to object
    at Function.keys (<anonymous>)
    at C (kendo.all.js:318535:21)
    at init._createForm (kendo.all.js:318535:21)
    at init._init (kendo.all.js:318535:21)
    at init._click (kendo.all.js:318535:21)
    at HTMLAnchorElement.dispatch (jquery.min.js?v=oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl-cbzUq8:2:43184)
    at y.handle (jquery.min.js?v=oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl-cbzUq8:2:41168)
C @ kendo.all.js:318535
_createForm @ kendo.all.js:318535
_init @ kendo.all.js:318535
_click @ kendo.all.js:318535
dispatch @ jquery.min.js?v=oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl-cbzUq8:2
y.handle @ jquery.min.js?v=oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl-cbzUq8:2
However, because I'm using InCell editing, I have a ViewData object populated with my DropDown items (with the UI Hint), similar to the demo.  Is there any way around this?
Filter
Grid
Mike
Top achievements
Rank 1
Iron
 answered on 25 May 2023
1 answer
65 views
How to view display number selected when number of items selected is very large.

 

I'm using Trial for testing. But when the number of items is selected more, the text box displaying the item grows larger, breaking the interface of the page. I just want to show the number of selected items (Checked) to replace checked items, is it possible to process? Please guide how. Displays fine both when the event is selected and the initial default load of items is checked.

 

Example:

DropDownTree
Mihaela
Telerik team
 answered on 24 May 2023
Narrow your results
Done
Selected tags
Tags
Grid
General Discussions
DropDownList
Chart
Editor
Scheduler
Form
TreeList
Upload
Installer and VS Extensions
Date/Time Pickers
Spreadsheet
TabStrip
ListView
MultiSelect
Menu
ComboBox
Window
Filter
PDFViewer
TreeView
AutoComplete
Toolbar
TextBox
Wizard
Button
ListBox
NumericTextBox
Checkbox
DropDownTree
FileManager
Styling
PanelBar
TileLayout
DateRangePicker
PivotGrid
Timeline
Dialog
Gantt
Template
Calendar
ImageEditor
Localization
Security
ToolTip
Pager
Splitter
Switch
OrgChart
Accessibility
Breadcrumb
Drawer
MaskedTextBox
MultiColumnComboBox
Notification
RadioGroup
ScrollView
TaskBoard
Gauge
Loader
TextArea
Popover
Card
Chat
CheckBoxGroup
ColorPicker
DateInput
Diagram
ExpansionPanel
Stepper
Barcode
ResponsivePanel
Sortable
GridLayout
AppBar
FloatingActionButton
Licensing
ProgressBar
QRCode
Captcha
DockManager
VS Code Extension
Badge
MultiViewCalendar
Rating
Slider
ActionSheet
SkeletonContainer
Avatar
ColorGradient
DropDownButton
Signature
ChipList
BottomNavigation
BulletGraph
Collapsible
RadioButton
Ripple
Sparkline
TreeMap
CircularGauge
HeatMap
PivotGridV2
FlatColorPicker
CircularProgressBar
ColorPalette
SplitButton
StackLayout
TimeDurationPicker
Chip
ToggleButton
AIPrompt
PropertyGrid
Sankey
OTPInput
ChartWizard
+? more
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
35 36
37
38 39
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how