I have been trying to understand your Master Detail Example to convert it for mysql. I am definitely getting lost. I would really appreciate some help on creating a mysql version. The area I am struggling with is the following.
sourceA
dataAdapterA
sourceB
var dataAdapter = new $.jqx.dataAdapter(source);
dataAdapter.dataBind();
$(“#customersGrid”).bind(‘rowselect’, function (event) {
var customerID = event.args.row.CustomerID;
var records = new Array();
var length = dataAdapter.records.length;
for (var i = 0; i < length; i++) {
var record = dataAdapter.records[i];
if (record.CustomerID == customerID) {
records[records.length] = record;
}
}
var dataSource = {
datafields: dataFields,
localdata: records
}
var adapter = new $.jqx.dataAdapter(dataSource);
// update data source.
$("#ordersGrid").jqxGrid({ source: adapter });
});