Retrieving values from a datagrid

[nossah]

I select values from the database and display them in a grid but first I apply formatting to the values. So from the database I may get the value 5236.2389 but the grid may display $5236.24 due to my formatting.

What I want to do is retrieve the value that is displayed in the grid ($5236.24). All efforts so far of trying to access the data either from the dataset or the datagrid will yield the 5236.2389 value and not the formatted value.

I think I need something like datagrid.Cell[1,2].FormattedValue. There has to be a way, I just can''t figure it out.

Thanks in advance.

[Administrator]

HI

Use dgrdataGrid1[0,1].ToString() to obtain value

>I select values from the database and display them in a grid but first I apply formatting to the values. So from the database I may get the value 5236.2389 but the grid may display $5236.24 due to my formatting.
>
>What I want to do is retrieve the value that is displayed in the grid ($5236.24). All efforts so far of trying to access the data either from the dataset or the datagrid will yield the 5236.2389 value and not the formatted value.
>
>I think I need something like datagrid.Cell[1,2].FormattedValue. There has to be a way, I just can''t figure it out.
>
>Thanks in advance.