C# - webService - wth stored procedure

[Bapha]

Greetings

I have written a stored procedure which pulls a random row from a table.

Thats all working fine.

I am not trying to write a WebService, using VS.net 2003, which will call this stored procedure, and return the results.

I'm very new to C#, and programming in general.

What I have been doing is browsing to the Stored_Procedure in VS.net then dragging that onto the WebService designer form and that sets up SQLconnection and command.

Now I'm not sure how to get it to work when I run the WebService in the browser.