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:
1
|
2
|
3
|
4
|
5
Records: 1 - 10 of 830 - 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}" />

"By the way you guys have done a wonderful job on developing these components. Kudos to y'all."

Toyin Adelaja
Advantage Solutions Group

Random testimonial   All testimonials

Products Downloads
obout.com
obout.com Home
News
Grid Home 
Grid Home
Download
Site Map
Examples - 313
Appearance - 2
Live Styles
Populating with data - 16
Declaratively (Design-time) - 4
Binding to ObjectDataSource
Binding to SqlDataSource
Binding to XmlDataSource
Populating from Stored Procedures
At Run-time - 6
Binding to DataSet
Binding to DataReader
Binding to DataTable
Binding to Generic Collections
Binding to Linq
Binding to LinqDataSource
Best Performance - 3
DataSourceNeeded Event New
Paged ObjectDataSource
Partial Load
Miscellaneous - 3
Switching Data Sources New
Populate on Button Click New
Pivot Table
Add/Edit/Delete - 26
Standard - 3
Add/Edit/Delete Records
Multi-Record
Position for New Record/Links New
Custom Editors - 5
Using Custom Forms
Sliding Row Editor
Using Super Form
Using Super Form in Window
Using Flyout
Excel-Style - 2
Excel-Style New
Excel-Style with Autosave New
Custom Triggers - 4
Edit using Context Menu
Edit on Click
Edit on Double-Click
Edit on Dbl-Click with Auto-Save
Saving to Database - 8
Automatic Updates
Using SqlDataSource
Using ObjectDataSource
Using Stored Procedures New
Detect Unsaved Changes
Add to empty table
Default Values for Add/Edit
Save Changes on the Client Side New
User Confirmation - 2
Before Insert / Update / Delete
Confirmation Using Window
Handling Errors - 2
Handling Errors
Handling Errors with Row Templates
Record Selection - 13
Standard Selection - 2
Select Records
PostBack on Select
Custom Selection - 5
Select using Check Boxes New
Select using only Check Boxes New
Select using Radio Buttons
Select using Checkmark
Select All Group Records
Multiselect without CTRL/SHIFT New
Retrieve Selected Records - 2
Find Selected Records - Client-Side
Find Selected Records - Server-Side
Programmatic Selection - 3
Client-Side
Server-Side
Select All Records
Columns - 22
Manipulating Columns - 4
Resizing Columns
Dynamic Column Resizing New
Reordering Columns New
Show / Hide Columns
Column Types - 2
CheckBoxColumn New
CheckBoxSelectColumn New
Settings - 15
AutoGenerateColumns
Align / HeaderAlign
AllowEdit / AllowDelete
ApplyFormatInEditMode
DataFormatString
Index
NullDisplayText
ParseHTML
ReadOnly
Wrap
Visible
Width
Relative Widths
Relative Width for the Columns/Grid
Auto Resize Columns New
Miscellaneous - 1
Different Styles
Paging - 7
Mode - 2
Standard Paging
Manual Paging
Customization - 4
Position New
Customize Paging
Customize Numbers of Pages
Show ALL records
Client-Side API - 1
Change Page on Client
Sorting - 4
Sorting
Multi-Column Sorting
Sorting Week Days
Allow Sorting for Columns New
Filtering - 25
Standard Filtering - 1
Filtering Records
Custom Filtering - 8
Filter Templates
Filter with Date Picker New
Custom Filter Options with Templates
Between, By Year, By Month
Filter Localized Dates
Filter with On-Demand ComboBox
Live Search New
Filter All with Live Search New
Filter Settings - 3
Filter Position New
Initial State
ALL vs. ANY
Column Settings - 3
Enable/Disable Filtering for Columns
Show/Hide Filter Criterias
Customize Filter Options
Programmatic Filtering - 6
Initial Filter
Programmatic Filter - Client-Side
Alphabetic Filter
Keeping Filter State
External Filter Buttons
Filter On Blur
Best Performance - 2
Filter with DataSourceNeeded Event
Filter with Paged ObjectDataSource
Miscellaneous - 2
Validate Filters
Master/Detail with External Filters
Templates - 31
Templates for Add/Edit
Templates for the Filter
Format Dates
Grid With Images
Add/Edit/Delete Buttons
Add/Edit/Delete Images
Multi-Record Add/Edit/Delete
Filter Buttons
Combine Columns
Wrap the Headers
Manual Paging
Number the records
GroupHeaderTemplateId
Format Currencies
Custom Formatting
With Multiselect Listbox
Edit Using CheckBoxList
With Databound Controls
DropDownList with 'New'
View / Edit Details
Customize for Mobile Devices
Get values from textboxes
Detail View
Different Input Fields for Add/Edit
Different Row Fields for Add/Edit
Templates for Edit-Delete
Reports and Row Templates
Access checkboxes inside
Access radio buttons inside
Multiple Controls
Scrolling - 16
Vertical Scroll with Fixed Headers
Horizontal Scroll
Dynamic Horizontal Scroll New
Vertical & Horizontal
Automatic Scroll
Horizontal Scroll and Filter
Using Percentages
Full Window Width / Height
Automatic Resize with Splitter
Fixed (Frozen) Columns
Fixed (Frozen) Rows New
Fixed Height
Fixed Height in Percentages
Virtual Scrolling New
Virtual Scrolling with Paging New
Keep Scroll On PostBack New
Grouping - 14
Grouping the Records
Allow Grouping for Columns
Initial Grouping
Groups Information
Multi-Page Groups Information
Show Collapsed Groups
Hide Columns When Grouping
Keep Expanded
Format the Group Headers
Customize the Group Headers
Custom Data in Group Headers New
Expand/Collapse Groups
Allow Changes New
Group using CheckBoxes New
Totals / Sub-Totals - 6
Totals
Sub-Totals in Group Footers
Sub-Totals in Group Headers New
Aggregates
Totals of Selected Records
Summary Row
Master / Detail - 35
Loading Mode - 4
Load At Once (OnLoad)
Load On Demand (OnCallback)
Load On PostBack
Load On PostBack with UpdatePanel
Populate with Data - 1
Populate from Stored Procedures
Add / Edit / Delete - 6
Add / edit / delete at runtime
Declarative add / edit / delete New
Using Stored Procedures New
Excel Style New
Using Super Form inside Window New
Handling Errors New
Self-Reference Display - 1
TreeView Hierarchy New
Settings - 3
Show Empty Details - OnLoad
Show Empty Details - OnCallback New
Detail Grid State
Miscellaneous - 4
Multiple Details on the Same Level
Unlimited Number of Levels
Multiple Foreign Keys
Display Info in Flyout New
Templates - 4
Templates for Action Buttons
Detail Grid inside Row Template
Inline Templates inside Detail Grid
Row Template inside Detail Grid New
Customizations - 12
Expand/Collapse All
Client-Side Manipulation
Get Selected Records
Expand/Collapse on Select
Expand/Collapse using Hyperlinks New
Different Styles New
Select on Expand / Collapse
Expand a single detail grid
Keep Expanded Details New
Separated Master/Detail Grids
Expand / Collapse on client side
Auto-Expanding (Fluid) Width New
Column Sets - 4
Column Sets New
Column Sets on Multiple Levels New
Scroll Column Sets Horizontally New
Column Sets with Grouping New
Exporting - 20
Export to Excel / Word
Export to PDF New
Export to CSV New
Export Large Data Sets New
Export on Server Side
Export Master/Detail Grids
Export Groups
Export Totals / Subtotals
Export Templates
Export Images
Export Title / Footer
Export Selected Records New
Export CheckBoxColumn New
Export Multiple Grids as a Single File New
Export Column Sets New
Customize Exported Files
Customize Individual Rows
Exported files Life Time
OnClientExportStart/Finish
ExportedFilesTargetWindow
Accessibility - 2
Key Navigation
Customize the Keys
Localization - 2
Localization
Custom Localization
Client-Side Events - 2
Add / Edit / Delete
Expose the Sender
Server-Side Events - 3
RowCreated/RowDataBound
ColumnsCreated
Row Title
Printing - 5
Printing the Grid
Printing All Pages
Printing All Records without Scrollbars
Printing Selected Records New
Printing Selected Columns New
Validation - 3
Using ASP.NET Validators
Validate Super Form inside Grid
Type Validation
Integration - 21
E-Mail Client
File Browser
D-n-D to Tree
Linked with TreeView
Customers
With Easy Menu
With On-Demand ComboBox New
With Master/Detail ComboBox New
Context menu and CheckBoxes
With DatePicker
With Flyout
With File Upload Progress
With Tab Strip
HTML Editor Inline
HTML Editor in Row Template
With Color Picker
With Window
Using Tooltips
Inside Window
Task List
Purchase Order
ASP.NET AJAX - 8
Live Quotes
With AJAX MaskedEditExtender
With AJAX AlwaysVisible
Millions of Records
Populate Edit Fields
View Row Details
Cascading ComboBoxes New
Cascading ComboBoxes in Row Template
State Keeping - 3
Save Column Widths
Keep Current Page
Keep Current Sort Order
Other Features - 13
ShowLoadingMessage
Hover Effects
Multiple Grids
Refresh the Records
Clear the records
Generate IDs
Client-Side Model
Find and Replace
Using ASP.NET Themes/Skins
Multi columns validation
Validate unknown columns
Inline validation
Millions of Records
Mode - 2
Callback Mode
Postback Mode
Layout Customization- 4
Heading New
Rows - 4
Reorder Rows New
Reorder Rows using Drag and Drop New
Drag and Drop Rows between Grids New
Customize Individual Rows
Knowledge Base - 1
Knowledge Base
Documentation - 25
Server-Side
Column
ColumnCollection
ColumnTemplateSettings
DetailGridLoadingMode
DetailGridState
FilterOption
FilterOptionsCollection
FilterOptionType
Grid
GridAddEditDeleteSettings
GridClientSideEvents
GridCssSettings
GridExportingSettings
GridFilterSettings
GridGroupInformation
GridGroupingSettings
GridLocalizationSettings
GridMasterDetailSettings
GridPagingSettings
GridRecordEventArgs
GridRuntimeTemplate
GridRuntimeTemplateEventArgs
GridScrollingSettings
GridTemplate
GridTemplateSettings
SortOrderType
TemplateContainer
TemplatesCollection
Client-Side
Client-Side API
ChangeLog
Tutorials - 18
Add/Edit/Delete
Updating the Database
Updating using Linq
Appearance
Styles
Styles - Advanced
CSS Tutorial
Client-Side API
Client-Side Events
Columns
Columns
Configuration
Using the correct path
Design-Time Support
All Tutorials
Choosing Data Source
Changing Appearance
Populating with Data
Data-Binding
Serialize
Maximum Performance
Selecting Records
Access Selected Records
Templates
Templates
Runtime Templates
Templates for Buttons
Miscellaneous Tutorials - 14
Getting the Generated ID
Loading the details with AJAX Page
Selecting the inserted/updated record
Server-side validation using Ajax
Edit on Click
Hide "no-records" message
Sending parameters
Disable combobox in Edit mode
Bind data after specified the filter
Get Column Index in template
Custom readonly column
Auto-scroll during postback
Delete button
Move records between grids