Is there a json/jscript function to select the filtered data when using the spreadsheet. I'm trying to find a way to limit the data that has to get serialized when I'm doing updates. Here's my Save function. I'm looking for a way to potentially replace the spreadsheetData with the filtered data set instead of the entire bound data set.
function
Save_onClick() {
var
staticNotification = $(
"#staticNotification"
).data(
"kendoNotification"
);
staticNotification.show(
" Updating data..."
);
var
dataSource = $(
"#spreadsheet"
).data(
"kendoSpreadsheet"
).activeSheet().dataSource;
var
spreadsheetData = dataSource._data;
if
(spreadsheetData) {
$.ajax({
type:
"POST"
,
url:
'@Url.Action("Grid_Update", "Spreadsheet")'
,
contentType:
"application/json; charset=utf-8"
,
data: JSON.stringify({ datum: spreadsheetData, moduleId: @Model.TheModule.Id }),
dataType:
"json"
,
success:
function
(result) {
if
(result.status ==
"Success"
) {
$(
".validation-summary-valid"
).text(result.message);
staticNotification.hide();
}
else
{
}
}
});
}
}
Thanks,
Neil