hi all:
I have a problem, I have 10 column of the grid, 6 lines, now I want to calculate  this grid value of the column third total,pls help me ,thanks.

This is a Search page. where I enter the name and dept name and hit search, This should load my grid with all matching data from the backend database.
I cannot get this to work in mvc4 vs 2012. I am new to mvc and I really need help
Help!!!!!!!

Index.cshtml
@model MvcMaster.Models.SearchModel
@{
ViewBag.Title = "Search";
}
<h2>Search Policy</h2>
<section id="searchForm">
<script type="text/javascript">
//$(function () {
// $('#SearchBtn').click(function (e) {
$(document).ready(function () {
$('#SearchBtn').click(function () {
$.ajax({
type: 'POST',
contentType: "application/json; charset=utf-8",
dataType: "json",
data: '@(Url.Action("BtnClick", "Search"))',
success: function (result) {
var grid = $("#MyGrid").data("kendoGrid"); 
grid.dataSource.data(result);
grid.refresh();
}
});
return false;
})
})
</script>
@using (Html.BeginForm(new { ReturnUrl = ViewBag.ReturnUrl })) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)

<fieldset>
<legend>Search for a Policy</legend>
<ol>
<li>
@Html.LabelFor(m => m.Name)
@Html.TextBoxFor(m => m.Name)
@Html.ValidationMessageFor(m => m.Name)
</li>
<li>
@Html.LabelFor(m => m.DeptName)
@Html.TextBoxFor(m => m.DeptName)
@Html.ValidationMessageFor(m => m.DeptName)
</li> 
<input type="submit" value="Search" id="SearchBtn"/>
<div id="searchGrid">
@(Html.Kendo().Grid<MvcMaster.Models.SearchModel>()
.Name("PolicyGrid")
.AutoBind(false)
.DataSource(dataSource => dataSource.Ajax()
.Read(read => read.Action("BtnClick", "Search"))
.PageSize(20)
)
.Columns(columns =>
{
columns.Bound(c => c.Id);
columns.Bound(c => c.Name).Title("Name");
columns.Bound(c => c.EMpNumber).Title("Id");
columns.Bound(c => c.JoinDate).Title("Effective Date");
columns.Bound(c => c.DeptName).Title("Department");
})
.Pageable(page => page.Enabled(true).PageSizes(new[] {10, 20, 30, 40}))
.Sortable(sorting => sorting.SortMode(GridSortMode.SingleColumn))
.Scrollable()
 )))
</div>
</fieldset>
}
</section>

@section Scripts {
@Scripts.Render("~/bundles/jqueryval")

}

Model.cs
public class SearchModel
{
public string Id { get; set; }
public string Name { get; set; }
public string EmpNumber { get; set; }
public DateTime JoinDate { get; set; }
public stringDeptName { get; set; }
 
}

Controller
// POST: /Search/
[HttpPost]
 
public ActionResult BtnClick(string name, string DptName, [DataSourceRequest]DataSourceRequest request)
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(connectionstring))
{
SqlCommand cmd = new SqlCommand("sp_mysproc", con);
cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.AddWithValue("@searchEmpName", name);
cmd.Parameters.AddWithValue("@searchDeptName", DptName); 
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);

DataSourceResult result = dt.ToDataSourceResult(request);
 return Json(result, JsonRequestBehavior.AllowGet);
}
}

Any thought or discussions existing about adding a Kendo UI Web widget for visually filtering data sources?
(Like asp.net ajax radfilter)

We are making a new external application with asp.net mvc 4 and angular-kendo integration (AngularJS Directives) so I would have to have to try to hack in an asp.net ajax control or try to recreate it from scratch... We also have a WPF application internally and it has major use of the similar WPF RadDataFilter which our users have gotten use to over the last couple years.

Hi

Can anyone help me with defining a toolbar template for a grid that is a child of a tabstrip? As I am already using @<text> at the tabstrip level, it doesn't allow me to use it at the child grid level and throws an error. I then tried using the following code but it still produces an error:

