Telerik is a leading vendor of ASP.NET AJAX, ASP.NET MVC, Silverlight, WinForms and WPF controls and components, as well as .NET Reporting, .NET ORM , .NET CMS, Code Analysis, Mocking, Team Productivity and Automated Testing Tools. Building on its expertise in interface development and Microsoft technologies, Telerik helps customers build applications with unparalleled richness, responsiveness and interactivity. Telerik products help thousands of companies to be more productive and deliver reliable applications under budget and on time.
Version Q1 2012 released 04/11/2012
select

Grid / Column Formatting

select
select
select
select
DatesCurrencyNumberTelephone
10/10/06$2.01300%(949)250-9340
12/08/05$35.5445700%(949)365-4897
03/05/00$232.94456000%(609)234-3454
12/16/96$5,263.9567000%(609)654-8974
01/01/01$22,453.74898700%(942)345-2543
09/03/09$604,560.064325746500%(943)643-5644
09/06/06$98,457,669.9945674334500%(344)545-4446
10/10/06$2.01300%(949)250-9340
12/08/05$35.5445700%(949)365-4897
03/05/00$232.94456000%(609)234-3454
12/16/96$5,263.9567000%(609)654-8974
01/01/01$22,453.74898700%(942)345-2543
09/03/09$604,560.064325746500%(943)643-5644
09/06/06$98,457,669.9945674334500%(344)545-4446

  • 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.

Source Code

