How print out data from stored procedure as XML with Web Service?

I wonder how I can connect with a stored procedure and print out the data as XML, all in a Web Service.cs file? Someone who knows what im talking about?
...