I'm looking for a simple example on how to use SlickGrid when trying to retrieve the data as JSon via jQuery.Ajax. I was also unable to find any documentation of the SlickGrid plugin and was wondering if I was just looking in the wrong places. Any help to get me started with SlickGrid would be most appreciated.
An example within an asp.net page. The webservice myData
returns a json string that needs to match the grid columns.
$(function () {
$.ajax({
url: "WS.asmx/myData",
global: false,
type: "POST",
data: "{}",
contentType: "application/json",
dataType: "json",
async: false,
success: function (json) {
data = eval('(' + json.d + ')');
if (!data) { alert('no data'); };
},
error: function (msg) {
var errorText = eval('(' + msg.responseText + ')');
alert('Error : \n--------\n' + errorText.Message);
}
}
);
if (data) {
dataView = new GridNic.Data.DataView();
grid = new GridNic.Grid($("#myGrid"), dataView.rows, columns, options);
var pager = new GridNic.Controls.Pager(dataView, grid, $("#pager"), columns);
var columnpicker = new GridNic.Controls.ColumnPicker(columns, grid, options);
... and so on
In Asp.Net, the size of the json string is restricted by default. In case of trouble you have to declare a larger size in the web.config e.g. :
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="5000000">
</jsonSerialization>
</webServices>
</scripting>
</system.web.extensions>