Change Header Names Dynamically In JQwidgets JQX Grid

Sibeesh Venu
9y
5k
0
2

Article

In this post we will see how we can change header names dynamically In JQwidgets JQX grid. I recently came across a situation to change the grid’s header columns text should be changed dynamically, whenever user change a text box content. So I have done this requirement by using some in-built functionalities of jQWidget JQX grid. Here I am going to share that. I hope you will like it.

To load a grid from a JSON, you can follow the steps as discussed in this article: Load jQWidget JQX Grid From JSON.

Background

If you are new to JQWidget JQX Grid, Please find out here.

Using the code

I hope you have implemented your grid as shown in that article. Now I guess your page will be looking like this.

<!DOCTYPE html>
<html lang="en">
<head>
<title>Change Header Names Dynamically In JQwidgets JQX grid - Sibeesh Passion</title>
<script src="jquery-1.9.1.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxcore.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdata.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxbuttons.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxscrollbar.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxlistbox.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdropdownlist.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxmenu.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.filter.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.sort.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.selection.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.pager.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.columnsresize.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.columnsreorder.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.export.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdata.export.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdatatable.js"></script>
<link href="JQXItems/jqwidgets/styles/jqx.base.css" rel="stylesheet" />
<script type="text/javascript">
$(document).ready(function ()
{
// prepare the data
var data = {
datatype: "json",
datafields: [
{
"name": "AreaCode",
"type": "string"
},
{
"name": "Revenue",
"type": "number"
}],
//id: 'id',
url: "jsonData.txt"
};
$("#jqxgrid").jqxGrid(
{
source: data,
columns: [
{
"text": "Area Code",
"dataField": "AreaCode",
"cellsalign": "left",
"cellsformat": "d"
},
{
"text": "Revenue",
"dataField": "Revenue",
"cellsalign": "right",
"cellsformat": "c2"
}],
pageable: true,
filterable: true,
sortable: true
});
});
</script>
</head>
<body class='default'>
<h2>Change Header Names Dynamically In JQwidgets JQX grid - Sibeesh Passion</h2>
<div id="jqxgrid"></div>
</body>
</html>

Now let us make sure that grid is working fine. Please run your project.

grid

Cool, so grid loaded. Now need to add a select control in which we are going to load the grid header names so that user can select which header must be changed, and a text box where a user can enter the text to be changed for the selected header. Is that fine?

<select id="selectOptions"></select>
<input type="text" id="changeName" />

The next thing is we need to add the options to the select control. Right? We can get the column properties of JQX Grid as $(“#jqxgrid”).jqxGrid(‘columns’).records. Now we will create a ready function in the grid settings and append the values. The following is the code for that.

ready: function ()
{
var options = "<option value='0'>--Select Header--</option>";
var headerNames = $("#jqxgrid").jqxGrid('columns').records;
for (var i = 0; i < headerNames.length; i++)
{
options += "<option value = '" + headerNames[i].datafield + "'>" + headerNames[i].text + " </option>";
}
$("#selectOptions").html(options);
}

What is next? Yeah, we need to fire the text box change event.

$("#changeName").change(function (e) {
$("#jqxgrid").jqxGrid('setcolumnproperty', $('#selectOptions option:selected').val(), 'text', $('#changeName').val());
});

In the text box change event we have written the code to change the header column text property.

Here we are using setcolumnproperty method that is already available in the JQWidget library.

Now it is time to see how it works.

result

You can see that the header column text has been changed from ‘Area Code’ to ‘New Area Code’. That’s all we have done it.

Complete Code

<!DOCTYPE html>
<html lang="en">
<head>
<title>Change Header Names Dynamically In JQwidgets JQX grid - Sibeesh Passion</title>
<script src="jquery-1.9.1.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxcore.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdata.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxbuttons.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxscrollbar.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxlistbox.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdropdownlist.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxmenu.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.filter.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.sort.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.selection.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.pager.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.columnsresize.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.columnsreorder.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxgrid.export.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdata.export.js"></script>
<script type="text/javascript" src="JQXItems/jqwidgets/jqxdatatable.js"></script>
<link href="JQXItems/jqwidgets/styles/jqx.base.css" rel="stylesheet" />
<script type="text/javascript">
$(document).ready(function ()
{
// prepare the data
var data = {
datatype: "json",
datafields: [
{
"name": "AreaCode",
"type": "string"
},
{
"name": "Revenue",
"type": "number"
}],
//id: 'id',
url: "jsonData.txt"
};
$("#jqxgrid").jqxGrid(
{
source: data,
columns: [
{
"text": "Area Code",
"dataField": "AreaCode",
"cellsalign": "left",
"cellsformat": "d"
},
{
"text": "Revenue",
"dataField": "Revenue",
"cellsalign": "right",
"cellsformat": "c2"
}],
pageable: true,
filterable: true,
sortable: true,
ready: function ()
{
var options = "<option value='0'>--Select Header--</option>";
var headerNames = $("#jqxgrid").jqxGrid('columns').records;
for (var i = 0; i < headerNames.length; i++)
{
options += "<option value = '" + headerNames[i].datafield + "'>" + headerNames[i].text + " </option>";
}
$("#selectOptions").html(options);
}
});
$("#changeName").change(function (e)
{
$("#jqxgrid").jqxGrid('setcolumnproperty', $('#selectOptions option:selected').val(), 'text', $('#changeName').val());
});
});
</script>
</head>
<body class='default'>
<h3>Change Header Names Dynamically In JQwidgets JQX grid - Sibeesh Passion</h3>
<br />
<div id="jqxgrid"></div>
<br />
<br />
<select id="selectOptions"></select>
<input type="text" id="changeName" /> </body>
</html>

Conclusion

Did I miss anything that you may think which is needed? Have you ever wanted to do this requirement? Did you try jQWidget yet? Could you find this post as useful? I hope you liked this article. Please share me your valuable suggestions and feedback.

Your turn. What do you think?

If you have any question, then please mention it in the comments section.

Read this article in my blog here.

Up Next

Ebook Download

View all

Printing in C# Made Easy

Read by 10.8k people

Download Now!

Learn

View all