why Not Display DataTable after app publish on IIS ?

Question

Hello Programmers Please help Me I published asp.net application on iis localhost ,but i have a certain problem in data table doesnt appear a data from table . But same dataTable appear in my localhost , what is a problem exactly ? . I will attached a datatable as photo to explain what i mean exactly? Thank u

Piyush Pansuriya · Answer

It seems like javascript is not working properly on IIS. press F12 for developer option in browser and see the what error is the in console.

Ramachandran M · Answer

HI, Problem with the protocol beacuase is disabled by default.

Abdalla Elawad · Answer

Dear Salman Thanks to support me , you can see the datatable on my localhost ,its working good after published . but i can not dispaly datatable from any PCs on local network . i will attach datatable as pic on my localhost .

Jignesh Kumar · Answer

Hi Abdalla, Please find below setting which you need to put in web config "false" targetFramework= "4.0" /> "4.5" /> "HttpGet" /> "HttpPost" />

Obeid S · Answer

hello abdalla diid solv your problimes if you get solv please let me know buecoues i looking fot it befor 5 days nut still i don't know why this Datatable not working onine when i run it on local mischane it fine work well so if you have any fix please let' me know that thanks

Irfan S · Answer

javascript is not working properly on IIS

Salman Beg · Answer

If that is the case then put try catch block and inside catch block if you get any error then insert that exception details into a table. After that publish again. Run application in other PC's and when the data not load then goto your db and in that particular table check what error you are getting. This is the only way you can find out the real cause of the issue. thanks

Abdalla Elawad · Answer

Dear Salman Sorry , The connection String working good , i can login to application but i can not browsing data from table exactly from DataTable thanks

Salman Beg · Answer

Hi Abdalla. I understood what is the real cause of the problem. When you run the application from your pc it will work because that database which you are using that is present in your pc only so that it can directly access that db and bind that grid. But when you run that same application from other PC's it will try to access that db but that db is not accessible and it is throwing exception.So due to that reason the data will not bind in other PC's. So to run the application in any PC's, take a server connection string and put that in your web.config file and it will work fine. If it helps Mark as answer. Thanks.

Abdalla Elawad · Answer

This Is WebService using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Web.Script.Serialization; namespace IT_Inventory { /// /// Summary description for Item_WebService /// [WebService(Namespace = "http://tempuri.org/" )] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem( false )] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. // [System.Web.Script.Services.ScriptService] public class Item_WebService : System.Web.Services.WebService { [WebMethod] public void GetItem() { string cs = ConfigurationManager.ConnectionStrings[ "Con_Inventory" ].ConnectionString; List listItems = new List(); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand( "DateTable_Select_Item" , con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Class_Item EM2 = new Class_Item(); EM2.Model = rdr[ "Model" ].ToString(); EM2.PartNo = rdr[ "PartNo" ].ToString(); EM2.ItemDesc = rdr[ "ItemDesc" ].ToString(); EM2.ReceivedDate = rdr.GetFieldValue(rdr.GetOrdinal( "ReceivedDate" )).ToString(); listItems.Add(EM2); } } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(listItems)); } } }

Abdalla Elawad · Answer

MR . KUMAR This ia Source of DataTabe and WebService "C#" AutoEventWireup= "true" CodeBehind= "Item_DataTable.aspx.cs" Inherits= "IT_Inventory.Item_DataTable" %> "http://www.w3.org/1999/xhtml" > "server" > APSG GROUP ITC-Department Items of Inventory / Report "Content/bootstrap.min.css" rel= "stylesheet" /> "JS/jquery.dataTables.min.js" > "CSS/jquery.dataTables.min.css" rel= "stylesheet" /> "stylesheet" href= "https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" /> "https://cdn.datatables.net/buttons/1.4.2/css/buttons.dataTables.min.css" rel= "stylesheet" type= "text/css" /> "https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js" > "https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js" > "text/css" > .container{ padding:20px; margin-top:10px; } $(document).ready( function (){ $.ajax({ url: 'Item_WebService.asmx/GetItem' , method: 'post' , dataType: 'json' , success: function (data) { $( '#datatable' ).dataTable({ 'scrollY' : 300, data: data, columns :[ { 'data' : 'Model' }, { 'data' : 'PartNo' }, { 'data' : 'ItemDesc' }, { "data" : "ReceivedDate" , def: function () { return new Date(); }, format: 'M/D/YYYY' , fieldInfo: 'US style m/d/y format' } ], dom: 'Bfrtip' , buttons: [ 'copyHtml5' , 'excelHtml5' , 'csvHtml5' , { extend: 'pdfHtml5' , orientation: 'portiat' , pageSize: 'LEGAL' , customize: function (doc) { doc.content[1].table.widths = Array(doc.content[1].table.body[0].length + 1).join( '*' ).split( '' ); doc.defaultStyle.alignment = 'left' ; doc.styles.tableHeader.alignment = 'left' ; } } ] }); } }); }); class = "container" > class = "panel panel-default" > class = "panel-heading" style= "font-family:'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;color:black;font-size:large" >Items of Inventory "form1" runat= "server" > "datatable" class = "dataTables_wrapper" style= "font-family:'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;width:10px" > Model Type Part Number Item Description Received Date Model Type Part Number Item Description Received Date class = "panel-footer" > "HyperLink1" Font-Names= "Segoe Ui" runat= "server" NavigateUrl= "~/Default.aspx" >Go Back -->--> "text/javascript" src= "https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" > "text/javascript" src= "https://cdn.datatables.net/buttons/1.4.2/js/dataTables.buttons.min.js" > "text/javascript" src= "https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js" > "text/javascript" src= "https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js" > "text/javascript" src= "https://cdn.datatables.net/buttons/1.4.2/js/buttons.html5.min.js" >

Jignesh Kumar · Answer

Could you please let us know Ajax is used or Web Service or any other way to fetch data from DB ? Please provide data access URL here so it will help to identify

Abdalla Elawad · Answer

Yes Mr. Kumar i used jquery , but same datatable work in localhost , i think there is no error in javascript

Jignesh Kumar · Answer

Hi Abdalla, Once page is loaded please press F12 and check if any javascript error. I guess you are using jQuery Datatable. F12 and check on Console if any error while loading Jquery.

Salman Beg · Answer

Hi. I don't think so it is a problem with publishing iis. May be you are getting somewhere exception. I usually published so many times in iis but I never faced such errors. So to check the errors what you can do is, put try catch block in your code and if it hit to catch block then insert that error into db,so if data not load properly you can check the exception in DB. Thanks.

Abdalla Elawad · Answer

This a datatable doesnt work