Column names dynamically json

[ScottNLMember]

Grid pro’s,

How do i load these setting dynamically

$("#jqxgrid").jqxGrid(
{
width: 800,
source: dataAdapter,
theme: "classic",
columnsresize: true,
columns: [
{ text: 'id', datafield: 'menu_id', width: 80 },
{ text: 'Beverage Type', datafield: 'parent_id', width: 120 },
{ text: 'Calories', datafield: 'name', width: 120 },
{ text: 'Total Fat', datafield: 'url', width: 120 },
{ text: 'Protein', datafield: 'page_order', minwidth: 120 }
]
});

The most important part is the columns.
if you have a few hundred tables with different languages you would want this to be included in the json call

any ideas? thanks in advance

[Peter StoevKeymaster]

Hi ScrottNL,

To change the columns Header Text displayed to the users, you can use this:

$("#jqxgrid").jqxGrid('setcolumnproperty', 'firstname', 'text', 'New Text');

– ‘firstname’ is the datafield’s name.
– ‘text’ – this is the property name
– ‘New Text’ – this is the new value of the ‘text’ property.

To change the entire Columns Array, you can dynamically set the Grid’s columns property.

For example:

var columns = [{ text: 'Column 1', datafield: 'firstname', width: 90 },
        { text: 'Column 2', datafield: 'lastname', width: 90 },
        { text: 'Column 3', datafield: 'productname', width: 150}];
$("#jqxgrid").jqxGrid('columns', columns);

Note that the Grid should be initialized when you change any of its properties or call a method i.e the data binding operation should be completed.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[ScottNLMember]

Good stuff Peter,

Exactly the answer i was looking for.

[ScottNLMember]

1 more question Peter.

Where do i find these settings

cellsalign: ‘right’, cellsformat: ‘c2’

found in { text: ‘Total’, datafield: ‘total’, width: 100, cellsalign: ‘right’, cellsformat: ‘c2’ }

I looked at the documentation and api reference but could not find them.

[Author]

Posts