jQWidgets jqxDataTable editSettings Property

Last Updated : 31 Aug, 2022

jQWidgets is a JavaScript framework for making web-based applications for PC and mobile devices. It is a very powerful, optimized, platform-independent, and widely supported framework. The jqxDataTable is used for reading and displaying the data from the HTML Table. This is also used to display data from various data sources like XML, JSON, Array, CSV, or TSV.

The editSettings property is used to set or return the edit settings of the displayed jqxDataTable. It is of object type and its default value is

{ 
    saveOnPageChange: true, 
    saveOnBlur: true, 
    saveOnSelectionChange: true, 
    cancelOnEsc: true, 
    saveOnEnter: true, 
    editSingleCell: false, 
    editOnDoubleClick: true, 
    editOnF2: true
}

Syntax:

Set the editSettings property.

$('Selector').jqxDataTable({ editSettings: { editOnDoubleClick: true }});

Return the editSettings property.

var editSettings = $('Selector').jqxDataTable('editSettings');

Linked Files: Download jQWidgets from the given link. In the HTML file, locate the script files in the downloaded folder.

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxlistbox.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdropdownlist.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdatatable.js”></script>

Example 1: The below example illustrates the jqxDataTable editSettings property in jQWidgets.

HTML

<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" 
          type="text/css"/> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable editSettings Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" style="margin:29px;" 
               id="jqxbtn" value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                editable: true, 
                editSettings: { 
                    editOnDoubleClick: true 
                }, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var es = $('#Data_Table').jqxDataTable('editSettings'); 
                $('#log').text(es.editOnDoubleClick); 
            }); 
        }); 
    </script> 
</body> 
  
</html>

Output:

Example 2: The following is another example of the jqxDataTable editSettings property in jQWidgets.

HTML

<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" 
          type="text/css"/> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable 
            editSettings Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" style="margin:29px;" 
               id="jqxbtn" value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                editable: true, 
                editSettings: { 
                    editSingleCell: false 
                }, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var es = $('#Data_Table').jqxDataTable('editSettings'); 
                if (es === null) { 
                    $('#log').text("Null!"); 
                } 
                else { 
                    $('#log').text("Not null!"); 
                } 
            }); 
        }); 
    </script> 
</body> 
  
</html>