How do you format values in a grid column

[TerDavis]

Hi,
I have a grid with the usual stuff, Name, Phone Number and Address.

I want to display the PhoneNumber in the 123-1234 format instead of how it is being stored in the db field which is 1231234.

For a column in the grid, you cannot select a masked text box and can only select a text box. Though there is a dataviewstyle format property ....but i could not get this work correctly, ( assuming this is the correct path )..

so, how do you format a value in the grid that is a databound column such that the format value is not saved to the db and formats on load ?

 

[SHelton]

Some options:

1. Use STUFF in the select query when selecting the Phone Number column from the database to insert a hyphen, eg. STUFF(PhoneNumber, 4, 0, '-') AS PhoneNumber.

2. Use a custom datagrid table style with a custom gridcolumnstyle (see the VS help for an example or search these forums).