sum in footer of datatable using ajax

vikas0001

Hello Sir/Mam,
currently, I work in asp.net core 2.2.
I can display data using ajax
here are the code and image

<script>
    $(document).ready(function () {
        $('#example').DataTable({
            "processing": true, // for show progress bar
            "filter": true, // this is for disable filter (search box)
            "ajax": {
                "url": "../api/InvestigationAPI/indexx",
                "dataSrc": ""
            },
            "columns": [
                { "data": "investigation", "autoWidth": true },
                { "data": "price", "autoWidth": true },
                { "data": "price", "autoWidth": true},
            ],
    
        });

    });

data display successfully. But here problem that how to display the sum of price column in the footer and in the total payable textbox
and how can I export data from this table I try many methods which mention here and also google

sorry for my English

thanks
</script>

Edited by Kevin:  Syntax highlighting. Details on how to highlight code using markdown can be found in this guide

kthorngren

For the footer total have you seen this example:
https://datatables.net/examples/advanced_init/footer_callback.html

Once the sum of this example is done it adds it to the footer. You can do the same to place it in the "total payable textbox"

Kevin