File
Add library
Share
Login or Register
Help
HTML
 
<!DOCTYPE html>
<html>
  <head>
<link href="https://editor.datatables.net/extensions/Editor/css/editor.dataTables.min.css" rel="stylesheet" type="text/css" />
<script src="https://editor.datatables.net/extensions/Editor/js/dataTables.editor.min.js"></script>
<link href="https://cdn.datatables.net/select/1.3.3/css/select.dataTables.css" rel="stylesheet" type="text/css" />
<script src="https://cdn.datatables.net/select/1.3.3/js/dataTables.select.js"></script>
<link href="https://cdn.datatables.net/buttons/2.0.1/css/buttons.dataTables.css" rel="stylesheet" type="text/css" />
<script src="https://cdn.datatables.net/buttons/2.0.1/js/dataTables.buttons.js"></script>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
​
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
​
    <meta charset=utf-8 />
    <title>DataTables - JS Bin</title>
  </head>
  <body>
    <div class="container">
        <table id="dgItem" class="display" style="width:100%">
            <thead>
                <tr>
                    <th>ACTION</th>
                    <th>DENY</th>
                    <th>ITEM</th>
                    <th>STUFF</th>
                    <th>TYPE</th>
                    <th>LIST_NAME</th>
                </tr>
            </thead>
        </table>
    </div>
  </body>
</html>
CSS
 
body {
  font: 90%/1.45em "Helvetica Neue", HelveticaNeue, Verdana, Arial, Helvetica, sans-serif;
  margin: 0;
  padding: 0;
  color: #333;
  background-color: #fff;
}
​
JavaScript
 
var dataset = 
    {"TypeCodeData":[{"ACTION":"INSERTED","DENY":"1234","ITEM":"1234","STUFF":"","TYPE":"","LISTNAME":"DAVE"},
                     {"ACTION":"INSERTED","DENY":"Y","ITEM":"1234","STUFF":"","TYPE":"","LISTNAME":"DAVE"}]};
                              
var dgItem;
var editor;
​
$(document).ready( function () {
  
 editor = new $.fn.dataTable.Editor({
    table: "#dgItem",
    idSrc: "ITEM",
    fields: [{
      name: "DENY",
      type: "select",
      options: [
        { label: "No", value: "N" },
        { label: "Yes", value: "Y" }]
    }]
  });
  
dgItem = $("#dgItem").DataTable({
            dom: 'Brtr',
            data: dataset.TypeCodeData,
            paging: false,
            select: true,
            rowId:'ITEM',
            columns: [
                { data: 'ACTION', title: "Action" },
                { data: 'DENY', title: "Deny" },
                { data: 'ITEM', title: "Item" },
                { data: 'STUFF',title: "STUFF" },
                { data: 'TYPE', title: "Type" },
                { data: 'LISTNAME', title: "LIST_NAME" }
            ],
            columnDefs: [
                { "width": "5%", "targets": 0 },
                { "width": "5%", "targets": 1 },
                { "width": "15%", "targets": 2 },
                { "width": "5%", "targets": 3 },
                { "width": "5%", "targets": 4 },
                { "width": "5%", "targets": 5 }
            ], buttons: [
               { extend: "edit", editor: editor }
            ]
        });
​
} );
​
Output 300px

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers