Publishin data from sql server in web

Question

Hi friends!

I'm developing small application for my colleagues, I have some procedure on SQL Server, which returns XML. And I'd like to publish this XML on the Web server.

I think that should exist easy way to do it, but I can find it.

I have the following setup:

• SQL Server 2005 Standard
• IIS 7
• Windows Server 2008

best regards

Answer 1

create ASP.Net page that gets results from SQL Server. http://www.asp.net

Answer 2

I can think of the following options

• Display raw XML on the web site.
• Display the XML in an ASP.Net page
• Display the XML data in a data grid
• Apply a style sheet and display the XML data