asp.net mvc - jQuery DataTable refreshing data - MVC View building table first, then trying to display data retrieved via ajax -

-

i'm working on mvc5 , load datatable iterating through model data, manually building table elements on document ready initialize table .datatable(). part works fine. now, allow user change data want display (via dropdown selection, change event fires , calls ajax controller method, returns json objects), new initialization of datatable doesn't seem want cooperate. nothing visible @ point.

here's table within view:

  <table class="table table-bordered" id="accountrequeststatus" name="accountrequeststatus">                     <thead>                         <tr>                             <th>col1</th>                             <th>col2</th>                             <th>col3</th>                             <th>col4</th>                             <th>col5</th>                             <th></th>                         </tr>                     </thead>                     <tbody>                         @foreach (var request in model.payload)                         {                             <tr class="registerrow" id="register@(request.col1)">                                 <td class="value registerrow">@request.col2</td>                                 <td class="value registerrow">@request.col3</td>                                     <td class="value registerrow">@request.col4</td>                                     <td class="value registerrow">@request.emailaddress</td>                                 <td>@html.actionlink("click me, bro", controllermethod, new { param1 = request.myparam1 })</td>                             </tr>                         }                     </tbody>                 </table>

document ready:

 $(document).ready(function () {     // setting filter button status selected value      $('#accountrequeststatus').datatable();});

bam. works slick, , thank that!

now, when try reload grid single column, 'cannot reinitialize datatable'. when i'm working single column, modify view's table have 1.

my original example had 4-5 column, in test table i've removed single column. here's i've done (i think) wire column data (and add name too). click event calls loaddatatable function, shown below.

  function loaddatatable(data) {              $('#accountrequeststatus').datatable(         {             paging: false,             "data": data,             "columns": [                {                    "data": "companyname",                    "name": "blah blah"                }             ]         }     );}

from above, looks i'm reinitializing table. want this, or should else used?

here's of sample data single column, copied developer tools:

enter image description here

anything can see i'm doing wrong? @ point i'd finish way i've begun can call 'good'. appreciated!

use destroy :

initialise new datatable usual, if there existing datatable matches selector, destroyed , replaced new table.

$('#accountrequeststatus').datatable(     {        destroy : true, //<-- here        paging: false,        "data": data,        "columns": [            {                "data": "companyname",                "name": "blah blah"            }         ]     } );}

Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more