Does anyone know an easy way to display the Description from a column in SQLServer
as the column header in a DataGrid? Either that, or does anyone know how
to modify the column header dynamically?

I know how to directly code in the column heading, but I do not want to do
this because I do not know what data will be placed in each column, until
runtime. I could write some code that reads the column name and then assigns
a string to the column header. The other option would be to pull the description
out of SQL and simply use this as the column header. I would like to make
this as dynamic as possible. I'm just not sure how to go about doing it!

Any suggestions would be very much appreciated.