Passing datatable to a .Net webservice?

Question

I want to pass datatable to a .Net webservice, i dont want to pass dataset, i need to pass only datatable..

Answer 1

It would help if you mentioned what platform/language you're developing in, that needs to invoke the .NET web service. If we assume it is also .NET, you just need to create your project in Visual Studio and go to Add Web Reference, enter the URL of the web service, and it will download the WSDL and treat the service as a kind of "virtual assembly" - you can then invoke it as you would any other normal method, passing the datatable directly to the method.

Under .NET 1.1, you need to pass a dataset containing the datatable you want to pass.

Answer 2

You can do that in .NET 2.0 but not .NET 1.1. Under .NET 2.0 a DataTable is serializable.

As for using DataSets and DataTables to pass data between a web service and a client application, you need to to ask yourself why you are using web services to start with. They are designed, after all, for the purpose of interop/integration. If you are using them for that intended purpose then you want the generic XML solution.

You might also find this link very interesting
http://support.microsoft.com/default.aspx?scid=kb;en-us;306134