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

	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 / Calculated Columns

Rate this demo:

1
2
3
4
5

Feedback

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

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

Product ID

Product name

Unit price

Units in stock

Total Price

Total products: 77

Total price: 2191.71

All units in stock: 3117

Total : 73019.85

1 2 3 4 5 6 7 8

Page size:

77 items in 8 pages

1

Chai

18.00

39

702

2

Chang

19.00

17

323

3

Aniseed Syrup

10.00

13

130

4

Chef Anton's Cajun Seasoning

22.00

53

1166

5

Chef Anton's Gumbo Mix

21.35

0

0

6

Grandma's Boysenberry Spreads

25.00

120

3000

7

Uncle Bob's Organic Dried Pears

30.00

15

450

8

Northwoods Cranberry Sauce

40.00

6

240

9

Mishi Kobe Nikus

66.00

27

1782

10

Ikuras

31.00

31

961

Click PostBack to see the state of the grid is preserved.

Example Source Code & Description

Open in new window

The example demonstrates the usage of GridCalculatedColumn in Telerik RadGrid. You can sort, group and/or
filter these columns exactly in the same way as you would GridBoundColumn. The columns that are going to be used in
the calculation are specified by the DataFields property while the actual calculation is defined via the Expression property:
<Columns>
..
<telerik:GridCalculatedColumn HeaderText="Total Price" UniqueName="TotalPrice" DataType="System.Double"
DataFields="UnitPrice, UnitsInStock" Expression="{0}*{1}" FooterText="Total : " Aggregate="Sum" />
..
</Columns>

Description of this column is available in this help article.

Copyright 2002-2010 © Telerik. All right reserved |

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

www.telerik.com | Terms of Use | Contact Us