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.
.NET MVCJavaScriptjQueryMicrosoft SQL ServerMicrosoft Visual Studio

Avatar of undefined
Last Comment
Zvonko

8/22/2022 - Mon
Zvonko

Open in the browser the Developer Console by pressing F12 in the browser.
There you can see what resources are missing.
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
jwebster77

THIS SOLUTION 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
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Zvonko

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck