ASP.NET Controls visit Telerik website

UI Components

Productivity

JustCode

Data

Automated Testing

WebUI Test Studio

TFS Tools

Content Management

Sitefinity .NET CMS

Search Examples

select

	Grid
	Overview Outlook Grid Web Mail Grid Hierarchy with Templates Filter Templates Persisting Grid Settings What's new Rating column Header Context Filter Menu .NET 3.5 .NET 3.5 Client-side Data Binding Entity Framework CRUD Operations LinqToSql CRUD Operations LinqToSql Manual CRUD Operations Performance Virtual scrolling with client binding Client-side Binding and Caching 300 000 rows with LINQ Using RadInputManager ViewState Optimization Shared RadDatePicker Master/Details Client-side Data Binding Migration from GridView Migration from GridView Columns Column Types Attachment column Calculated Columns Footer Aggregates Column Formatting Column/Row Resize/Reorder Header Context Menu Rows Selected Rows Style Accessing Cells and Rows Items Drag-and-drop Populating with Data Client-side binding Declarative Binding Programmatic Binding Server-side binding Simple Data Binding Advanced Data Binding Various DataSources Master/Detail Grids Programmatic Creation from XML WebService binding Client Binding Server Binding Sorting Basic Sorting Programmatic Sorting Paging Basic Paging Alphabetic Pager Slider/Advanced-style Pager Pager Template Customizing the Pager Custom Paging SEO-friendly Paging Scrolling Scrolling Virtual Scrolling and Paging Frozen Columns Selecting Client-side Row Selection Server-side Row Selection Exporting Export to PDF MS Excel/MS Word/CSV Filtering Basic Filtering Filtering in Hierarchy Filtering Template Columns Google-like Filtering Filtering with RadFilter Hierarchy Declarative Relations Programmatic Binding Several Tables at a Level Client-side Hierarchy Loading Mixed Hierarchy Loading NestedViewTemplate Relations Self-referencing Hierarchy Autogenerate hierarchy Grouping Outlook-style Grouping Group By Expressions Client Group Load Group Footers Insert/Update/Delete Automatic Operations Extracting values Using Column Editors Using Server-side API Edit Form with Multiple Columns Command Item User Control Edit Form Form Template Edit Form PopUp Edit Form Edit on Double-click Editing with external form Update/Insert/Delete in Hierarchy Client-side Insert/Update/Delete Client edit with batch server update Client-side Inline Delete Editing XML Using XmlDataSource Validation Flexible Server-side Validation Programmatic creation On PageInit On PageLoad Creating Hierarchy Programmatically Layout CardView ListView/DataList View Displaying Pivot Data Client-Side API Client Objects and Events Client-side API Keys/Values Client-side Accessibility and Internationalization Keyboard Support Accessibility Compliance Right-to-left Support Appearance/Styling Custom Skin Styling Header, Footer and Pager Styling Edited Rows Application scenarios Binary Images and Upload in Grid AJAX-enabled Context Menu Grid Filtered by Combo Load on Demand Grid in Combobox Combo in Grid Window Editing Resizing RadGrid in RadSplitter RadNumericTextBox for Footer Totals Grid and Aggregate Chart Chart in TemplateColumn Tooltipified RadGrid RadToolBar as Command Item Insert with Tooltip

Grid / Column Formatting

Rate this demo:

Feedback

Run example in: C# VB.NET Change Skin:

Vista

Black
Default
Forest
Hay
Office2007
Outlook
Simple
Sitefinity
Sunset
Telerik
Vista
Web20
WebBlue
Windows7

select

Dates	Currency	Number	Telephone
10/10/06	$2.01	300%	(949)250-9340
12/08/05	$35.54	45700%	(949)365-4897
03/05/00	$232.94	456000%	(609)234-3454
12/16/96	$5,263.95	67000%	(609)654-8974
01/01/01	$22,453.74	898700%	(942)345-2543
09/03/09	$604,560.06	4325746500%	(943)643-5644
09/06/06	$98,457,669.99	45674334500%	(344)545-4446
10/10/06	$2.01	300%	(949)250-9340
12/08/05	$35.54	45700%	(949)365-4897
03/05/00	$232.94	456000%	(609)234-3454
12/16/96	$5,263.95	67000%	(609)654-8974
01/01/01	$22,453.74	898700%	(942)345-2543
09/03/09	$604,560.06	4325746500%	(943)643-5644
09/06/06	$98,457,669.99	45674334500%	(344)545-4446

Example Source Code & Description

Instructions

Open in new window

Use the DataFormatString property to specify a custom format for the values displayed in the GridBoundColumn object. If the DataFormatString property is not set, the field's value is displayed without any special formatting.

The formatting string can be any literal string and usually includes a placeholder for the field's value. For example, in the formatting string is "Item Value: {0}", the field's value is substituted for the {0} placeholder when the string is displayed in the GridBoundColumn object. The rest of the formatting string is displayed as literal text (Item Value in this case).
However, make sure that the columns in the grid source are of the proper type - DateTime (for dates), Integer for telephone numbers/currencies, etc.
Further information about the data format strings can be found in the grid documentation:
Formatting column values

Telerik Inc., 460 Totten Pond Rd, Suite 640, Waltham, MA 02451