Direct SQLXML Access And XSLt Using ADO.NET

If you want a quick and easy way to directly access a SQL 2005 DB, read the content in XML and render it from your website, here's how:

• ADO.NET access to the SQL:
  http://www.sharpdeveloper.net/content/archive/2007/06/09/how-to-use-sqldatareader-plus-source-code.aspx
• XSL Transformation:
  http://msdn.microsoft.com/en-us/library/ms345117(SQL.90).aspx
• Filling DataSets:
  http://msdn.microsoft.com/en-us/library/bh8kx08z.aspx
• The 'using' statement used appropriately with SqlConnection and SqlCommand:
  http://davidhayden.com/blog/dave/archive/2005/01/13/773.aspx

Please see other links on my blog for how to do more specific things; this is tech I use occasionally, but sometimes in detail.