Re: Problem with webservice returning an array (You must implement

Stacey,

System.Data is not SQL specific but sits above the provider specific
namespaces for SQLClient and OLEDb. According to the documenation, SqlClient
is support on the copact framework (via a SQL CE driver) but OleDb isn't. So
in this instance use of DataSet and/or DataTable should be OK...unless you
want access from a non .NET client.

"Stacey Levine" wrote:

> The only possible problem is that I want a PocketPC device to be able to
> call the webservice. And from what I can tell, it doesn't have the SQLClient
> namespace..
> "Paul Hasell" <paul_hasell@xxxxxxxxxxxxxxxx> wrote in message
> news:BF3A9E6D-F50E-4AA3-913A-E5C8E300C538@xxxxxxxxxxxxxxxx
> > Stacey,
> >
> > I wonder if it's because at compile time it can't know whether the classes
> > can serialised. For this instance, have you considered returning a DataSet
> > or
> > DataTable which the proxy knows how to serialise?
> >
> > "Stacey Levine" wrote:
> >
> >> I have a webservice that I wanted to return an ArrayList..Well the
> >> service
> >> compiles and runs when I have the output defined as ArrayList, but the
> >> WSDL
> >> defines the output as an Object so I was having a problem in the calling
> >> program. I searched online and found suggestions that I return an Array
> >> instead so I modified my code (below) to return an Array instead of an
> >> ArrayList. Now I get the message when I try to run just my webservice
> >> saying " You must implement.." The code and complete message are below.
> >> I
> >> am unsure of where to go from here. I have found several other people
> >> that
> >> had similar problems, but nothing seems to work. Thanks for your help.
> >>
> >>
> >>
> >> <WebMethod()> _
> >>
> >> Public Function GetTitlesForBin(ByVal BinNum As String) As Array
> >>
> >> Dim sSql As String
> >>
> >> Dim MyTitles As ArrayList = New ArrayList
> >>
> >> Dim oConn As New SqlClient.SqlConnection(gMerch)
> >>
> >> sSql = "SELECT P.POSDesc, X.UPC FROM Bin_Xref X "
> >>
> >> sSql = sSql & " LEFT JOIN tblItm I"
> >>
> >> sSql = sSql & " ON X.UPC = I.UPC"
> >>
> >> sSql = sSql & " LEFT JOIN tblPrd P"
> >>
> >> sSql = sSql & " ON I.GrphcKey = P.GrphcKey"
> >>
> >> sSql = sSql & " WHERE X.Bin_Num='" & BinNum & "'"
> >>
> >> sSql = sSql & " ORDER BY P.POSDesc"
> >>
> >> Dim oCmd As New SqlClient.SqlCommand(sSql, oConn)
> >>
> >> Dim oRead As SqlClient.SqlDataReader
> >>
> >> oConn.Open()
> >>
> >> oRead = oCmd.ExecuteReader
> >>
> >> While oRead.Read
> >>
> >> MyTitles.Add(Convert.ToString(oRead("POSDesc")))
> >>
> >> MyTitles.Add(Convert.ToString(oRead("UPC")))
> >>
> >> End While
> >>
> >> oRead.Close()
> >>
> >> oCmd.Dispose()
> >>
> >> oConn.Dispose()
> >>
> >> Return MyTitles.ToArray
> >>
> >> End Function
> >>
> >>
> >>
> >>
> >>
> >> ____________________ERROR MESSAGE____________
> >>
> >> You must implement a default accessor on System.Array because it inherits
> >> from ICollection.
> >> 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.InvalidOperationException: You must implement a
> >> default accessor on System.Array because it inherits from ICollection.
> >>
> >> Source Error:
> >>
> >> An unhandled exception was generated during the execution of the
> >> current web request. Information regarding the origin and location of the
> >> exception can be identified using the exception stack trace below.
> >>
> >>
> >>
> >> Stack Trace:
> >>
> >> [InvalidOperationException: You must implement a default accessor on
> >> System.Array because it inherits from ICollection.]
> >> System.Xml.Serialization.TypeScope.GetCollectionElementType(Type type)
> >> System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, Boolean
> >> canBePrimitive, MemberInfo memberInfo)
> >> System.Xml.Serialization.TypeScope.GetTypeDesc(Type type, MemberInfo
> >> source,
> >> Boolean directReference)
> >> System.Xml.Serialization.TypeScope.GetTypeDesc(Type type)
> >> System.Xml.Serialization.XmlReflectionImporter.ImportMemberMapping(XmlReflectionMember
> >> xmlReflectionMember, String ns, XmlReflectionMember[]
> >> xmlReflectionMembers)
> >> System.Xml.Serialization.XmlReflectionImporter.ImportMembersMapping(XmlReflectionMember[]
> >> xmlReflectionMembers, String ns, Boolean hasWrapperElement)
> >> [InvalidOperationException: There was an error reflecting
> >> 'GetTitlesForBinResult'.]
> >> System.Xml.Serialization.XmlReflectionImporter.ImportMembersMapping(XmlReflectionMember[]
> >> xmlReflectionMembers, String ns, Boolean hasWrapperElement)
> >> System.Xml.Serialization.XmlReflectionImporter.ImportMembersMapping(String
> >> elementName, String ns, XmlReflectionMember[] members, Boolean
> >> hasWrapperElement)
> >> System.Web.Services.Protocols.SoapReflector.ImportMembersMapping(XmlReflectionImporter
> >> xmlImporter, SoapReflectionImporter soapImporter, Boolean
> >> serviceDefaultIsEncoded, Boolean rpc, SoapBindingUse use,
> >> SoapParameterStyle
> >> paramStyle, String elementName, String elementNamespace, Boolean
> >> nsIsDefault, XmlReflectionMember[] members, Boolean validate)
> >> System.Web.Services.Protocols.SoapReflector.ReflectMethod(LogicalMethodInfo
> >> methodInfo, Boolean client, XmlReflectionImporter xmlImporter,
> >> SoapReflectionImporter soapImporter, String defaultNs)
> >> [InvalidOperationException: Method ItemLookup.GetTitlesForBin can not be
> >> reflected.]
> >> System.Web.Services.Protocols.SoapReflector.ReflectMethod(LogicalMethodInfo
> >> methodInfo, Boolean client, XmlReflectionImporter xmlImporter,
> >> SoapReflectionImporter soapImporter, String defaultNs)
> >> System.Web.Services.Description.SoapProtocolReflector.ReflectMethod()
> >> System.Web.Services.Description.ProtocolReflector.ReflectBinding(ReflectedBinding
> >> reflectedBinding)
> >> System.Web.Services.Description.ProtocolReflector.Reflect()
> >> System.Web.Services.Description.ServiceDescriptionReflector.ReflectInternal(ProtocolReflector[]
> >> reflectors)
> >> System.Web.Services.Description.ServiceDescriptionReflector.Reflect(Type
> >> type, String url)
> >> System.Web.Services.Protocols.DocumentationServerType..ctor(Type type,
> >> String uri)
> >> System.Web.Services.Protocols.DocumentationServerProtocol.Initialize()
> >> System.Web.Services.Protocols.ServerProtocol.SetContext(Type type,
> >> HttpContext context, HttpRequest request, HttpResponse response)
> >> System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
> >> HttpContext context, HttpRequest request, HttpResponse response, Boolean&
> >> abortProcessing) [InvalidOperationException: Unable to handle request.]
> >> System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type,
> >> HttpContext context, HttpRequest request, HttpResponse response, Boolean&
> >> abortProcessing)
> >> System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type
> >> type, HttpContext context, HttpRequest request, HttpResponse response)
> >> [InvalidOperationException: Failed to handle request.]
> >> System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type
> >> type, HttpContext context, HttpRequest request, HttpResponse response)
> >> System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext
> >> context, String verb, String url, String filePath)
> >> System.Web.HttpApplication.MapHttpHandler(HttpContext context, String
> >> requestType, String path, String pathTranslated, Boolean useAppConfig)
> >> System.Web.MapHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> >>
> >>
> >>
> >>
> >>
> >> Stacey Levine
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Add Web Reference Error
    ... >> strCountryStart As String) As SqlDataReader ... >> System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, Boolean ... >> HttpContext context, HttpRequest request, HttpResponse response, Boolean& ...
    (microsoft.public.dotnet.distributed_apps)
  • Serialization Question
    ... System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, Boolean ... xmlReflectionMember, String ns, XmlReflectionMemberxmlReflectionMembers) ... HttpContext context, HttpRequest request, HttpResponse response, Boolean& ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problem with webservice returning an array (You must implement a d
    ... >> Public Function GetTitlesForBin(ByVal BinNum As String) As Array ... >> System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, Boolean ... >> HttpContext context, HttpRequest request, HttpResponse response, Boolean& ...
    (microsoft.public.dotnet.framework.webservices)
  • MOSS Search Recurrent Event Log Errors
    ... (VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, ... (HttpContext context, VirtualPath virtualPath, Boolean noBuild, ... (HttpContext context, String verb, String url, String filePath) ...
    (microsoft.public.sharepoint.portalserver)
  • Problem with webservice returning an array (You must implement a default accessor on System.Array be
    ... Public Function GetTitlesForBin(ByVal BinNum As String) As Array ... System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, Boolean ... xmlReflectionMember, String ns, XmlReflectionMemberxmlReflectionMembers) ... HttpContext context, HttpRequest request, HttpResponse response, Boolean& ...
    (microsoft.public.dotnet.framework.webservices)