Link to home
Avatar of jwebster77
jwebster77

asked on

Data in datatable not showing after publishing, in MVC

Hi,
I published a MVC project to a business server.  It works but the data in the datatable is not showing.
Although, when I just debug in Visual Studio there is data.
This project has 2 tabs:  
The first tab is to show the datatable in question which uses Entity Framework;  
The second tab also has a datatable which shows data that is accessed via Ado.Net.
Data in the first tab does not show, while it does in the second tab.  


Could the problem be that while the datatable on the first tab references to this link
 <script type="text/javascript" charset="utf8" src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.js"></script>

while for the second tab I imported the yadcf datatable
<script src="~/Yadcf/jquery.dataTables.yadcf.js"></script>   ?



FYI, when I published I used the below:

UNDER CONNECTION:
Publish method: Web Deploy
Server:  (Business Server Name)
Site name:  HelpDeskSupport
Username:  myUsername
Password:  myPassoword

UNDER SETTINGS:
Under "DBModel" as the datasource I added the SQL Server name with its username and password.
I checked the "Use this connection string at runtime..."



Could you please help me figure out what I have done wrong? Thank you.
Avatar of Zvonko
Zvonko
Flag of North Macedonia image

Open in the browser the Developer Console by pressing F12 in the browser.
There you can see what resources are missing.
Avatar of jwebster77
jwebster77

ASKER

When I do F12 under the "Elements" I can see the references to the datatables(see attached photo).  Plus it looks like the datatable and its functionalities(search box, paging, column names) show up but without any data in it.
Datatable.JPG
ASKER CERTIFIED SOLUTION
Avatar of jwebster77
jwebster77

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Show me please the Console view and Network view from the Developer Console.
And you can Undock the Developer Console from your browser window with the three dots command opetion on the top right side.