Changing Column Format

Hi, I have a table in a dataset, that was filled with a datadapter, and then bounded to a GridListcontrol. I wish to format one specific column in the grid as currency (the data type in the table is double). I tried to do: grdLst.Grid.ColStyles["Value"].Format= "C"; but this doesn't work. How do I do this ? Thank you,

The Grid in a GridListControl is a virtual grid. To set any of the styles, you will need to handle the PrepareViewStyleInfo event and set the style there.

 grdLst.Grid.PrepareViewStyleInfo += new GridPrepareViewStyleInfoEventHandler(PVSI);

//....             

private void PVSI(object sender, GridPrepareViewStyleInfoEventArgs e)
{
    if( e.ColIndex == 2 && e.RowIndex > 0)
        e.Style.Format = "C";
}