Is it possible to return just a DataTable from a WebMethod, instead of DataSet?

[Tim Medcalf]

Hi all,

I just want to make sure i'm not doing anything stupid, but it seems to me
that its not possible to return a simple datatable from a WebMethod - it has
to be a full dataset.

The online help seems to state that it is possible with either dataset or
datatable (both remotable, both serializable), but only dataset works for
me.

If i try it with a datatable, when querying the asmx file, i get a message
saying the object cannot be serialized becuase it is an interface. It works
fine when the same datatable is added to a dataset.

Is this correct or am i doing something silly?

Additionally, if this is correct behaviour, could anyone tell my why it is?
Both objects descend from MarshalByValue, and both have the same Interfaces
according to the docs. Any ideas?

Thanks in advance

Tim

 

[MSFT]

Hi Tim,

A datatable can't be be serialized and cannot be returned from an XML Web
service. and there has been a document for this issue:

http://support.microsoft.com/?kbid=306134

Hope this help,

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)