View Single Post
 
Old June 19th, 2008, 11:19 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Which database, SQL Server 2005 can probably handle all this server-side which would normally be the most efficient. Otherwise you can read the data using a SqlCommand and ExecuteXmlReader which can then be processed as a stream or via XSLT. Or if you want to be cutting edge you could also do this with LINQ to XML.

--

Joe (Microsoft MVP - XML)