Public Int Id{get;set}
Public string Desc{get;set}
Public bool IsValid;set}
columns.Bound(c => c.isValid).Filterable(f => f
.Cell(c => c.Template("MyBooleanCellTemplate"))
).ClientTemplateId("isValid").Title("Valid");
<script id="isValid" type="text/x-kendo-template">
#if(isValid){#
<i style='color:green;font-size:20px;' class='k-icon k-i-check'></i>
#}else{#
<i style='color:red;font-size:20px;' class='k-icon k-i-x'></i>
#}#
</script>
<script>
function MyBooleanCellTemplate(args) {
var radioInput = $("<input type='checkbox'/>");
var wrapper = args.element.parent();
var inputName = kendo.guid.
args.element.remove();
var labelTrue = $("<label/>")
.text("")
.append(radioInput);
radioInput.attr(kendo.attr("bind"), "checked:value") // Add the "bind" attribute, specify the unique and, and set a value.
.attr("name", inputName)
.val("true");
wrapper.append([labelTrue]);
};
</script>
Hello,
I have following MultiSelectFor:
@(Html.Kendo().MultiSelectFor(x => x.TitleAttachmentForm.AuthorsList)
.AutoBind(true)
.DataTextField("SearchValue")
.DownArrow()
.DataValueField("Id")
.DataSource(ds => ds
.Custom()
.Transport(transport => transport
.Read(r => r
.Url("?handler=AuthorPublisherRead").Data("authorDataFunction")
))
.ServerFiltering(true)
)
.Filter(FilterType.StartsWith)
.Height(400)
.ItemTemplate("<span class=\"k-state-default \"><strong>#= (data.Title == null) ? '' : data.Title # #: data.Firstname # #: data.Lastname #</strong><p>#: data.SubDisplayValue #</p></span>")
.TagTemplate("<span>#= (data.Title == null) ? '' : data.Title # #: data.Firstname # #: data.Lastname #</span>")
)
The MultiSelectFor is binded to following remote api:
public async Task<JsonResult> OnGetAuthorPublisherRead([CanBeNull] string filterValue, [CanBeNull] string bindedvalue)
{ //Deleted }
This is used to filter for items on the remote site and get the binded value.
In my DropDownListFor I can use authorDataFunction to receive the value and the text of my DropDown:
function authorDataFunction() { return { __RequestVerificationToken: kendo.antiForgeryTokens().__RequestVerificationToken, filterValue: $("#mydropdown").getKendoDropDownList().filterInput.val(), bindedvalue: $("#mydropdown").getKendoDropDownList().value() }; }
I played around with the api, however, I am not able to receive the input text and value(s):
function authorDataFunction() { var multiselect = $("#TitleAttachmentForm_AuthorsList").data("kendoMultiSelect"); return { __RequestVerificationToken: kendo.antiForgeryTokens().__RequestVerificationToken, filterValue: multiselect.filterInput.val(), bindedvalue:multiselect.value() }; }
Its telling me, that filterInput is undefined. also multiselect.text() does not work.
How can I access the binded value and the input in the .net core component?
How do you specify the default sort order of rows/columns in a PivotGrid?
My controller has this method
public IActionResult PivotGrid()
{
IEnumerable<ResponseReportPivot> objResponseList = _db.ResponseReportPivot;
var sortedResponseList = objResponseList.OrderBy(s => s.EventYear).ThenBy(s => s.Venue);
return View(sortedResponseList);
}
When I run the pivot I get the display in Pivot Display.jpg attached.
If I change the OrderBy clauses, I get the display in Pivot display 2.jpg.
I know the user can change the sort but I want the column display to default to be Event Year ascending and the row display to default to Venue ascending.
I haven't seen anywhere how that can be accomplished.
Here's the pivot grid code
@*For local binding*@
@using Application.Models;
@using Kendo.Mvc.Extensions;
@using Kendo.Mvc.UI;
@model IEnumerable<ResponseReportPivot>
@{
ViewBag.Title = "Response Report Pivot Grid";
}
@Html.AntiForgeryToken()
<style>
.k-pivot-table .k-grid-content td {
text-align: left;
}
</style>
<div class="k-pivotgrid-wrapper">
@(Html.Kendo().PivotConfigurator()
.Name("configurator")
.HtmlAttributes(new { @class = "hidden-on-narrow" })
.Filterable(true)
.Sortable(true)
.Height(570)
)
@(Html.Kendo().PivotGrid<ResponseReportPivot>()
.Name("pivotgrid")
.Configurator("#configurator")
.ColumnWidth(120)
.Filterable(true)
.Height(570)
.Sortable(true)
.BindTo(Model)
.DataSource(dataSource => dataSource
.Ajax()
.Schema(schema => schema
.Cube(cube => cube
.Dimensions(dimensions =>
{
dimensions.Add(model => model.Venue).Caption("All Venues");
dimensions.Add(model => model.EventYear).Caption("All Years");
})
.Measures(measures =>
{
measures.Add("Count").Field(model => model.Venue).AggregateName("count");
})
))
.Columns(columns =>
{
columns.Add("EventYear").Expand(true);
})
.Rows(rows => rows.Add("Venue").Expand(true))
.Measures(measures => measures.Values("Count"))
.Events(e => e.Error("onError"))
)
)
</div>
<div class="responsive-message"></div>
<script>
function onError(e) {
alert("error: " + kendo.stringify(e.errors[0]));
}
</script>
I have a bool column
public bool isValid {set;get}
I have defined a custom template and filter.
columns.Bound(c => c.isValid).Filterable(f => f
.Cell(c => c.Template("MyBooleanCellTemplate"))
).ClientTemplateId("isValid").Title("Valid").Width(75);
<script>
function MyBooleanCellTemplate(args) {
var radioInput = $("<input type='radio'/>"); // Get the radio input element.
var wrapper = args.element.parent(); // Obtain the parent container of the radio buttons.
var inputName = kendo.guid(); // Specfify an unique element.
args.element.remove(); // Remove the element.
var labelTrue = $("<label/>")
.text("")
.append("<i style='color:green; font-size: 20px;' class='k-icon k-i-check'></i>")
.append(radioInput); // Create a label that will contain the icon and add it to the radio input.
radioInput.attr(kendo.attr("bind"), "checked:value") // Add the "bind" attribute, specify the unique and, and set a value.
.attr("name", inputName)
.val("true");
var labelFalse = labelTrue.clone() // Create a label for the second radioInput that will contain an icon.
.text("")
.append("<i style='color:red; font-size: 20px;' class='k-icon k-i-x'></i>");
radioInput.clone() // Clone the previously obtained radio button, set its value and append to the previously created label.
.val("false")
.appendTo(labelFalse);
wrapper.append([labelTrue, labelFalse]); // Append both of the created labels.
};
</script>
Also I have set default true on pageload.
I only want to see true or false value not both,
How remove the filter clear icon.
I am using the telerik report designer to build my reports and html report viewer to display them.
When I use MySql.Data.MyqlClient with a standard connection string (server, uid etc) everything works fine.
When I use a ODBC dsn connection however, the connection works on the report builder but on the report viewer it says the following:
An error has occurred while processing Table 'table2':Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.------------- InnerException -------------Keyword not supported: 'dsn'
I do have System.Data.Odbc installed as this is what I used for my db connections and this is also what the report builder uses.
Telerik Reporting v16.2
.Net core 6 (long term support)
Hi,
I'm having an issue getting a foreign key column to persist in the grid. Here's my grid...
@(Html.Kendo().Grid<GridDataItem>(Model.GridDataItems)
.Name(
"gridDataItems"
)
.Columns(columns =>
{
columns.Bound(model => model.Name);
columns.ForeignKey(model => model.ChildDataItemId, Model.AllChildDataItems,
"Id"
,
"Value"
);
//.EditorTemplateName("_ForeignKeyDropDown");
columns.Command(command =>
{
command.Edit();
}).Width(172);
})
.ToolBar(toolbar => toolbar.Create())
.Editable(editable => editable.Mode(GridEditMode.PopUp))
.DataSource(dataSource => dataSource
.Ajax()
.PageSize(20)
.ServerOperation(
false
)
.Model(model =>
{
model.Id(p => p.Id);
})
)
)
Here's the controller...
public
class
GridTestController : Controller
{
public
IActionResult Index()
{
var viewModel =
new
GridTestModel
{
GridDataItems =
new
List<GridDataItem>
{
new
GridDataItem
{
Id = 1,
Name =
"Record 1"
,
ChildDataItemId = 2
},
new
GridDataItem
{
Id = 2,
Name =
"Record 2"
,
ChildDataItemId = 3
},
new
GridDataItem
{
Id = 3,
Name =
"Record 3"
}
}
};
return
View(viewModel);
}
}
and here's the Model...
public
class
GridTestModel
{
public
List<GridDataItem> GridDataItems {
get
;
set
; }
public
List<ChildDataItem> AllChildDataItems
{
get
{
return
new
List<ChildDataItem>
{
new
ChildDataItem
{
Id = 1,
Value =
"Option 1"
},
new
ChildDataItem
{
Id = 2,
Value =
"Option 2"
},
new
ChildDataItem
{
Id = 3,
Value =
"Option 3"
}
};
}
}
}
public
class
GridDataItem
{
public
int
Id {
get
;
set
; }
public
string
Name {
get
;
set
; }
public
int
? ChildDataItemId {
get
;
set
; }
public
ChildDataItem ChildDataItem {
get
;
set
; }
}
public
class
ChildDataItem
{
public
int
Id {
get
;
set
; }
public
string
Value {
get
;
set
; }
}
The values for Option 1 and Option 2 can be updated fine (as they're preset with a non-null value) but I'm not able to select a value for the Option 3 record nor am I able to set the foreign key value (ChildDataItemId) for a new record.
Anyone an idea as to why? I've also tried a custom editor template for the drop down field using .ValuePrimitive(true) but this has no effect.
Thanks
Stuart.
We're using Kendo Grids for our .NET Core application. We display checkbox lists in the column headers so the user can filter in the Kendo Grid. The problem is that the items in these checkbox list are not sorted (even if we pass sorted items to it).
We tried to add a fix by adding the following FilterMenuInit client side event to try to sort the checkbox list column header items
function onFilterMenuInit(e) {
var filterMultiCheck = this.thead.find("[data-field='" + e.field + "']").data("kendoFilterMultiCheck");
if (filterMultiCheck) {
filterMultiCheck.container.empty();
filterMultiCheck.checkSource.sort({ field: e.field, dir: "asc" });
filterMultiCheck.checkSource.data(filterMultiCheck.checkSource.view().toJSON());
filterMultiCheck.createCheckBoxes();
}
}
The fix is causing the following issue:
VM4956:3 Uncaught TypeError: Cannot read properties of null (reading 'Id')
at eval (eval at filter (kendo.min.js:9:168981), <anonymous>:3:25)
at r.filter (kendo.min.js:9:169113)
at r.process (kendo.min.js:9:171128)
at init._queryProcess (kendo.min.js:9:190070)
at init.query (kendo.min.js:9:191247)
at init._query (kendo.min.js:9:191778)
at init.filter (kendo.min.js:9:192662)
at init._filter (kendo.min.js:9:918467)
at HTMLFormElement.r (website.min.js:14:21692)
at HTMLFormElement.dispatch (website.min.js:14:57771)
This is happening on the Kendo side. Is this a bug? Is there an alternative way to sort these checkbox list in the column headers?
Scenario and Issue:
I had a Tabstrip with three tabs,
in each tab there are four DropDownList and four line charts.
However, If I bind all the data once (Include DropDownLists and Line Charts in three tabs),
the page would rendered slowly and caused some of the data loss binding.
Question1 :
I'm wondering if it's possible to render Line Chart before data binding?
then I'll data bind it after DropDownList Select event was triggered.
Or is there any other alternative ways?
What I've Tried
The TabStrip is in a partialview,
once a button was clicked the partialview will be load with javascript function by.
$("#myHtmlElementId").load('@Url.Action("MyAction","MyController")', params)
The complicated part is the line chart in initial tab strip was data binded with local binding the data passed by ViewBag.
And if I try to render the other line chart while the second or third TabStrip Item was selected.
It's logic would be conflict, if the user clicked the first TabStrip again.
Since the line chart were data binded with local data by ViewBag,
and the others in 2nd or 3rd TabStrip were renderd while the TabStrip item was selected,
And the selected event would call a javascript function to render another partial view to fill content into the TabStrip.
Is there something like TabStrip initial event?
So that I could also fill the first Tabstrip item contents same as the 2nd or 3rd TabStrip.
Hi,
I want to use the Upload function to read data in excel spreadsheet. The requirement is to show a pop up to prompt the user to delete any existing data before uploading any new data.
How to show this pop up. Could you please help?
Regards,
Monika
I have a checkbox that is checked on a form but it should send its value on the post but should not be editable
The editor template looks like this
@(Html.Kendo().CheckBoxFor(m => m) .Label(label) .Enable(enable) .HtmlAttributes(ViewData) .Deferred(deferred) )
The checkbox does not have a readonly functionality like the textbox
Can this be achieved? I tried adding a hidden field like @Html.HiddenFor(m => m) but that generates another input with the same id