Web Service Returning Data Best Practice

[Anthony Biondo Jr]

I am trying to figure out the best way to return data through a web service.
If the value is a single value I can just set it equal to the web service
name. If I am returning a set of data I have seen a couple ways to do this.
The dataset coming back to me is a SybaseASE Data Reader. Any help you can
provide would be much appreciated.

thanks,
Anthony

Right now I have done the following:

Namespace MedicaidEligibi lityService

Public Class Result
Public MemberID As String
Public SSN As String
Public DOB As String
Public MemberFirstName As String
Public MemberLastName As String
Public MemberAddress1 As String
Public MemberAddress2 As String
Public MemberAddress3 As String
Public MemberCity As String
Public MemberState As String
Public MemberZipCode As String
Public MemberPhone As String
Public PhysicianName As String
Public PhysicianPhone As String
Public ReturnCode As String
Public ReturnDescripti on As String
Public EligibilityDate As String
End Class

I get the dataset back and set each field to a local variable and do the
following

Dim myResult As MedicaidEligibi lityService.Res ult
myResult = New MedicaidEligibi lityService.Res ult
myResult.Member ID = Out_MemberID.Tr im
myResult.SSN = Out_SSN.Trim
myResult.DOB = Out_DOB.Trim
myResult.Member FirstName = Out_MemberFirst Name.Trim
myResult.Member LastName = Out_MemberLastN ame.Trim
myResult.Member Address1 = Out_MemberAddre ss1.Trim
myResult.Member Address2 = Out_MemberAddre ss2.Trim
myResult.Member Address3 = Out_MemberAddre ss3.Trim
myResult.Member City = Out_MemberCity. Trim
myResult.Member State = Out_MemberState .Trim
myResult.Member ZipCode = Out_MemberZipCo de.Trim
myResult.Member Phone = Out_MemberPhone .Trim
myResult.Physic ianName = Out_PhysicianNa me.Trim
myResult.Physic ianPhone = Out_PhysicianPh one.Trim
myResult.Return Code = Out_ReturnCode. Trim
myResult.Return Description =
BuildReturnDesc ription(Out_Ret urnCode)
myResult.Eligib ilityDate = Out_Eligibility Date.Trim
Return myResult

[Gaurav Vaish \(www.EduJini.IN\)]

Hi Anthony,

>I am trying to figure out the best way to return data through a web
service.
If the value is a single value I can just set it equal to the web service
name. If I am returning a set of data I have seen a couple ways to do
this.

Setting it equat to the web-service name? How do you that? ;-)

Well, I don't think that would be possible... at least as of now in
..net. But I may be wrong since I slept last night :)

The dataset coming back to me is a SybaseASE Data Reader. Any help you
can
provide would be much appreciated.

DataSet cannot be serialized (to XML in SOAP based Web Services). You
will need to put it into a DataView and then it may be directly sent over
the channel.

--
Happy Hacking,
Gaurav Vaish | http://www.mastergaurav.org
http://www.edujini.in | http://webservices.edujini.in
-------------------

[linhardt]

What I do is pack all the data in a dataset and then return it be
reference. I use the function return just to signal if the data read
was successful or not.

You should make sure that the DS is cleared before calling so that you
don't bother sending a big dataset to the web service which isn't used
anyway.

The web reference on the client side takes care of marshalling and
demarshalling the data sent by reference back into the original
client's dataset. It's actually kind of amazing that Call By Reference
works completely transparently with web services.

Friend Function dbGetDS(ByVal KeyID As Integer, ByRef DS As DataSet) As
RETCODE

-paul
Anthony Biondo Jr wrote:

I am trying to figure out the best way to return data through a web service.
If the value is a single value I can just set it equal to the web service
name. If I am returning a set of data I have seen a couple ways to do this.
The dataset coming back to me is a SybaseASE Data Reader. Any help you can
provide would be much appreciated.

thanks,
Anthony

Right now I have done the following:

Namespace MedicaidEligibi lityService

Public Class Result
Public MemberID As String
Public SSN As String
Public DOB As String
Public MemberFirstName As String
Public MemberLastName As String
Public MemberAddress1 As String
Public MemberAddress2 As String
Public MemberAddress3 As String
Public MemberCity As String
Public MemberState As String
Public MemberZipCode As String
Public MemberPhone As String
Public PhysicianName As String
Public PhysicianPhone As String
Public ReturnCode As String
Public ReturnDescripti on As String
Public EligibilityDate As String
End Class

I get the dataset back and set each field to a local variable and do the
following

Dim myResult As MedicaidEligibi lityService.Res ult
myResult = New MedicaidEligibi lityService.Res ult
myResult.Member ID = Out_MemberID.Tr im
myResult.SSN = Out_SSN.Trim
myResult.DOB = Out_DOB.Trim
myResult.Member FirstName = Out_MemberFirst Name.Trim
myResult.Member LastName = Out_MemberLastN ame.Trim
myResult.Member Address1 = Out_MemberAddre ss1.Trim
myResult.Member Address2 = Out_MemberAddre ss2.Trim
myResult.Member Address3 = Out_MemberAddre ss3.Trim
myResult.Member City = Out_MemberCity. Trim
myResult.Member State = Out_MemberState .Trim
myResult.Member ZipCode = Out_MemberZipCo de.Trim
myResult.Member Phone = Out_MemberPhone .Trim
myResult.Physic ianName = Out_PhysicianNa me.Trim
myResult.Physic ianPhone = Out_PhysicianPh one.Trim
myResult.Return Code = Out_ReturnCode. Trim
myResult.Return Description =
BuildReturnDesc ription(Out_Ret urnCode)
myResult.Eligib ilityDate = Out_Eligibility Date.Trim
Return myResult