or
columns: [{ field: "items__item", title: "Item Id", width: 25 }, { field: "items__name", title: "Item Name", width: 125 }, { field: "items__average_historic_price", title: "Avg Hist Price", width: 25 }, { field: "items__price_currency", title: "Currency", width: 25 }, { field: "items__quantity", title: "Quantity", width: 25 }, { field: "attribute79_value", title: "Major Customer?", width: 125 }, { field: "attribute84_value", title: "Orig City", width: 75 }, { field: "attribute85_value", title: "Orig State", width: 25 }, { field: "attribute89_value", title: "Dest City", width: 75 }, { field: "attribute90_value", title: "Dest State", width: 25 }]<script id="template" type="text/kendo-tmpl"> @(Html.Kendo().Grid<Ebook2Web.PricingGridSvc.PricingGridDetail >() .Name("PricingGridDetail_#PricingGridId#") .Columns(columns => { columns.Bound(d => d.PricingGridDetailId); columns.Bound(d => d.StartPrice); columns.Bound(d => d.EndPrice); columns.Bound(d => d.Price); columns.Bound(d => d.TierId); columns.Bound(d => d.ModifiedBy); columns.Bound(d => d.ModifiedDate); }) .DataSource(dataSource => dataSource .Ajax() .Read(read => read.Action("CreatePricingGridDetail", "PricingGrid", new { pricingGridId = "#=PricingGridId#" })) ) .ToClientTemplate() )</script>public ActionResult CreatePricingGridDetail(int pricingGridId, [DataSourceRequest] DataSourceRequest request) { var pricingGrid = PricingGrids.SingleOrDefault(x => x.PricingGridId == pricingGridId); return Json(pricingGrid.Details.ToDataSourceResult(request)); }'limit here is taking the page numberr Dim JSON_result As String = "[" 'get the data from DB and make it a JSON string Dim connection1 As New MySqlConnection(constr) connection1.Open() Dim get_Command As New MySqlCommand(get_data, connection1) Dim reader As MySqlDataReader = get_Command.ExecuteReader() While reader.Read() Dim FirstName As String = reader("fname").ToString() Dim LastName As String = reader("lname").ToString() Dim address As String = reader("address").ToString() Dim phnum As String = reader("phnum").ToString() JSON_result += "{""First Name"":""" & FirstName & """, ""Last Name"":""" & LastName& """, ""Address"":""" & address & """, ""contact"":""" & phnum& """}," End While JSON_result = JSON_result.Remove(JSON_result.Length - 1) JSON_result += "]"var grid = $("#gridAllRuns").kendoGrid({ dataSource: { type: "json", transport: { read: url_load }, schema: { total: function (response) { return 43658; } }, serverPaging: true, pageSize: 2000 }, dataBound: onDataBound, height: $(document).height() - 250, groupable: true, sortable:true, reorderable: true, //selectable: "multiple", resizable: true, pageable: true, filterable: { extra: false, operators: { string: { eq: "equal to", startswith: "starts with", neq: "not equal to" } } }, toolbar: kendo.template($("#template").html()), columns: [ { title: "First name", field: "First Name"}, { title: "Last name", field: "Last Name" }, { title: "Address", field: "Address" }] }