I am using the following GridMaskedColumn in my grid. It works great if I want to store my phone numbers in the DB with the special characters but I don't. So I'm stripping the extra characters of the mask off before inserting so a phone is stored as 9999999999 rather than (999) 999-9999.
My first question is why does this write the mask to the database in the first place? A mask is a mask - it should write what's IN the mask and not the mask itself.
Second question - How can I get DataFormatString to work when this column is displayed. Currently my phones are displayed literally as (###) ###-####" . The DataFormatString is not working.
<telerik:GridMaskedColumn Mask="(###) ###-####"
UniqueName="Phone"
HeaderText="Phone"
DataField="Phone"
CurrentFilterFunction="EqualTo"
DataFormatString="(###) ###-####"
FilterListOptions="VaryByDataType"
ForceExtractValue="None">
<ItemStyle Width="100px" />
</telerik:GridMaskedColumn>