Question

  Asked: Feb 1 2008   6:19 AM GMT
  Asked by: OlSureHand


Web Services SQLCommand object


WebServices, ASP.NET

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on Development.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register