IntroductionOn one occasion an old friend, was planning some applications using NET and sockets, and needed to call a WebServices from a stored procedure.
In this article I will share this experience so that other programmers can learn to call a WebService sending parameters from a Stored Procedure.
Step 1We must create our WebServices Project in Visual Studio.
Step 2Then proceed to create the methods that we use in our service, in my case believe 6 methods which are:
Greet (string Param1)and expects a
Stringas the parameter,
HelloWord()does not expect any parameters, and the
Divideproliferation (Num1 int, int num2) want two integers as parameters.
Step 3Proceed to create our stored procedure that will have all the code to invoke the Web Services we have just created, as in all my articles database I use is AdventureWorks, which is the basis of test data that brings SQL Server.
Step 4Then publish the web service on our IIS Web Server
Step 5We proceed to our Store Procedure Coding the data of our Web Service.
Step 6In the procedure to create, we pass a parameter which is the parameter that is waiting
Saludar()method, if they want to use the other methods, should create another parameter because as I mentioned above the other methods are expecting 2 parameters integer type.
Something that is also very important when using the
sp_OAMethodStored Procedure this awaiting the POST or GET method, default almost always send POST, but if we sent this method, we can not display the XML reading generated by our Web Service, so we must use the GET method.
Step 7Proceed to test our Web Service through your browser, type the address of the IIS where the published our Web Service. http://localhost/WebServices/Service1.asmx in the same show all the methods that we created in our Web Service.
Step 8Select the method that we use and invoke from our Stored Procedure,
Saludar(). Then proceed to write the parameter you want to happen to the Web Service, after this we click on Invoke.