So I was playing around with KendoUI and incorporated Dynamic LINQ Helpers in my ASP.NET MVC project. I followed the small tutorial here.
So far, the paging and sorting is working fine but the filtering is not working. Every time I try to filter my records, there is an exception on server side like the following
Operator '=' incompatible with operand types 'String' and 'String[]'
Can anyone help me with this?
Here is my Grid code (yes I am using Angular)
$scope.mainGridOptions = {
dataSource: {
transport: {
read: {
url: ConfigData.BaseUrl + "ChartOfAccounts/GetData",
type: 'post',
dataType: "json"
},
update: {
url: ConfigData.BaseUrl + "ChartOfAccounts/UpdateData",
type: "post",
dataType: 'json'
},
create: {
url: ConfigData.BaseUrl + "ChartOfAccounts/CreateData",
type: "post",
dataType: 'json'
},
destroy: {
url: ConfigData.BaseUrl + "ChartOfAccounts/DeleteData",
type: "post",
dataType: 'json'
}
},
serverPaging: true,
serverFiltering: true,
serverSorting: true,
pageSize: 5,
batch: true,
schema: {
data: "Data",
total: "Total",
model: {
id: "ID",
fields: {
ID: { type: "number" },
AccountNumber: { type: "string" },
AccountName: { type: "string" }
}
}
}
},
columns: [
{ field: "AccountNumber", title: "Account Number", width: "130px" },
{ field: "AccountName", title: "Account Name", width: "130px" }
]
};