[BNKParticipant]

Hi All!

If using $('#jqxgrid').jqxGrid('setcolumnproperty'… lines inside $("#jqxgrid").bind('bindingcomplete', function () {...});, my app got poor performance at first run (ajax requests later is faster). So I have finally solved this performance issue by using the above

dataAdapter = new $.jqx.dataAdapter(source, {
	formatData: function (data) {                    
		return JSON.stringify(postdata);
	},
	downloadComplete: function (data, status, xhr) {                    
		// dynamic columns                    
		var json = JSON.stringify(data);
		var obj = $.parseJSON(json);
		for (var i in obj[0]) {                        			
			datafields.push({ name: i, type: (i === 'EndDate')? 'date' : 'string' });
			columns.push({
				text: i, datafield: i,
				filtertype: (i === 'EndDate') ? 'date' : 'string',
				pinned: ($.inArray(i, ['Code', 'Desc', 'Status', 'Date']) !== -1) ? true : false,
				cellsformat: (i === 'EndDate') ? 'dd/MM/yyyy' : '',
			});			                     
		}                                    
		if (!source.totalRecords) {
			source.totalRecords = data.length;                        
		}
	},
	loadError: function (xhr, status, error) {
		alert(xhr.status + ' ' + status + ' ' + source.data);
	}
});

Thankyou!

[BNKParticipant]

Hi Hristo!

One more thing, $('#jqxgrid').jqxGrid('setcolumnproperty', 'EndDate', 'cellsformat', 'dd/MM/yyyy'); is not working, it displays 2016-05-07T00:00:00

UPDATE: I can fix this issue by using datafields.push({ name: i, type: (i === 'EndDate')? 'date' : 'string' });

[BNKParticipant]

Hi Hristo!

Thank you, it works!
However, if I put $('#jqxgrid').jqxGrid('setcolumnproperty'... lines inside $("#jqxgrid").bind('bindingcomplete', function () {...}); then the grid takes longer time to display data. Any suggestion?

[BNKParticipant]

Hi Dimitar,

Yes, thanks. I have included it as the following:

bundles.Add(new ScriptBundle("~/bundles/jqwidgets").Include(
                "~/Scripts/jqxcore.js",
                "~/Scripts/jqxdata.js",
                "~/Scripts/jqxgrid.js",
                "~/Scripts/jqxgrid.selection.js",
                "~/Scripts/jqxgrid.pager.js",
                "~/Scripts/jqxlistbox.js",
                "~/Scripts/jqxbuttons.js",
                "~/Scripts/jqxscrollbar.js",
                "~/Scripts/jqxdatatable.js",
                "~/Scripts/jqxtreegrid.js",
                "~/Scripts/jqxmenu.js",
                "~/Scripts/jqxcalendar.js",
                "~/Scripts/jqxgrid.sort.js",
                "~/Scripts/jqxgrid.filter.js",
                "~/Scripts/jqxdatetimeinput.js",
                "~/Scripts/jqxdropdownlist.js",
                "~/Scripts/jqxslider.js",
                "~/Scripts/jqxeditor.js",
                "~/Scripts/jqxinput.js",
                "~/Scripts/jqxdraw.js",
                "~/Scripts/jqxchart.core.js",
                "~/Scripts/jqxchart.rangeselector.js",
                "~/Scripts/jqxtree.js",
                "~/Scripts/globalize.js",
                "~/Scripts/jqxbulletchart.js",
                "~/Scripts/jqxcheckbox.js",
                "~/Scripts/jqxradiobutton.js",
                "~/Scripts/jqxvalidator.js",
                "~/Scripts/jqxpanel.js",
                "~/Scripts/jqxpasswordinput.js",
                "~/Scripts/jqxnumberinput.js",
                "~/Scripts/jqxcombobox.js",
                "~/Scripts/jqxgrid.grouping.js",
                "~/Scripts/jqxgrid.selection.js",
                "~/Scripts/jqxtabs.js"                
                ));

[BNKParticipant]

Hi Dimitar!

I have just deployed globalize.js files to IIS, it’s working now. Thankyou

[BNKParticipant]

Hi Dimitar,

From Firefox console, I have found the following:

ReferenceError: Globalize is not defined
.setDate()
 jqwidgets:1
.val()
 jqwidgets:1
n.fn.val()
 jqwidgets:1
._updatefilterpanel()
 jqwidgets:1
._handlecolumnsmenu/h()
 jqwidgets:1
._handlecolumnsmenu/<()
 jqwidgets:1
i.event.dispatch()
 jquery:1
i.event.add/v.handle()
 jquery:1
 jqwidgets:1:956312

Of course, I use ver 3.9.1. Thanks

[Author]

Posts