XML WebService

[Kit Fisto]

Hello. I need your help. I have to build a web service that returns a xml with some data from a SQL Data Base. Witch is the best and more effective way of accomplish that? Thanks all.

[Yusuf]

huh? do you know how to build webservice? If so, what is your question?

Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

[Kit Fisto]

Yes i know how to build webservices but it's the first time i have to build one that has a method that returns xml. It's the first time I will write/read XML programatically, so any help or guidance will be appreciated.

[Abhijit Jana]

Ice_LS00 wrote:

I have to build a web service that returns a xml with some data from a SQL Data Base

You can use For XML Auto in SQL Server SP's to return XML. and for return XML from web methods, check HOW TO: Use XmlDocument Elements When Passed to or Returned from WebMethods by Using Visual C# .NET[^]

cheers, Abhijit CodeProject MVP

[Kit Fisto]

Thanks Man. You helped me alot. You solved my problem. :)

[Abhijit Jana]

Great! Go ahead. :)

cheers, Abhijit CodeProject MVP