Issue With WebService in asp.net?

I m working with web services using store procedure and when I m inserted a record using Webservice then inserted successfully but when I click on service description than data not display but the record is inserted successfully in the database and when I test my web service in postman then get an error see below:

In PostMan:
(post) http://localhost:25880/PaymentMode.asmx?op=login

xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><soap:Code><soap:Value>soap:Receiversoap:Value>soap:Code><soap:Reason><soap:Text xml:lang="en">System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Xml.XmlException: Root element is missing.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Web.Services.Protocols.SoapServerProtocol.SoapEnvelopeReader.Read()
at System.Xml.XmlReader.MoveToContent()
at System.Web.Services.Protocols.SoapServerProtocol.SoapEnvelopeReader.MoveToContent()
at System.Web.Services.Protocols.SoapServerProtocolHelper.GetRequestElement()
at System.Web.Services.Protocols.Soap12ServerProtocolHelper.RouteRequest()
at System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMessage message)
at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
--- End of inner exception stack trace ---soap:Text>soap:Reason><soap:Detail />soap:Fault>soap:Body>soap:Envelope>

[WebMethod]
public string login(string uname, string pass)
{
cn.Open();
SqlCommand cmd = new SqlCommand("loginsp", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@username",uname);
cmd.Parameters.AddWithValue("@password", pass);
try
{
cmd.ExecuteNonQuery();
return "inserted data successfully";
}
catch (Exception)
{
return "inserted data not successfully";
throw;
}
finally
{
cn.Close();
}
}

store procedure:

CREATE PROCEDURE loginsp
@username varchar(50),
@password varchar(50)
AS
BEGIN
Insert Into studlogin values(@username,@password);
END
GO

problem is that click on service description than data not display but the record is inserted successfully in the database and when I test my web service in postman then get an error??

what I m doing wrong in my above code??help??

9 Replies

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

Amit Mohanty6y ago
Accepted answer
Hey use like this

http://localhost:25880/PaymentMode.asmx/login?uname=rahul&pass=raghuranjan
+3
Laxmidhar Sahoo6y ago
what is your new login method
0
Rahul Patil6y ago
Laxmidhar Sahoo thanks for your suggestion, Laxmi Dhar. still, I m facing this issue how to show the data either XML or JSON.
0
Laxmidhar Sahoo6y ago
1. Add the following to the <system.web> block in Web.config file:
3. <webServices>
4. <protocols>
5. <add name="HttpGet" />
6. <add name="HttpPost" />
7. protocols>
8. webServices>
0

Issue With WebService in asp.net?

Laxmidhar Sahoo thanks for your suggestion, Laxmi Dhar. still, I m facing this issue how to show the data either XML or JSON.