dt.Tablename=“demoproject”; is not working in Web service After Hosting It
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
The web service GetEmployeDetails(string empid) method perfactly working in localhost but after publishing it and another windows application where we use that method there data is nothing return.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
namespace TCTimeTrackerWS.Employee
/// <summary>
/// Summary description for Employee
/// </summary>
[WebService(Namespace = "http://192.168.31.240/")]
[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 Employee : System.Web.Services.WebService
[WebMethod]
public DataTable GetEmployeDetails(string empid)
try
DataTable dt = DBHelperClass.FilldataTableUsingQuery(@"Select firstname,lastname From MST_Employee WHere employeid='"+empid+"'");
dt.TableName = "empdetails";
if (dt.Rows.Count > 0)
return dt;
catch
return null;
In localhost this code is working fine but in IIS Express it is giving me an error in below line dt.TableName = "empdetails";
It will giving me error :
System.NullReferenceException: Object reference not set to an instance of an object.
at TCTimeTrackerWS.GetProject_webservice.GetProject.GetProjectByEmployee(String employeeid) in E:Work Space 2tcprojsWebServiceTCTimeTrackerWSTCTimeTrackerWSGetProject_webserviceGetProject.asmx.cs:line 27
How to Resolve that? thanks in advance...
iis
add a comment |
The web service GetEmployeDetails(string empid) method perfactly working in localhost but after publishing it and another windows application where we use that method there data is nothing return.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
namespace TCTimeTrackerWS.Employee
/// <summary>
/// Summary description for Employee
/// </summary>
[WebService(Namespace = "http://192.168.31.240/")]
[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 Employee : System.Web.Services.WebService
[WebMethod]
public DataTable GetEmployeDetails(string empid)
try
DataTable dt = DBHelperClass.FilldataTableUsingQuery(@"Select firstname,lastname From MST_Employee WHere employeid='"+empid+"'");
dt.TableName = "empdetails";
if (dt.Rows.Count > 0)
return dt;
catch
return null;
In localhost this code is working fine but in IIS Express it is giving me an error in below line dt.TableName = "empdetails";
It will giving me error :
System.NullReferenceException: Object reference not set to an instance of an object.
at TCTimeTrackerWS.GetProject_webservice.GetProject.GetProjectByEmployee(String employeeid) in E:Work Space 2tcprojsWebServiceTCTimeTrackerWSTCTimeTrackerWSGetProject_webserviceGetProject.asmx.cs:line 27
How to Resolve that? thanks in advance...
iis
looks like null assigned to dt and hence error thrown. add 'dt.TableName = "empdetails";' in if loop
– Abid Hussain
Nov 15 '18 at 10:21
ya that right # Abid Hussain but in local that's perfactly working so why it's giving me error after hosting ..
– Dipak Rathod
Nov 15 '18 at 10:34
add a comment |
The web service GetEmployeDetails(string empid) method perfactly working in localhost but after publishing it and another windows application where we use that method there data is nothing return.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
namespace TCTimeTrackerWS.Employee
/// <summary>
/// Summary description for Employee
/// </summary>
[WebService(Namespace = "http://192.168.31.240/")]
[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 Employee : System.Web.Services.WebService
[WebMethod]
public DataTable GetEmployeDetails(string empid)
try
DataTable dt = DBHelperClass.FilldataTableUsingQuery(@"Select firstname,lastname From MST_Employee WHere employeid='"+empid+"'");
dt.TableName = "empdetails";
if (dt.Rows.Count > 0)
return dt;
catch
return null;
In localhost this code is working fine but in IIS Express it is giving me an error in below line dt.TableName = "empdetails";
It will giving me error :
System.NullReferenceException: Object reference not set to an instance of an object.
at TCTimeTrackerWS.GetProject_webservice.GetProject.GetProjectByEmployee(String employeeid) in E:Work Space 2tcprojsWebServiceTCTimeTrackerWSTCTimeTrackerWSGetProject_webserviceGetProject.asmx.cs:line 27
How to Resolve that? thanks in advance...
iis
The web service GetEmployeDetails(string empid) method perfactly working in localhost but after publishing it and another windows application where we use that method there data is nothing return.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
namespace TCTimeTrackerWS.Employee
/// <summary>
/// Summary description for Employee
/// </summary>
[WebService(Namespace = "http://192.168.31.240/")]
[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 Employee : System.Web.Services.WebService
[WebMethod]
public DataTable GetEmployeDetails(string empid)
try
DataTable dt = DBHelperClass.FilldataTableUsingQuery(@"Select firstname,lastname From MST_Employee WHere employeid='"+empid+"'");
dt.TableName = "empdetails";
if (dt.Rows.Count > 0)
return dt;
catch
return null;
In localhost this code is working fine but in IIS Express it is giving me an error in below line dt.TableName = "empdetails";
It will giving me error :
System.NullReferenceException: Object reference not set to an instance of an object.
at TCTimeTrackerWS.GetProject_webservice.GetProject.GetProjectByEmployee(String employeeid) in E:Work Space 2tcprojsWebServiceTCTimeTrackerWSTCTimeTrackerWSGetProject_webserviceGetProject.asmx.cs:line 27
How to Resolve that? thanks in advance...
iis
iis
asked Nov 15 '18 at 10:02
Dipak RathodDipak Rathod
10512
10512
looks like null assigned to dt and hence error thrown. add 'dt.TableName = "empdetails";' in if loop
– Abid Hussain
Nov 15 '18 at 10:21
ya that right # Abid Hussain but in local that's perfactly working so why it's giving me error after hosting ..
– Dipak Rathod
Nov 15 '18 at 10:34
add a comment |
looks like null assigned to dt and hence error thrown. add 'dt.TableName = "empdetails";' in if loop
– Abid Hussain
Nov 15 '18 at 10:21
ya that right # Abid Hussain but in local that's perfactly working so why it's giving me error after hosting ..
– Dipak Rathod
Nov 15 '18 at 10:34
looks like null assigned to dt and hence error thrown. add 'dt.TableName = "empdetails";' in if loop
– Abid Hussain
Nov 15 '18 at 10:21
looks like null assigned to dt and hence error thrown. add 'dt.TableName = "empdetails";' in if loop
– Abid Hussain
Nov 15 '18 at 10:21
ya that right # Abid Hussain but in local that's perfactly working so why it's giving me error after hosting ..
– Dipak Rathod
Nov 15 '18 at 10:34
ya that right # Abid Hussain but in local that's perfactly working so why it's giving me error after hosting ..
– Dipak Rathod
Nov 15 '18 at 10:34
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53316848%2fdt-tablename-demoproject-is-not-working-in-web-service-after-hosting-it%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53316848%2fdt-tablename-demoproject-is-not-working-in-web-service-after-hosting-it%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
looks like null assigned to dt and hence error thrown. add 'dt.TableName = "empdetails";' in if loop
– Abid Hussain
Nov 15 '18 at 10:21
ya that right # Abid Hussain but in local that's perfactly working so why it's giving me error after hosting ..
– Dipak Rathod
Nov 15 '18 at 10:34