How to give data format in to gridview in asp.net
How to display only date in Asp.net GridView when fetch data from Database:
hello friends I am pulling data from an access database to show in a GridView control on a ASP.NET project. It works fine but I want to see if I can format the data that is being pulled. Currently any currency is being truncated from xx.xx to just the dollar amounts. Also the dates are displaying mm/dd/yyyy hh/mm/ss AM/PM
Here i will give Some Format Style in Asp.net Gridview there are
DataFormatString in asp.net examples:
- {0:dd MMMM yyyy} - gives 24 February 2006
- {0:MMM dd} - gives Feb 24 (substitue MMM with MMMM for the full month name
- instead of abbreviation)
- {0:dd/MM/yy} - gives 24/02/06
- {0:dd/MM/yyyy} - gives 24/02/2006
- {0:dd MMMM yyyy} - gives 24 February 2006
- {0:MMM dd} - gives Feb 24 (substitue MMM with MMMM for the full month name
- instead of abbreviation)
- {0:dd/MM/yy} - gives 24/02/06
- {0:dd/MM/yyyy} - gives 24/02/2006
Comments
Post a Comment