@(Html.Kendo().TabStrip() 
.Name("tabStrip_PickingAssigment") 
.SelectedIndex(0) 
.Animation(animation => animation.Open(open => open.Fade(FadeDirection.In))) 
.Items(items => 
{ 
items.Add().Text("Assignments").Content(@<text> 
@(Html.Kendo().Grid<DataModels.Picking.PickingAssignmentViewModel>() 
.Name("grid_PickingAssigment") 
.ToolBar(toolBar => 
{ 
toolBar.Template(toolbarTemplate); 

}) 
.Columns(columns => 
{ 
columns.Bound(a => a.Id).Width(100); 
}) 
.Filterable(filterable => filterable 
.Extra(false) 
.Operators(operators => operators 
.ForString(str => str.Clear() 
.StartsWith("Starts with") 
.IsEqualTo("Is equal to") 
.IsNotEqualTo("Is not equal to") 
) 
.ForNumber(str => str.Clear() 
.IsEqualTo("Is equal to") 
.IsNotEqualTo("Is not equal to") 
.IsGreaterThan("Is greater than") 
.IsLessThan("Is less than") 
) 
.ForDate(str => str.Clear() 
.IsEqualTo("Is equal to") 
.IsNotEqualTo("Is not equal to") 
.IsGreaterThan("Is greater than") 
.IsLessThan("Is less than") 
) 
) 
) 
.Sortable() 
.Pageable(x => x.PageSizes(new int[] { 10, 20, 50, 100 }).Info(false)) 
.ColumnMenu() 
.Scrollable() 
.Resizable(resize => resize.Columns(true)) 
.Selectable(selectable => selectable.Mode(GridSelectionMode.Multiple)) 
.DataSource(dataSource => dataSource 
.Ajax() 
.Batch(false) 
.ServerOperation(true) 
.Model(model => 
{ 
model.Id(v => v.Id); 
model.Field(v => v.Id).Editable(false); 
model.Field(v => v.CreatedDate).DefaultValue(System.DateTime.Now).Editable(false); 
}) 
.Read("PickingAssignmentListByUserGroupId", "Picking", new { Id = "#=Id#" }) 
) 
.ToClientTemplate() 
) 
</text> 
); 


<script id="toolbarTemplate" type="text/x-kendo-template"> 
debugger; 
<hgroup class="title"> 
<h1>@ViewBag.Title</h1> 
</hgroup> 
@Html.Kendo().Menu().Name("GridMenu").Items(items => 
{ 
items.Add().Text(@UserInterface.Resources.GlobalRes.Delete).SpriteCssClasses("k-icon k-delete").HtmlAttributes(new { @id = "delete", @class = "k-button k-button-icontext k-grid-delete" }); 
}) 
</script>

Hi
After testing my umbraco site on IE8, I found the my kendoMenu do not style correctly and the hover do not open the submenu.

my head:


my HTML:



My JS


Any suggestion?
Note: I try the kendo menu demo on the old IE8 station, and all is working. The same site in IE11 work like a charm. What I missed out?!
Thanks
See pic1 for IE11 demo
See pic2 for IE8 demo

Hello,
I would like to create a grid with treeview as a first column. Similiar to this: image
Is it possible? How could I achieve this scenario? Grid should be filterable, scallable, scrollable and pageable.

Hello, 

is there a possibility to create a custom footer template for the grid? I haven't found anything in the examples. 

I want to implement paging with "first", "last", "previous" and "next" buttons and a textbox where a page number can be entered. 

Hi,

I need help on number formats in e.g. Kendo grid.
My number is 123456,78 and I need a format like 123.456,780.
In different threads I read formats like "{0:c}", "{0:0.000}", etc..
But I don't understand the formatting.
What means the 0 before the colon, and what possibilities I have to format the numbers?

Thanks for any help!

If I am using a standard asp.net sitemap and registering it using SiteMapManager.SiteMaps.Register, is there any way to specify areas in the site map? I've tried using area="areaname" and that doesn't seem to be working.

Thanks!

I have firefox 28.0 and windows 8.1 and Kendo 2014.1.318

Only on firefox I have following problem, that is also appearing on Kendo Demo site.

All controls with dropdowns are affected. (combo, date, etc.)

When there is no scroll on screen or scroll is top most (0), everything is working correctly,
however when I scroll down a bit, none of dropdown will be shown. It is just blinking. Showing and immediately hiding.

I've checked all controls on demo screen with dropdown and they act the same.

I was thinking it can be related to my computer, but I opened my other website with Kendo version 2013.3.1324. And all drop downs are working without this issue.
I also noticed that drop down animation is not so smooth in recent version on firefox.

Kind Regards
Marcin