I am manually setting the datasource of a datagrid using code and an adodc control.

I cannot get a column to show as currency format( eg $345,33.00)
I know it can be set by right clicking on the datagrid and settin up the properties but my datasource is not static.

is it something like : datagrid.columns("column name").dataformat = ???something?