Format/Formatinfo of datagrid (vs2003) not formating the data
Posted on 2006-06-29
I have a datagrid setup and its working but its not showing the thousand separater (which in spain we use the . rather than the ,)
so hence 10000 would be represented like so 10.000
I have some code which i thought would work but it isn't. This column i have has values that exceeed 10000 for example.. here is my code
ts = new DataGridTableStyle();
style2.Alignment = HorizontalAlignment.Right;
style2.FormatInfo = SpanishCultureInfo;
style2.Format = "c";
All the other stuff in the style2 is working i..e Right Alignment, mapping and headertext etc-... the formatinfo/format doesn't seem to be working... as in that column all values are not expressed with the . (dot) as the thousand separater
Can anyone help?
Maybe the column is of type STRING..... but should that make a difference?
Thanks in advance