I have a .NET web application using SQL Server. On one of my pages I have a DataGrid object with a few columns (a DateTime, a few text fields, etc.) The DataGrid is populated using a DataSet that is filled using a SQL query.

One of the columns that is being selected and is thus inserted as a column in the DataGrid contains XML. I would like to apply an XSL transformation to this XML obviously, but I'm not sure what the best way...