npl77
asked on
Getting A Datatable name error web services
Can someone help me debug this exception, I have set the "name" of the datatable in my web service(shown below) but am still getting this error:
System.Web.Services.Protoc ols.SoapEx ception: Server was unable to process request. ---> System.InvalidOperationExc eption: There was an error generating the XML document. ---> System.InvalidOperationExc eption: Cannot serialize the DataTable. DataTable name is not set.
at System.Data.DataTable.Writ eXmlSchema (XmlWriter writer, Boolean writeHierarchy)
at System.Data.DataTable.Syst em.Xml.Ser ialization .IXmlSeria lizable.Wr iteXml(Xml Writer writer)
at System.Xml.Serialization.X mlSerializ ationWrite r.WriteSer ializable( IXmlSerial izable serializable, String name, String ns, Boolean isNullable, Boolean wrapped)
at Microsoft.Xml.Serializatio n.Generate dAssembly. XmlSeriali zationWrit er1.Write4 _GetNicksD ataRespons e(Object[] p)
at Microsoft.Xml.Serializatio n.Generate dAssembly. ArrayOfObj ectSeriali zer1.Seria lize(Objec t objectToSerialize, XmlSerializationWriter writer)
at System.Xml.Serialization.X mlSerializ er.Seriali ze(XmlWrit er xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
--- End of inner exception stack trace ---
at System.Xml.Serialization.X mlSerializ er.Seriali ze(XmlWrit er xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
at System.Xml.Serialization.X mlSerializ er.Seriali ze(XmlWrit er xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle)
at System.Web.Services.Protoc ols.SoapSe rverProtoc ol.WriteRe turns(Obje ct[] returnValues, Stream outputStream)
at System.Web.Services.Protoc ols.WebSer viceHandle r.WriteRet urns(Objec t[] returnValues)
at System.Web.Services.Protoc ols.WebSer viceHandle r.Invoke()
--- End of inner exception stack trace ---
System.Web.Services.Protoc
at System.Data.DataTable.Writ
at System.Data.DataTable.Syst
at System.Xml.Serialization.X
at Microsoft.Xml.Serializatio
at Microsoft.Xml.Serializatio
at System.Xml.Serialization.X
--- End of inner exception stack trace ---
at System.Xml.Serialization.X
at System.Xml.Serialization.X
at System.Web.Services.Protoc
at System.Web.Services.Protoc
at System.Web.Services.Protoc
--- End of inner exception stack trace ---
[WebMethod(Description="This method is used to returns BigM News. Username and Password MUST be provided.")]
[SoapHeader("CustomSoapHeader")]
public DataTable GetNicksData()
{
// Test to see if the proper credentials were passed in.
ServiceAuthHeaderValidation.Validate(CustomSoapHeader);
DataTable dt = new DataTable("myData");
dt=BMHAccess.GetNews();
return dt;
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window