why Not Display DataTable after app publish on IIS ?

Abdalla Elawad

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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramachandran M6y ago
HI,

Problem with the protocol beacuase is disabled by default.

+1
Obeid S6y ago
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
0
Irfan S7y ago
javascript is not working properly on IIS
0
Piyush Pansuriya7y ago
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.
+1
Salman Beg7y ago
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
0
Abdalla Elawad7y ago
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
0
Salman Beg7y ago
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.
0
Abdalla Elawad7y ago
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 .

+1
Jignesh Kumar7y ago
Hi Abdalla,

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


      "HttpGet"/>
      "HttpPost"/>
+1
Abdalla Elawad7y ago
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));

}

}

}
0
Abdalla Elawad7y ago
MR . KUMAR

This ia Source of DataTabe and WebService
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Item_DataTable.aspx.cs" Inherits="IT_Inventory.Item_DataTable" %>

"http://www.w3.org/1999/xhtml">
"server">
 </li><li class="">APSG GROUP </li><li class="alt">ITC-Department </li><li class="">Items of Inventory / Report </li><li class="alt">
"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;
}




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 Kumar7y ago

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 Elawad7y ago

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

Jignesh Kumar7y ago

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 Beg7y ago

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 Elawad7y ago

This a datatable doesnt work