C# VB.NET
Show code in new window Demo isolation steps
  • <%@ Page Language="VB" AutoEventWireup="false" Inherits="Telerik.GridExamplesVBNET.Client.ColumnFormatting.DefaultVB"
        CodeFile="DefaultVB.aspx.vb" %>

    <%@ Register TagPrefix="telerik" Namespace="Telerik.QuickStart" %>
    <%@ Register TagPrefix="telerik" TagName="Header" Src="~/Common/Header.ascx" %>
    <%@ Register TagPrefix="telerik" TagName="HeadTag" Src="~/Common/HeadTag.ascx" %>
    <%@ Register TagPrefix="telerik" TagName="Footer" Src="~/Common/Footer.ascx" %>
    <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <telerik:HeadTag runat="server" ID="Headtag1"></telerik:HeadTag>
    </head>
    <body class="BODY">
        <form runat="server" id="mainForm" method="post">
            <telerik:Header runat="server" ID="Header1" NavigationLanguage="VB"></telerik:Header>
            <telerik:RadScriptManager ID="RadScriptManager" runat="server"></telerik:RadScriptManager>
            <!-- content start -->
            <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadGrid1">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="ComboDates">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="ComboCurrency">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="ComboNumber">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="ComboTelephone">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1"/>
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                </AjaxSettings>
            </telerik:RadAjaxManager>
          <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />

      <div>
            <table border="0" cellpadding="0px" cellspacing="0px">
                <tr>
                    <td>
                        <telerik:RadComboBox Width="120px" ID="ComboDates" runat="server"
                            AutoPostBack="true" OnSelectedIndexChanged="SelectedIndexChanged">
                            <Items>
                                <telerik:RadComboBoxItem Value="{0:MM/dd/yy}" Text="MM/dd/yy" Selected="true" />
                                <telerik:RadComboBoxItem Value="{0:dddd dd/MM/yy}" Text="dddd dd/MM/yy" />
                                <telerik:RadComboBoxItem Value="{0:MMMM dd, yyyy}" Text="MMMM dd, yyyy" />
                                <telerik:RadComboBoxItem Value="{0:MM/dd/yyyy}" Text="MM/dd/yyyy" />
                                <telerik:RadComboBoxItem Value="{0:MM/dd/yyyy hh:mm:ss}" Text="MM/dd/yyyy hh:mm:ss" />
                            </Items>
                        </telerik:RadComboBox>
                    </td>
                    <td>
                        <telerik:RadComboBox Width="120px" ID="ComboCurrency" runat="server"
                            AutoPostBack="true" OnSelectedIndexChanged="SelectedIndexChanged">
                            <Items>
                                <telerik:RadComboBoxItem Value="{0:$###,###.##}" Text="$###,###.##" Selected="true"/>
                                <telerik:RadComboBoxItem Value="{0:$####.##}" Text="$####.##" />
                                <telerik:RadComboBoxItem Value="{0:####.## GBP}" Text="####.## GBP" />
                                <telerik:RadComboBoxItem Value="{0:####.## JPY}" Text="####.## JPY" />
                                <telerik:RadComboBoxItem Value="{0:� ####.##}" Text="� ####.##" />
                            </Items>
                        </telerik:RadComboBox>
                    </td>
                    <td>
                        <telerik:RadComboBox Width="120px" ID="ComboNumber" runat="server"
                            AutoPostBack="true" OnSelectedIndexChanged="SelectedIndexChanged">
                            <Items>
                                <telerik:RadComboBoxItem Value="{0:#%}" Text="#%" Selected="true"/>
                                <telerik:RadComboBoxItem Value="{0:# inch}" Text="# inch" />
                                <telerik:RadComboBoxItem Value="{0:# cm}" Text="# cm" />
                            </Items>
                        </telerik:RadComboBox>
                    </td>
                    <td>
                        <telerik:RadComboBox Width="120px" ID="ComboTelephone" runat="server"
                            AutoPostBack="true" OnSelectedIndexChanged="SelectedIndexChanged">
                            <Items>
                                <telerik:RadComboBoxItem Value="{0:(###)###-####}" Text="(###)###-####" Selected="true" />
                                <telerik:RadComboBoxItem Value="{0:1 - (###) ###-####}" Text="1 - (###) ###-####"/>
                                <telerik:RadComboBoxItem Value="{0:### ### ####}" Text="### ### ####" />
                                <telerik:RadComboBoxItem Value="{0:###-###-####}" Text="###-###-####" />
                            </Items>
                        </telerik:RadComboBox>
                    </td>
                </tr>
                <tr>
                    <td colspan="4">
                        <telerik:RadGrid
                            Width="480px"
                            ID="RadGrid1"
                            runat="server"
                            DataSourceID="SqlDataSource1"
                            AllowSorting="true">
                            <MasterTableView
                                AutoGenerateColumns="False"
                                DataSourceID="SqlDataSource1">
                                <Columns>
                                    <telerik:GridBoundColumn
                                        DataField="Dates"
                                        DataType="System.DateTime"
                                        HeaderText="Dates"
                                        SortExpression="Dates"
                                        DataFormatString="{0:MM/dd/yy}"
                                        UniqueName="Dates">
                                        <ItemStyle Width="120px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn
                                        DataField="Currency"
                                        DataType="System.Decimal"
                                        HeaderText="Currency"
                                        DataFormatString="{0:$###,###.##}"
                                        SortExpression="Currency"
                                        UniqueName="Currency">
                                        <ItemStyle Width="120px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn
                                        DataField="Number"
                                        DataType="System.Int32"
                                        HeaderText="Number"
                                        DataFormatString="{0:#%}"
                                        SortExpression="Number"
                                        UniqueName="Number">
                                        <ItemStyle Width="120px" />
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn
                                        DataField="Telephone"
                                        HeaderText="Telephone"
                                        DataFormatString="{0:(###)###-####}"
                                        SortExpression="Telephone"
                                        UniqueName="Telephone">
                                        <ItemStyle Width="120px" />
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                        </telerik:RadGrid>
                    </td>
                </tr>
            </table>
            <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"
                ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [AutoFormatting]" runat="server">
            </asp:SqlDataSource>
            </div>
            <!-- content end -->
            <telerik:Footer runat="server" ID="Footer1"></telerik:Footer>
        </form>
    </body>
    </html>

Get more than expected!

Take your time to truly experience the power of RadControls for ASP.NET AJAX with a free 60-day trial backed up by Telerik’s unlimited dedicated support.

Download your RadControls for ASP.NET AJAX trial and jumpstart your development with the available Getting Started resources.

If you have any questions, do not hesitate to contact us at sales@telerik.com.

Copyright 2002-2012 © Telerik. All right reserved
Telerik Inc, 201 Jones Rd, Waltham, MA 02451