Formatting Grid from SQL
Hello all,
I am trying to format my grid with user friendly values, but I don't quite know where to do this from.
The two values I am trying to format at the moment are date, and numbers. The date I would like in DD-MMM-YYYY format, and the numbers I would like in #,##0 format.
Do you
1) Format the SQL results
2) Format the ASP Grid
The second part of my question is how do you do this (either way).
I can format the date using the SQL Convert function.
CONVERT(char(12), SaleDate, 3) as SaleDate
|
