[realtekParticipant]

hmm, dataAdapter.dataBind() is resending the new request which is good.

But the data isn’t reflected in the Grid… could the refresh be happening to the grid before the data is returned from the server?

[realtekParticipant]

I have also tried:

dataAdapter.dataBind();

[realtekParticipant]

Here is my code:

var url = "json/mainGrid.php"
var source = {
	datatype: 'json',
	url: url,
	id: "SEQUENCE",
	root: 'rowsinfo',
	cache: false,
	columns:[],
	beforeprocessing: function (data) {
		var columnsdata = new Array();
		for (k in data.columnsinfo){
			var col={};
			col.text = data.columnsinfo[k]["DISPLAYNAME"];
			col.datafield = data.columnsinfo[k]["DISPLAYNAME"];
			columnsdata.push(col);
			source.columns = columnsdata;
		}
		$("#jqxgrid").jqxGrid({columns : source.columns});
	},
		data: {
			startcolumn: 1,
			filter: '1'},
	};

[realtekParticipant]

Thank you Dimitar, that would be good as it just seems a bit inconsistent.

Thanks

[realtekParticipant]

Hi,

I managed to get this working as I found this post: http://www.jqwidgets.com/community/topic/drag-and-drop-from-grid-to-tree/

What an excellent post! Sorted.

Thanks!

[realtekParticipant]

Hi Dimitar,

Thank you for your reply.

Isn’t this done in the following demo?

http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxtree/index.htm#demos/jqxtree/dragdrop.htm

If so, surely it must be possible from a Grid to a Tree?

Thanks!

[realtekParticipant]

Here is my code from the Grid I currently have, (hope its ok) – Basically, my JSON is built automatically from PHP json_encode. It will provide a list of columns and then the data which will always fit in the same columns sequentially.

var url = "json/mainGrid.php"
var source = {
	datatype: 'json',
	url: url,
	root: 'rowsinfo',
	cache: false,
	columns:[],
	beforeprocessing: function (data) {
		var columnsdata = new Array();
		for (k in data.columnsinfo){
			var col=[];
			col.text = data.columnsinfo[k]["DISPLAYNAME"];
			col.datafield = data.columnsinfo[k]["FIELDNAME"];
			columnsdata.push(col);
			source.columns = columnsdata;
		}
		$("#jqxgrid").jqxGrid({columns : source.columns});
	},
		data: {
			startcolumn: 1,
		}
	};

Here is an example of my JSON Output (which could be wrong)

{"columnsinfo":{"FIELDNAME":"SEQUENCE","DISPLAYNAME":"Test #"}}{"rowsinfo":{"Test #":"1"}}

[realtekParticipant]

Hi Frankfu,

Do you have the code from your JSON please as I am trying to do a simular thing but I cannot get the write format for the json_encode you are using.

Thanks

[realtekParticipant]

Hi Peter,

Thank you, I noticed a syntax error in the height and width where I accidentally put two single quotes around the percentage values.

Removing them resolved the issue!

Thank you

[realtekParticipant]

Hi Peter,

That example doesn’t fill the splitter by 100% for the Grid, it seems to be larger?

I followed this example: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/autosize.htm

All parent tags have the height and width specified, including html, body and the content section for the tab but it still refuses to go to 100%.

I’m not sure what I am missing?

[realtekParticipant]

Sorry, I was looking in the wrong page!

Here is where I set the height and width but it won’t fill

       // Create jqxGrid
            $("#jqxgrid").jqxGrid(
            {
                width: '100%',
				height: '100%',
                source: dataAdapter,
                groupable: true,
                theme: theme,
                pageable: true,
                columns: [
                  { text: 'Group Name', datafield: 'GroupName', width: 250 }
                ]
            });

The code I posted above is what the HTML returns from the browser.

Thanks

[Author]

Posts