Can you pass a SQLCommand object to/from ASP.NET 2.0x Web Service?
This worked under .Net 1.1 but an upgrade to 2.0 (using IIS 5) caused this to stop.
Amongst the errors at the server level I could see that my SQLCommand "could not be serialized".
Please email or post if you know the answer. Basically, one WebService would populate the SQLCommand "CommandText" with the name of the stored proc to execute, and any SQLParameters. It would then pass this to another Web Service (DLL) which would populate the "Connection" property with the connection string, then execute the SQLCommand and return the dataset to the caller.
February 1, 2008 6:19 AM