Number formatting in c#

Question

I am trying to format a number in a GridView that is in in pounds into pence.

e.g. 0.0106 to 1.06

Is it possible to archive this with the DataFormatString on the GridView? Or would it make more sense to do the conversion within the stored procedure?

Answer 1

You like to display the number in the gridview, so convert it as close to the gridview as possible. It is definitely a presentation thing, so do it in that layer of your application.

Using the DateFormatString is correct as this is specifically designed to do what you wish.

Finally, my idea of conversion in the database is that conversion is not something a database was designed for.