datatable - How to display data in data table with ajax call without a column name as "Id"

Question

I am running into a weird issue. My Database Table has few records with columns UserId, FirstName, LastName.

On page load I am getting all the data from Database and storing it in a json object.

Now I am making an Ajax call to populate this data into a data table. The code snippet for the same is below

function loadDataTable() {
    dataTable = $('#tblData').DataTable({
        "ajax": {
            "url": "/Individual/IndHome/GetAll",
            "type": "GET",
        },
        "columns": [
            { "data": "userid", "width": "30%" },
            { "data": "firstname", "width": "30%" },
            { "data": "lastname", "width": "30%" },
            {
                "data": "UserId",
                "render": function (data) {
                    return `
                            <div class="text-center">
                                <a href="/Individual/IndHome/Upsert/${data}" class="btn btn-success text-white btnEdit" style="cursor:pointer">
                                    EDIT
                                </a>
                                <a onclick=Delete("/Individual/IndHome/Delete/${data}") class="btn btn-danger text-white" style="cursor:pointer">
                                    <i class="fas fa-trash-alt"></i> 
                                </a>
                            </div>
                           `;
                }, "width": "10%"
            }
        ]
    });

Now the data table only populates First Name and Last Name the UserId Column is just blank. When I change the UserId Column in my Database to just Id. It populates everything correctly. Am I making a mistake or missing out on something.

I read somewhere that Data Table looks for a Column named as "ID" and in my case its "UserId" Can it be an issue ? Because Each and Every table of mine cannot have an ID Column

question from:https://stackoverflow.com/questions/65943299/how-to-display-data-in-data-table-with-ajax-call-without-a-column-name-as-id

Answer 1

Waitting for answers