var investorDataSource = new kendo.data.DataSource({
type: "json",
transport: {
read: {
url: "http://localhost//XXXX?Name=^" + $("#searchfor").val(),
dataType: "json"
},
parameterMap: function (options) {
return {
pageindex: options.page,
pagesize: options.take,
//orderby:options.sort[0].field
orderby: convertSort(options.sort)
}
}
},
schema: {
data: function (result) {
return result.Items || result;
},
total: function (result) {
//Note: this is != to the total no of records, but should work
return (result.PageSize * result.PageCount) || result.length || 0;
}
},
serverPaging: true,
serverSorting: true,
sort: { field: "Name", dir: "asc" },
serverFiltering: true,
pageSize: 10
});
{ field: "tblCategory", title: "Category"}