Is it possible to return a DataTable from a Webservice method

[Ganga]

Hi All,

I was just wondering whether is it possible to return a Data Table
from a WebService method. Since I need to send only one table at a
time, I dont want to return the entire Dataset.

Any help would be highly appreciated.

Cheers

Ganga.

[Sami Vaaraniemi]

No, it is not possible to return a DataTable from a web service. You will
need to wrap it inside a DataSet.

See http://support.microsoft.com/default...b;en-us;306134

Regards,
Sami

"Ganga" <ga***@spectradata.co.nz> wrote in message
news:30**************************@posting.google.c om...

Hi All,

I was just wondering whether is it possible to return a Data Table
from a WebService method. Since I need to send only one table at a
time, I dont want to return the entire Dataset.

Any help would be highly appreciated.

Cheers

Ganga.

[Stuart Celarier]

Sami wrote:

No, it is not possible to return a DataTable from a web service. You will
need to wrap it inside a DataSet.

See http://support.microsoft.com/default...b;en-us;306134

Yes, that Knowledge Base article advocates returning a DataSet from a Web
service. However that should be considered a poor practice from a
service-orientation perspective. One of the tenets of service-orientation is
that services share contract and schema ... and nothing else. Passing a
DataSet between Web services violates this tenet, and the result is that it
will only work so long as both endpoints are always .NET platforms.

A better solution would be to pass entity data that is domain- or
business-specific. Not a DataTable, but a set of data that has an actual XSD
schema generated in the WSDL for the Web services so that it can be used by
clients on any platform.

Cheers,
Stuart Celarier, Fern Creek