Formatting dates, numbers and totals

NickWard

I am currently reviewing Datatables.Net with a view to incorporating it into a web application written in Asp .Net. The tool will be used to generate a number of different reports and the HTML table outputted will vary per report so I need a generic approach where I can apply number/date formats and totals dynamically in C# when creating the html table, or at the client side in Datatables.net or jQuery.

Please can some clever and community minded person advise on the following:

1) Formatting and sorting dates and numbers based on the users locale (for a global system) i.e a column of dates in the dd/mm/yyyy or mm/dd/yyyy format

2) Formatting integers and decimals with the correct decimal point and thousand separator i.e 9,999 versus 9.999 or 9,999.99 versus 9.999,99.

3) Providing individual column footer totals (total of table column, total filtered column rows across all pages) with the appropriate decimal point and thousand separator based on the users locale.

Thanks

Nick

joseluisbr

I need the same.