Kendo Grid and Chart
by Zaheer Ahmed
HTML
<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.3.1315/styles/kendo.common.min.css">
<script src="http://cdn.kendostatic.com/2012.3.1315/js/kendo.all.min.js"></script>
<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.3.1315/styles/kendo.default.min.css">
<button type="button"id="btnExport" >Export to csv!</button>
<div id="grid"></div>
CSS
* {
font-size: 10pt;
}
JavaScript
$("#datetimepicker").kendoDateTimePicker({
showSecond: true,
dateFormat: "dd-mm-yy",
timeFormat: "HH:mm:ss",
format : "dd-MM-yy HH:mm:ss"});
$("#datetimepicker1").kendoDateTimePicker({
showSecond: true,
dateFormat: "dd-mm-yy",
timeFormat: "HH:mm:ss",
format : "dd-MM-yy HH:mm:ss"});
var result=$("#grid").kendoGrid({
filterable: true,
columns: [
{ field: "FirstName", title: "First Name" },
{ field: "LastName", title: "Last Name" },
{ field: "dob", title: "DOB" , format: "{0:dd-MM-yy HH:mm:ss}"}
],
dataSource: {
data: [
{ FirstName: "Joe dafsd", LastName: "Smith" ,dob:"2013-02-18 19:54:13"},
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-18 20:55:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-18 21:56:15" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-18 22:57:16" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-19 20:55:20" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-24 20:56:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-26 20:57:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-02-28 20:42:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-03-22 11:55:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-03-27 20:55:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-04-18 20:55:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-04-23 20:55:14" },
{ FirstName: "Jane", LastName: "Smith" ,dob:"2013-04-24 20:55:14" }
],
schema: {
data: function (data) {
$.each(data, function (i, val) {
val.dob = kendo.parseDate(val.dob, "yyyy-MM-dd HH:mm:ss");
});
return data;
}
}
}
}).data("kendoGrid");
$("#btnExport").click(function(e) {
var dataSource = $("#grid").data("kendoGrid").dataSource;
var...