Select Data From Database and Convert to XML

ozzy · February 12th, 2005, 11:11 PM

Hey Guys

I'm new to XML. Can someone walk me throught Selecting Data from my SQL Server and displaying the data on a MicroSoft TreeView Web control. Thanks

Thanks

Sincerely; Oscar Martinez

joefawcett · February 13th, 2005, 06:32 AM

I don't know what format the treeview expects. If you show a small example and your table(s) structure I'll try to help.
You'll need to do a normal select query but modify it by adding FOR XML at the end, possibly with other options too. See SQLXML in the sql server books online.

--

Joe (Microsoft MVP - XML)