Web Service using stored procedures example?

18 Aug 2006 5:44 PM

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

18 Aug 2006 5:58 PM

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

Show quoteHide quote

"Dean Slindee" <slin***@charter.net> schreef in bericht
news:Q%mFg.27$EL1.6@newsfe04.lga...
> 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
>

18 Aug 2006 6:52 PM

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:

Show quoteHide quote

> 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