or
[ { "CategoryText" : "Previous", "SeriesValue" : 321131.5225 }, { "CategoryText" : "Current", "SeriesValue" : 300059.4610 }]var DELAY = 400;
function createGenericBarChart(ChartName, JsonPath, ChartType, Title, LegendVisible, LegendPosition, CategoryLabelRotation, ValueLabelRotation, Stacked, SeriesLabelsVisible, SeriesLabelsFormat, ToolTipLabelFormat, CategoryAxisField, BarSeriesDefinition, Maximized) { $(ChartName).kendoChart({ dataSource: { transport: { read: { url: JsonPath, dataType: "json" } } }, title: { text: Title, font: '14px Arial' }, legend: { position: LegendPosition, visible: LegendVisible, font: '8px Arial' }, seriesDefaults: { type: ChartType, stack: Stacked, labels: { visible: SeriesLabelsVisible, position: "outsideEnd", format: SeriesLabelsFormat, font: '10px Arial' } }, series: BarSeriesDefinition, valueAxis: { labels: { visible: true, rotation: ValueLabelRotation, font: '10px Arial' } }, categoryAxis: { field: CategoryAxisField, labels: { rotation: CategoryLabelRotation, font: '10px Arial' } }, tooltip: { visible: true, font: '12px Arial' } });}<div id="dshitem1_1_divChart" class="Chart" style="z-index:8999;">1</div> <script>function DashboardCaller1(chartid, maximized) { var BarSeries = [{ field: "SeriesValue", name: "SeriesValue"}];createGenericBarChart(chartid, '2626_1_Bar - Airline Contract AC -SUN_.json?id=59bd4fee-511f-480b-bbee-88c3051b800d', 'column', 'Bar - Airline Contract AC -SUN', false, 'top', -45, 0, false, false, '{0:N2}', '{0:N2}', 'CategoryText', BarSeries, maximized); }setTimeout(function() {DashboardCaller1('#dshitem1_1_divChart', false);}, 1 * DELAY);</script></div><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ians_samples.Default" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <script src="js/kendo/jquery.min.js" type="text/javascript"></script> <script src="js/kendo/kendo.all.min.js" type="text/javascript"></script> <link href="css/default.css" rel="Stylesheet" /> <link href="css/kendo/kendo.common.min.css" rel=Stylesheet /> <link href="css/kendo/kendo.default.min.css" rel=Stylesheet /> <style> </style></head><body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> <Services> <asp:ServiceReference Path="~/data_reader_webservice.asmx" /> </Services> </asp:ScriptManager> <div> <div class="k-content"> <div id="splitter_test" style="height: 300px;"> <div> <p> Top </p> </div> <div> <div id="grid_test"> </div> </div> <div> <p> Bottom </p> </div> </div> </div> <script> $(document).ready(function () { $("#splitter_test").kendoSplitter({ orientation: "vertical", panes: [ { collapsible: false, resizable: true, size: "50px" }, { collapsible: false, resizable: true }, { resizable: true, size: "50px" } ] }); var dataSource = new kendo.data.DataSource({ transport: { read: { type: "POST", url: "data_reader_webservice.asmx/GetHistoryLogXml" } }, schema: { type: "xml", data: "/tblHistoryLog/tblHistoryLog", model: { fields: { LogID: "LogID/text()", LogDate: "LogDate/text()", Modules: "Modules/text()", Message: "Message/text()" } } } }); $("#grid_test").kendoGrid({ dataSource: dataSource, columns: [ { field: "LogID", title: "Log ID" }, { field: "LogDate", title: "Log Date" }, { field: "Modules", title: "Module" }, { field: "Message", title: "Message" } ] }); }); </script> </div> </form> </body></html><tblHistoryLog> <tblHistoryLog> <LogID>2211410</LogID> <LogDate>2012-02-08T10:20:48.933-05:00</LogDate> <Modules>TAL</Modules> <Message>The AeroScout tagging system has reported movement of tag 000CCC77332E to local position (21536,16149,0) within map Coleman Mine 4700 Level.</Message> <MessageType>0</MessageType> <UltimateTriggerID>2211410</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211411</LogID> <LogDate>2012-02-08T10:20:48.933-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211410</ProximateTriggerID> <UltimateTriggerID>2211410</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211408</LogID> <LogDate>2012-02-08T10:20:04.58-05:00</LogDate> <Modules>TAL</Modules> <Message>The AeroScout tagging system has reported movement of tag 000CCC77332E to local position (21536,16149,0) within map Coleman Mine 4700 Level.</Message> <MessageType>0</MessageType> <UltimateTriggerID>2211408</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211409</LogID> <LogDate>2012-02-08T10:20:04.58-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211408</ProximateTriggerID> <UltimateTriggerID>2211408</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211406</LogID> <LogDate>2012-02-08T10:19:18.387-05:00</LogDate> <Modules>TAL</Modules> <Message>The AeroScout tagging system has reported movement of tag 000CCC77332E to local position (21536,16149,0) within map Coleman Mine 4700 Level.</Message> <MessageType>0</MessageType> <UltimateTriggerID>2211406</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211407</LogID> <LogDate>2012-02-08T10:19:18.387-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211406</ProximateTriggerID> <UltimateTriggerID>2211406</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211404</LogID> <LogDate>2012-02-08T10:17:48.15-05:00</LogDate> <Modules>TAL</Modules> <Message>The AeroScout tagging system has reported movement of tag 000CCC77332E to local position (21536,16149,0) within map Coleman Mine 4700 Level.</Message> <MessageType>0</MessageType> <UltimateTriggerID>2211404</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211405</LogID> <LogDate>2012-02-08T10:17:48.15-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211404</ProximateTriggerID> <UltimateTriggerID>2211404</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211403</LogID> <LogDate>2012-02-08T10:16:17.743-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211402</ProximateTriggerID> <UltimateTriggerID>2211402</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211402</LogID> <LogDate>2012-02-08T10:16:17.73-05:00</LogDate> <Modules>TAL</Modules> <Message>The AeroScout tagging system has reported movement of tag 000CCC77332E to local position (21536,16149,0) within map Coleman Mine 4700 Level.</Message> <MessageType>0</MessageType> <UltimateTriggerID>2211402</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211400</LogID> <LogDate>2012-02-08T10:15:31.61-05:00</LogDate> <Modules>TAL</Modules> <Message>The AeroScout tagging system has reported movement of tag 000CCC77332E to local position (21536,16149,0) within map Coleman Mine 4700 Level.</Message> <MessageType>0</MessageType> <UltimateTriggerID>2211400</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211401</LogID> <LogDate>2012-02-08T10:15:31.61-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211400</ProximateTriggerID> <UltimateTriggerID>2211400</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog> <tblHistoryLog> <LogID>2211399</LogID> <LogDate>2012-02-08T10:14:01.313-05:00</LogDate> <Modules>TAL</Modules> <Message>Entity 239 has entered Zone 21. Its current position is (9290.36412811279,-23460,-7493.75833129883).</Message> <MessageType>1</MessageType> <ProximateTriggerID>2211398</ProximateTriggerID> <UltimateTriggerID>2211398</UltimateTriggerID> <IsMultiTrigger>false</IsMultiTrigger> </tblHistoryLog><tblHistoryLog>using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.Services;using System.Data;using System.Configuration;using System.Data.SqlClient;using System.Web.Script.Services;using System.Web.Script.Serialization;using System.Text;namespace ians_samples{ /// <summary> /// Summary description for data_reader_webservice /// </summary> [WebService(Namespace = "ians_samples")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] [System.Web.Script.Services.ScriptService] public class data_reader_webservice : System.Web.Services.WebService { [WebMethod] public DataSet GetHistoryLogDataSet() { DataSet returnSet = new DataSet(); string sConn = ConfigurationManager.ConnectionStrings["NRG-ECO_DB"].ToString(); string sSQL = "SELECT * FROM tblHistoryLog WHERE LogDate BETWEEN '" + DateTime.Now.AddDays(-100).ToString() + "' AND '" + DateTime.Now.ToString() + "' ORDER BY LogDate DESC"; SqlDataAdapter da = new SqlDataAdapter(sSQL, new SqlConnection(sConn)); da.Fill(returnSet, "tblHistoryLog"); returnSet.DataSetName = "tblHistoryLog"; return returnSet; } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Xml)] public string GetHistoryLogXml() { DataSet returnSet = new DataSet(); string sConn = ConfigurationManager.ConnectionStrings["NRG-ECO_DB"].ToString(); string sSQL = "SELECT * FROM tblHistoryLog WHERE LogDate BETWEEN '" + DateTime.Now.AddDays(-100).ToString() + "' AND '" + DateTime.Now.ToString() + "' ORDER BY LogDate DESC"; SqlDataAdapter da = new SqlDataAdapter(sSQL, new SqlConnection(sConn)); da.Fill(returnSet, "tblHistoryLog"); returnSet.DataSetName = "tblHistoryLog"; return returnSet.GetXml(); } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public string GetHistoryLogJSON() { DataTable returnSet = new DataTable(); string sConn = ConfigurationManager.ConnectionStrings["NRG-ECO_DB"].ToString(); string sSQL = "SELECT * FROM tblHistoryLog WHERE LogDate BETWEEN '" + DateTime.Now.AddDays(-100).ToString() + "' AND '" + DateTime.Now.ToString() + "' ORDER BY LogDate DESC"; SqlDataAdapter da = new SqlDataAdapter(sSQL, new SqlConnection(sConn)); da.Fill(returnSet); return GetJSONString(returnSet); } // borrowed from http://weblogs.asp.net/navaidakhtar/archive/2008/07/08/converting-data-table-dataset-into-json-string.aspx public static string GetJSONString(DataTable Dt) { string[] StrDc = new string[Dt.Columns.Count]; string HeadStr = string.Empty; for (int i = 0; i < Dt.Columns.Count; i++) { StrDc[i] = Dt.Columns[i].Caption; HeadStr += "\"" + StrDc[i] + "\" : \"" + StrDc[i] + i.ToString() + "¾" + "\","; } HeadStr = HeadStr.Substring(0, HeadStr.Length - 1); StringBuilder Sb = new StringBuilder(); Sb.Append("{\"" + Dt.TableName + "\" : ["); for (int i = 0; i < Dt.Rows.Count; i++) { string TempStr = HeadStr; Sb.Append("{"); for (int j = 0; j < Dt.Columns.Count; j++) { TempStr = TempStr.Replace(Dt.Columns[j] + j.ToString() + "¾", Dt.Rows[i][j].ToString()); } Sb.Append(TempStr + "},"); } Sb = new StringBuilder(Sb.ToString().Substring(0, Sb.ToString().Length - 1)); Sb.Append("]}"); return Sb.ToString(); } }}<div class="frame"><div class="left-nav"></div><div class="content"></div><div class="clear"></div></div>$(".frame").kendoSplitter({ panes: [ { collapsible: true,size:"200px",max:"200px"}, {},{} ] });