Webservices: RSS

• • Reply
  

  hari.bristol

  Member

  23 Points

  43 Posts

  Webservices:

  Jul 19, 2010 12:54 PM|LINK

  I am developing a web application using webservices. Client and server are on the same machine.

  
  

  I am having this error while running the application:

  
  

  System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: Cannot serialize the DataTable. DataTable name is not set.
    at System.Data.DataTable.WriteXmlSchema(XmlWriter writer, Boolean writeHierarchy)
    at System.Data.DataTable.System.Xml.Serialization.IXmlSerializable.WriteXml(XmlWriter writer)
    at System.Xml.Serialization.XmlSerializationWriter.WriteSerializable(IXmlSerializable serializable, String name, String ns, Boolean isNullable, Boolean wrapped)
    at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriter1.Write13_createmenbersResponse(Object[] p)
    at Microsoft.Xml.Serialization.GeneratedAssembly.ArrayOfObjectSerializer21.Serialize(Object objectToSerialize, XmlSerializationWriter writer)
    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
    --- End of inner exception stack trace ---
    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle)
    at System.Web.Services.Protocols.SoapServerProtocol.WriteReturns(Object[] returnValues, Stream outputStream)
    at System.Web.Services.Protocols.WebServiceHandler.WriteReturns(Object[] returnValues)
    at System.Web.Services.Protocols.WebServiceHandler.Invoke()
    --- End of inner exception stack trace ---

  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
  
  Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: Cannot serialize the DataTable. DataTable name is not set.
    at System.Data.DataTable.WriteXmlSchema(XmlWriter writer, Boolean writeHierarchy)
    at System.Data.DataTable.System.Xml.Serialization.IXmlSerializable.WriteXml(XmlWriter writer)
    at System.Xml.Serialization.XmlSerializationWriter.WriteSerializable(IXmlSerializable serializable, String name, String ns, Boolean isNullable, Boolean wrapped)
    at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriter1.Write13_createmenbersResponse(Object[] p)
    at Microsoft.Xml.Serialization.GeneratedAssembly.ArrayOfObjectSerializer21.Serialize(Object objectToSerialize, XmlSerializationWriter writer)
    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
    --- End of inner exception stack trace ---
    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
    at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle)
    at System.Web.Services.Protocols.SoapServerProtocol.WriteReturns(Object[] returnValues, Stream outputStream)
    at System.Web.Services.Protocols.WebServiceHandler.WriteReturns(Object[] returnValues)
    at System.Web.Services.Protocols.WebServiceHandler.Invoke()
    --- End of inner exception stack trace ---
  
  Source Error:
  
  

  Line 258: [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/createmenbers", RequestNamespace="http://tempuri.org/", ResponseNamespace="http://tempuri.org/", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)] Line 259: public System.Data.DataTable createmenbers(string Firstname, string Lastname, string Fathername, int Age, string Sex, string Email, string Phoneno, string Address, string membershiptype) { Line 260: object[] results = this.Invoke("createmenbers", new object[] { Line 261: Firstname, Line 262: Lastname,

  
  

  
  

  Can anybody help me please
  

• • Reply
  

  DarrellNorto...

  All-Star

  86795 Points

  9644 Posts

  Moderator

  MVP

  Re: Webservices:

  Jul 19, 2010 08:07 PM|LINK

  When creating the DataTable in the web service, you need to give it a name.

  DataTable dt = SomeMethodCallThatReturnsADataTable();
  dt.TableName = "myTable";

  Darrell Norton, MVP
  Darrell Norton's Blog
  Please click "Mark as Answer" if this helped you.
  • Marked as answer by Wencui Qian - MSFT on Jul 22, 2010 02:21 AM
• • Reply
  

  manojnavale0...

  Member

  53 Points

  66 Posts

  Re: Webservices:

  Aug 10, 2011 10:25 AM|LINK

  Hello i have also created a web service and trying to access it in windows application 

  my web service returns datatable. When i call this web method in windows application it is giving me error.

  error::

  Server was unable to process request. --->

  There was an error generating the XML document.

  ---> Cannot serialize the DataTable. DataTable name is not set.

  when i call HelloWorld method it works fine but my webmethod  not working properly.

  my web method is like this:

  [WebMethod]
      public DataTable GetVideoDataTable(string strQry )
      {
  
          SqlConnection cn = new SqlConnection();
          SqlCommand cmd = new SqlCommand();
          SqlDataReader reader;
          DataTable dt = new DataTable();
  
          cn.ConnectionString = KS.CommonFunctions.ConStr;
          cmd.Connection = cn;
          cmd.CommandType = CommandType.Text;
          cmd.CommandText = strQry;
  
          try
          {
              cn.Open();
              
              reader = cmd.ExecuteReader();
              if (reader != null)
              {
                  dt.Load(reader);
              }
              cn.Close();
          }
          catch (Exception ex)
          {
              //ex.Message.ToString();
          }
          return dt;
      }

  This is my web method call

       dt =  m_gt.GetVideoDataTable("SELECT * FROM <tablename>");

  please help me