Web Service using stored procedures example?

[Dean Slindee]

Anyone know of a location for a simple example of a web service using
stored procedures to Read, Insert, Delete and Update rows in MS SQL Server?

Thanks,
Dean S

 

[Cor Ligthert [MVP]]

Dean,

In my opinion there is for VB.Net no difference between using a stored
procedure and dynamic SQL or you would mean that you won't use VB.Net. But
that this is not the rigth newgroup.

(with the exception that the commands default command setting should be
changed from default to stored procedure).

Cor

 

[tommaso.gastaldi]

Hello Dean,

I don't see any big problem. You just take your sub and paste it into a
web method. Perhaps, just a little care to work with virtual paths.
That's it. The beauty of web services is in the remarkable simplicity
they can be created.

If you have problems with "Read, Insert, Delete and Update rows in MS
SQL Server", which I assume not, that's all another story. Nothing to
do with web services...

tommaso


Dean Slindee ha scritto: