c# - Add Serialized List to jquery Datatables -

-

i'm trying add serialized list in .txt file , add jquery datatable using ajax call, got error in first line of ajax. can tell me i'm doing wrong?

this path.txt (serialized list):

["ens frutas","rest","cenas","$26.50",0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"$26.50"]

this datatable-filling javascript:

$(document).ready(function () {    var table = $('#pftable_hdr').datatable({      "ajax": {        "url": "/path.txt",         "datasrc": ""       },      "columns": [        { "data": "descripcion" },        { "data": "pdv" },        { "data": "rid" },        { "data": "pv" },        { "data": "1" },        { "data": "2" },        { "data": "3" },        { "data": "4" },        { "data": "5" },        { "data": "6" },        { "data": "7" },        { "data": "8" },        { "data": "9" },        { "data": "10" },        { "data": "11" },        { "data": "12" },        { "data": "13" },        { "data": "14" },        { "data": "15" },        { "data": "16" },        { "data": "17" },        { "data": "18" },        { "data": "19" },        { "data": "20" },        { "data": "21" },        { "data": "22" },        { "data": "23" },        { "data": "24" },        { "data": "25" },        { "data": "26" },        { "data": "27" },        { "data": "28" },        { "data": "29" },        { "data": "30" },        { "data": "31" },        { "data": "total" },        { "data": "cantidad" }      ],      scrolly: "500px",       scrollx: true,       scrollcollapse: true,       fixedcolumns: {         leftcolumns: 3      }    });  });

and html table code:

<table class="table table-hover no-more-tables table-iconmebanquet-detail" id="pftable_hdr">    <thead>      <tr>        <th style="">descripcion</th>        <th style="">pdv</th>        <th style="">rid</th>        <th style="">pv</th>        <th style="">1</th>        <th style="">2</th>        <th style="">3</th>        <th style="">4</th>        <th style="">5</th>        <th style="">6</th>        <th style="">7</th>        <th style="">8</th>        <th style="">9</th>        <th style="">10</th>        <th style="">11</th>        <th style="">12</th>        <th style="">13</th>        <th style="">14</th>        <th style="">15</th>        <th style="">16</th>        <th style="">17</th>        <th style="">18</th>        <th style="">19</th>        <th style="">20</th>        <th style="">21</th>        <th style="">22</th>        <th style="">23</th>        <th style="">24</th>        <th style="">25</th>        <th style="">26</th>        <th style="">27</th>        <th style="">28</th>        <th style="">29</th>        <th style="">30</th>        <th style="">31</th>        <th style="">total</th>        <th style="">venta</th>      </tr>    </thead>    <tfoot>      <tr>        <th style="">descripcion</th>        <th style="">pdv</th>        <th style="">rid</th>        <th style="">pv</th>        <th style="">1</th>        <th style="">2</th>        <th style="">3</th>        <th style="">4</th>        <th style="">5</th>        <th style="">6</th>        <th style="">7</th>        <th style="">8</th>        <th style="">9</th>        <th style="">10</th>        <th style="">11</th>        <th style="">12</th>        <th style="">13</th>        <th style="">14</th>        <th style="">15</th>        <th style="">16</th>        <th style="">17</th>        <th style="">18</th>        <th style="">19</th>        <th style="">20</th>        <th style="">21</th>        <th style="">22</th>        <th style="">23</th>        <th style="">24</th>        <th style="">25</th>        <th style="">26</th>        <th style="">27</th>        <th style="">28</th>        <th style="">29</th>        <th style="">30</th>        <th style="">31</th>        <th style="">total</th>        <th style="">venta</th>      </tr>    </tfoot>  </table>

how can make ajax call fill datatable data in .txt file?

your data has array of arrays, see below:

[["ens frutas","rest","cenas","$26.50",0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"$26.50"]]

there no need columns.data initialization options, see updated javascript code below:

$(document).ready(function () {     var table = $('#pftable_hdr').datatable({         ajax: {             url: "/path.txt",             datasrc: ""         },         scrolly: "500px",         scrollx: true,         scrollcollapse: true,         fixedcolumns: {             leftcolumns: 3         }     }); });

see this jsfiddle code , demonstration.


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more