OBOUT - ASP.NET Grid - Formatting data using the DataFormatString property

Quick Links

ASP.NET Grid - Formatting data using the DataFormatString property

ORDER ID

SHIP NAME

ORDER DATE

SHIPPED DATE

REQUIRED DATE

FREIGHT


10248	Vins et alcools Chevalier	07/04/1996 7/4/1996 12:00:00 AM	16-Jul-1996 7/16/1996 12:00:00 AM	August 01, 1996 8/1/1996 12:00:00 AM	$32.38 32.3800
10249	Toms Spezialitäten	07/05/1996 7/5/1996 12:00:00 AM	10-Jul-1996 7/10/1996 12:00:00 AM	August 16, 1996 8/16/1996 12:00:00 AM	$11.61 11.6100
10250	Hanari Carnes	07/08/1996 7/8/1996 12:00:00 AM	12-Jul-1996 7/12/1996 12:00:00 AM	August 05, 1996 8/5/1996 12:00:00 AM	$65.83 65.8300
10251	Victuailles en stock	07/08/1996 7/8/1996 12:00:00 AM	15-Jul-1996 7/15/1996 12:00:00 AM	August 05, 1996 8/5/1996 12:00:00 AM	$41.34 41.3400
10252	Suprêmes délices	07/09/1996 7/9/1996 12:00:00 AM	11-Jul-1996 7/11/1996 12:00:00 AM	August 06, 1996 8/6/1996 12:00:00 AM	$51.30 51.3000
10253	Hanari Carnes	07/10/1996 7/10/1996 12:00:00 AM	16-Jul-1996 7/16/1996 12:00:00 AM	July 24, 1996 7/24/1996 12:00:00 AM	$58.17 58.1700
10254	Chop-suey Chinese	07/11/1996 7/11/1996 12:00:00 AM	23-Jul-1996 7/23/1996 12:00:00 AM	August 08, 1996 8/8/1996 12:00:00 AM	$22.98 22.9800
10255	Richter Supermarkt	07/12/1996 7/12/1996 12:00:00 AM	15-Jul-1996 7/15/1996 12:00:00 AM	August 09, 1996 8/9/1996 12:00:00 AM	$148.33 148.3300
10256	Wellington Importadora	07/15/1996 7/15/1996 12:00:00 AM	17-Jul-1996 7/17/1996 12:00:00 AM	August 12, 1996 8/12/1996 12:00:00 AM	$13.97 13.9700
10257	HILARION-Abastos	07/16/1996 7/16/1996 12:00:00 AM	22-Jul-1996 7/22/1996 12:00:00 AM	August 13, 1996 8/13/1996 12:00:00 AM	$81.91 81.9100

Records per page:

Records: 1 - 10 of 25 - Pages:

Use the DataFormatString property of the Column class to format the values from the grid's cells.

ASP.NET

<obout:Column DataField="OrderDate"  DataFormatString="{0:MM/dd/yyyy}" />
<obout:Column DataField="ShippedDate"  DataFormatString="{0:dd-MMM-yyyy}" />
<obout:Column DataField="RequiredDate"  DataFormatString="{0:MMMM dd, yyyy}" />
<obout:Column DataField="Freight"  DataFormatString="{0:C2}" />