I have a Datatable that I attach as a datasource to a Webdatagrid. The Datatable has dynamically chosen columns with dynamically chosen order. As such I never know which columns will be selected and in which order they will be. I do know the Column headers and would like to format the columns that have currency in their fields to have a $ in front of them and 2 decimals after them. I'm not able to figure out how to do this. 

For example:

WebDataGrid1.DataSource = dt

For Each col In WebDataGrid1.Columns
If col.Caption = "Total" Then

...

End If
Next

I can see 

WebDataGrid1.Columns(0).FormatFieldMethod = New FormatRecordItemValue()

But iterating through webdatagrid1 I can't find  col.FormatFieldMethod 

I can also not find what to pass to FormatRecordItemValue as it constantly tells me I'm entering the wrong value. I tried following the example in 

https://www.infragistics.com/community/forums/f/ultimate-ui-for-asp-net/19758/set-dataformatstring-in-server-side-code-for-a-specific-cell