>
>Alex,
>>Yeah not only Iformatprovider but .Net help is as clear as mud:)
>>Try:
>>>> dr[1] = double.Parse(sValue, NumberStyles.Currency);
>>
>>PS: Add System.Globalization to using directives.
>>Cetin>
>That certainly pointed me in the right direction. Changing the column format to string
>
>dt.Columns.Add(new DataColumn("Value", typeof(String)));
>>and then later on
>
>dr[1] = double.Parse(sValue, NumberStyles.Currency).ToString("C");
>>did it. They now show as currency in the grid even though it is entered as double. Go figure. But at least I can show the user now.
>
>Thanks!
You made kind of calculated field:) However you could do that keeping the column as double. Something like:
BoundColumn bc = new BoundColumn();
bc.DataField = "Value";
bc.HeaderText="Price";
bc.ItemStyle.HorizontalAlign=HorizontalAlign.Right;
bc.DataFormatString="{0:C2}"; // Format parameter 0 as currency with 2 decimal places
myDataGrid.Columns.Add(bc);Cetin
