title: Formatting a datatable's column to show currency
body: <p>I am inputing a datatable into a gridview to show several different charges from this past year.  I want the charges in the gridview to appear in currency format but I would also like to be able to sort the columns when the headers are clicked.<br>
    I can get the format to be currency easily if the columns are of the type string
  ex.
        dim dt as DataTable
        dt.Columns.Add("ChargeField ", System.Type.GetType("System.String"))</p>
  
  <p>but the sorting doesn't work right when it is a string</p>
  
  <p>I sort by using this code
  dt.DefaultView.Sort = ChargeField &amp; " " &amp; ASC</p>
  
  <p>Sorting does work when the columns are of type double
  ex.
  dt.Columns.Add("ChargeField ", System.Type.GetType("System.Double"))</p>
  
  <p>but then it isn't in currency format.</p>
  
  <p>Is there a way to make the datatable/Gridview have a double/decimal column that shows its values as currency?  If not, is there a better way to accomplish what I am trying to do?</p>