20 pts.
 Web Services SQLCommand object
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.

Software/Hardware used:
ASKED: February 1, 2008  6:19 AM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _