Skip to content

Replies

0
Rick Lanpher
Rick Lanpher answered on Mar 3, 2017 3:42 PM

I'm sorry but using a string (via FormatCurrency) inside of the datagrid will remove the Sort as well as the Sum function from the grid. The link you sent is for the WebDateTimeEditor control not for the WebDataGrid. As such I'm not sure what one has to do with the other. If there is a way to tell the WebDataGrid that a certain column should be treated as a currency value and then will sort and sum correctly please advise me of this. 

The second example is in C# which makes it a bit difficult for me to translate, however it does seem to be using Strings again to replace the number into a correct format. Doing this again will make the WebDataGrid lose a lot of functionality. 

I am aware that if I did not have a dynamic table I could set the format string in the HTML via 

<ig:BoundDataField DataFieldName="BoundColumn_0" DataFormatString="${0.00}" Key="BoundColumn_0">

How can I correctly set this field dynamically in VB.Net?