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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!