We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Retrieving values from a datagrid

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.

1 Reply

AD Administrator Syncfusion Team December 20, 2005 07:40 AM

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.

Loader.
Live Chat Icon For mobile
Up arrow icon