{"pageSize":2739,"results":[{"bbox":"SRID=4326;POLYGON((-70.684264 41.8879795,-70.6659898 41.8879795,-70.6659898 41.8741688,-70.684264 41.8741688,-70.684264 41.8879795))",
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Catalog Search</title> <script src="Kendo/jquery.min.js" type="text/javascript"></script> <script src="kendo/kendo.all.min.js" type="text/javascript"></script> <script src="Kendo/console.js" type="text/javascript"></script> <script src="SearchCatalog.js" type="text/javascript"></script> <link href="Styles/kendo.common.min.css" rel="stylesheet" type="text/css" /> <link href="Styles/kendo.blueopal.min.css" rel="stylesheet" type="text/css" /> <link href="Styles/SeachPageStyle.css" rel="stylesheet" type="text/css" /> </head> <body> <div> <select id="dropDownList"> <option>Search</option> </select> </div> <p> </p> <div id="gridPane"> </div> <script type="text/javascript"> $(document).ready(function () { setup(); }); </script> </body> </html>var catalogData; var catalogGrid; function buildModel() { catalogData = new kendo.data.DataSource({ type: "json", pageSize: 5, transport: { read: { url: "http://ysg4206/CatalogService/CatalogService.svc/ViewBoston", dataType: "json" } }, schema: { data: "results" }, error: function (e) { alert("data error happened: " + e) } }); } function layout() { $("#dropDownList").kendoDropDownList({ open: function (e) { doSearch() } }); $("#gridPane").kendoGrid({ pageable: true, scrollable: true, height: 250, dataSource: catalogData, columns: [{ field: "idx", title: "ID" }, { field: "classification", title: "classification" }, { field: "creator", title: "creator" }, { field: "date", title: "date" }, { field: "elevation", title: "elevation" }, { field: "datum", title: "datum" }, { field: "size", title: "size" }, { field: "type", title: "type" }, { field: "description", title: "description" }, { field: "dirLocation", title: "dirLocation" }, { field: "distributor", title: "distributor" }, { field: "egplDate", title: "egplDate" }, { field: "handling", title: "handling" }, { field: "product", title: "product" }, { field: "bbox", title: "bbox" }, { field: "uniqID", title: "uniqID" } ] }); } function setup() { buildModel(); layout(); }

.k-textbox .k-tooltip-validation
{
margin-left: -20px !important;
}

<script type="text/javascript">
$(document).ready(function () {
$("#grid").kendoGrid({
height: 360, groupable: true, scrollable: true, sortable: true, pageable: true,
columns: [{field: "name",title: "Name"},{field: "number",title: "Number"},{field: "type",title: "Type"},
{field: "low",title: "Low"},{field: "high",title: "High"},{field: "status",title: "Status"}],
dataSource: {
transport: {
read: {
// the remote service url
url: "/DomainService/KendoDomainService.svc/json/GetSpt_values",
// JSONP is required for cross-domain AJAX
dataType: "jsonp"}}},
schema: {
// the data which the data source will be bound to is in the "results" field
//data: "GetSpt_valuesResult"
}});});
</script>
When i run above URL in my browser, i get data from json. So, i have data and i have the kendo grid. The data i am fetching from the MasterDB (SQL SERVER) SPT_VALUES table.
the data snippet is as follow:
{"GetSpt_valuesResult":{"TotalCount":2506,"RootResults":
[{"high":null,"low":null,"name":"rpc","number":1,"status":0,"type":"A "},
{"high":null,"low":null,"name":"pub","number":2,"status":0,"type":"A "},
{"high":null,"low":null,"name":"sub","number":4,"status":0,"type":"A "},
{"high":null,"low":null,"name":"dist","number":8,"status":0,"type":"A "}]}}
Could you please help my in binding data as i am really new to the jquery.
Kind Regards,
waseem