Grappling with similar problems for Web Services under ASP.NET 2.0x
The issue is which objects can be “serialzed” so they go thru Web Services.
The dataset is a sure bet. Web Services can pass datasets between themselves and/or client applications (Windows Forms clients or Web Site clients).
The dataset can have zero or more data tables. Your SP can populate the dataset table when you execute the SP as part of the data adapter FILL method. Simply pass the dataset back with or without processing the table data.
For the time being, I am unable to pass a SQLCommand object thru Web Services.
This worked in the previous .Net Framework … but for some reason it “fails” to serialize under 2.0x
Will ask this question in a separate thread.