Calling a stored procedure from within a web service

Question

I am running vb.net 2003 and sqlserver 2000. I want to call a stored procedure which is on the server from within a web service and use it to populate a datagrid in a windows application. How do I write code in the webservice to access the stored procedure and return the result (a table)?

Any kind of help will be most appreciated.