Rows not showing up in DataTable -

-

i have datatable in view this:

 <table id="tblproviders" style="font-size:x-small;width:100%; border: 1px solid black;">                 <caption>assigned providers</caption>                 <thead>                     <tr>                         <th>id</th>                         <th>name</th>                         <th>email</th>                         <th>phone</th>                         <th>role</th>                         <th>remove</th>                     </tr>                 </thead>             </table>

and assignment of data:

 $("#tblproviders").datatable({         bprocessing: true,         sajaxsource: '@url.action("getprovidersbyid")?id=' + $("#txtid").val(),         bjqueryui: true,         sprocessing: "<img src='~/images/spinner.gif' />",         dom: 't<"clear">rtip',         "pagelength": 5,         bautowidth: false,         "olanguage": {             semptytable: "there no providers @ time",             szerorecords: "there no providers @ time"         },         "aocolumns": [             { "swidth": "1%", sclass: "smallfonts" },             { "swidth": "15%", sclass: "smallfonts" },             { "swidth": "15%", sclass: "smallfonts" },             { "swidth": "15%", sclass: "smallfonts" },             { "swidth": "15%", sclass: "smallfonts" },             {                 "swidth": "15%", sclass: "centerbutton", "sname": "userid", "mrender": function (data, type, row) {                      return "<button type='button' class='displaybutton' id='" + row[0] + "' onclick=removeprovider(this);return false; >remove</button>";                 }             }         ],         tabletools: {             "sswfpath": "../../scripts/swf/copy_csv_xls_pdf.swf",             "abuttons": [              ]          }     });     $("#tblproviders").datatable().fnsetcolumnvis(0, false);     otab = $("#tblproviders").datatable();     otab.fnsort([[1, 'asc']]);

i know getting correct json data this:

 [httpget]     public actionresult getprovidersid(string id)     {         return json(new         {             aadata = repository.getprovidersbyid(id).select(x => new string[] {                 x.id.tostring(),                 x.firstname + " " + x.lastname,                 x.email,                 x.phone,                 x.role,             })         }, jsonrequestbehavior.allowget);     }

but yet none of rows shows up. doing wrong here? in fact, if debug on loading of table putting debug point @ remove spot, see data never displays.

unfortunately, problem caused use of alphabet search loaded main view. once filtering started , partial view displayed, filtering continued in partial view, showing no results. have question regarding problem no answer yet.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more