DataFormatString not Formatting

[Edward]

I have a column that will not format.  I have applied the formatting in the DataFormatString, however, nothing I do seems to change the format of the column.  All the other columns that I have applied formatting to work.

                <telerik:GridBoundColumn DataField="BudgetCodeID" HeaderText="Budget Code" DataFormatString="{0:###-##-####-##-###-##-###}"
                    SortExpression="BudgetCodeID" UniqueName="BudgetCodeID" >
                </telerik:GridBoundColumn>

I should point out that the column I am having trouble with is a nchar in the database that I convert to a string.  When I read that documentation it indicated that you could format any literal string.  Is that true?

Here is a copy of the code for the entire page.  I am doing all of the formatting on the client side.

 

 

<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/MasterPage/BudgetMasterPage.Master" CodeBehind="BudgetSummary.aspx.vb" Inherits="FISDBudgetAjax3._5.BudgetSummary"
    title="FISD Budget Summary" %>
    <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Src="../TopNav.ascx" TagName="TopNav" TagPrefix="uc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
    </asp:ScriptManagerProxy>
    <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="rcbAdminName">
                <UpdatedControls>
                <telerik:AjaxUpdatedControl ControlID="Button2" />
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="Button2">
            <UpdatedControls>
            <telerik:AjaxUpdatedControl ControlID="pnlEdit" />
            </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="Button1">
            <UpdatedControls>
            <telerik:AjaxUpdatedControl ControlID="detailsview1" />
            <telerik:AjaxUpdatedControl ControlID="radGrid1" />
            </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="Detailsview1">
            <UpdatedControls>
            <telerik:AjaxUpdatedControl ControlID="Detailsview1" />
            <telerik:AjaxUpdatedControl ControlID="pnlEdit" />
            </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManagerProxy>
    <table style="width: 100%">
        <tr>
            <td>

                <uc1:TopNav ID="TopNav1" runat="server" />

            </td>
            <td>
                <asp:Image ID="imgBudgetLogo" runat="server" ImageUrl="~/Images/Summary.gif" />
            </td>
            <td>
                <asp:Image ID="imgFISDlogo" runat="server" ImageUrl="~/Images/FISDLogoRed48.gif" />
            </td>
        </tr>
        <tr>
            <td colspan="3">
    <telerik:RadComboBox ID="rcbAdminName" runat="server" DataSourceID="SqlDataSource1"
        DataTextField="Name" DataValueField="Name" AutoPostBack="True" AllowCustomText="True"
                    Width="225px">
        <Items>
            <telerik:RadComboBoxItem runat="server" Text="Select Budget Administrator"
                Value="Select Budget Administrator" />
        </Items>
        <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
    </telerik:RadComboBox><br />

    <asp:Label ID="lblCaption" runat="server" Text=""></asp:Label>
                <br />
                <asp:Button ID="Button2" runat="server" Text="Edit Line Item" Visible="false" />
                <br />
                <asp:Panel ID="pnlEdit" runat="server" Visible="false" >
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                    &nbsp;<br />
                    <asp:Button ID="Button1" runat="server" EnableTheming="True"
                        Text="Find this Line Item" />
                    <br />
                    <asp:DetailsView ID="DetailsView1" runat="server"
                        AutoGenerateRows="False" DataSourceID="SqlDataSource3" Height="50px"
                        Width="125px">
                        <FooterTemplate>
                            <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="Close" />
                        </FooterTemplate>
                        <Fields>
                            <asp:BoundField DataField="Fund_Code" HeaderText="Fund_Code"
                                SortExpression="Fund_Code" />
                            <asp:BoundField DataField="Function_Code" HeaderText="Function_Code"
                                SortExpression="Function_Code" />
                            <asp:BoundField DataField="Object_Code" HeaderText="Object_Code"
                                SortExpression="Object_Code" />
                            <asp:BoundField DataField="SubObject_Code" HeaderText="SubObject_Code"
                                SortExpression="SubObject_Code" />
                            <asp:BoundField DataField="Organization_Code" HeaderText="Organization_Code"
                                SortExpression="Organization_Code" />
                            <asp:BoundField DataField="ProgramIntent_Code" HeaderText="ProgramIntent_Code"
                                SortExpression="ProgramIntent_Code" />
                            <asp:BoundField DataField="Project_Code" HeaderText="Project_Code"
                                SortExpression="Project_Code" />
                            <asp:BoundField DataField="RequesterName" HeaderText="RequesterName"
                                SortExpression="RequesterName" />
                            <asp:BoundField DataField="Quantity" HeaderText="Quantity"
                                SortExpression="Quantity" />
                            <asp:BoundField DataField="Description" HeaderText="Description"
                                SortExpression="Description" />
                            <asp:BoundField DataField="UnitCost" HeaderText="UnitCost"
                                SortExpression="UnitCost" />
                            <asp:CommandField ShowEditButton="True" />
                        </Fields>
                    </asp:DetailsView>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server"
                        ConnectionString="<%$ ConnectionStrings:DB_BudgetConnectionString %>"
                        SelectCommand="usp_SEL_BudgetItembyID" SelectCommandType="StoredProcedure"
                        UpdateCommand="usp_UPD_BudgetItembyAdmin" UpdateCommandType="StoredProcedure">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox1" Name="BudgetID" PropertyName="Text"
                                Type="Int32" />
                        </SelectParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="BudgetID" Type="Int32" />
                            <asp:Parameter Name="Fund_Code" Type="String" />
                            <asp:Parameter Name="Function_Code" Type="String" />
                            <asp:Parameter Name="Object_Code" Type="String" />
                            <asp:Parameter Name="SubObject_Code" Type="String" />
                            <asp:Parameter Name="Organization_Code" Type="String" />
                            <asp:Parameter Name="Project_Code" Type="String" />
                            <asp:Parameter Name="ProgramIntent_Code" Type="String" />
                            <asp:Parameter Name="RequesterName" Type="String" />
                            <asp:Parameter Name="AdministratorName" Type="String" />
                            <asp:Parameter Name="Quantity" Type="Int32" />
                            <asp:Parameter Name="Description" Type="String" />
                            <asp:Parameter Name="UnitCost" Type="Decimal" />
                            <asp:Parameter Name="comments" Type="String" />
                            <asp:Parameter Name="loginuser" Type="String" />
                            <asp:Parameter Name="changetype" Type="String" />
                            <asp:Parameter Name="changeIP" Type="String" />
                            <asp:Parameter Name="changedate" Type="DateTime" />
                            <asp:Parameter Name="vendor" Type="String" />
                        </UpdateParameters>
                    </asp:SqlDataSource>
                </asp:Panel>
            </td>
        </tr>
        <tr>
            <td class="style21" colspan="3">
    <telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" Skin="Sunset"
        ShowFooter="True" Width="1000px" >
        <HeaderContextMenu Skin="Sunset">
            <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
        </HeaderContextMenu>
        <MasterTableView AutoGenerateColumns="False" DataKeyNames="BudgetCodeID">
            <RowIndicatorColumn>
                <HeaderStyle Width="20px"></HeaderStyle>
            </RowIndicatorColumn>
            <DetailTables>
                <telerik:GridTableView runat="server" DataKeyNames="budgetid"
                    DataSourceID="sqldatasource2" AutoGenerateColumns="False">
                    <ParentTableRelation>
                        <telerik:GridRelationFields DetailKeyField="BudgetCodeid"
                            MasterKeyField="BudgetCodeID" />
                    </ParentTableRelation>
                    <RowIndicatorColumn>
                        <HeaderStyle Width="20px" />
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn>
                        <HeaderStyle Width="20px" />
                    </ExpandCollapseColumn>
                    <Columns>
                    <telerik:GridBoundColumn DataField="BudgetID" UniqueName="BudgetID" HeaderText="ID"
                            SortExpression="BudgetID" Aggregate="Count"
                            FooterAggregateFormatString="Items: {0:n0}"></telerik:GridBoundColumn>
                     <telerik:GridBoundColumn DataField="RequesterName" UniqueName="RequesterName" HeaderText="Requester" SortExpression="RequesterName"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Description" UniqueName="Description" HeaderText="Description" SortExpression="Description"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Quantity" DataType="System.Int16"
                            HeaderText="Quantity" SortExpression="Quantity" UniqueName="Quantity">
                            <HeaderStyle HorizontalAlign="Center" />
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="UnitCost" DataFormatString="{0:c}"
                            DataType="System.Decimal" HeaderText="Cost" SortExpression="UnitCost"
                            UniqueName="UnitCost">
                            <HeaderStyle HorizontalAlign="Center" />
                            <ItemStyle HorizontalAlign="Right" />
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn Aggregate="Sum" DataField="Total"
                            FooterAggregateFormatString="Total: {0:c}" HeaderText="Total Cost"
                            SortExpression="Total" UniqueName="Total" DataFormatString="{0:c}">
                            <HeaderStyle HorizontalAlign="Center" />
                            <ItemStyle HorizontalAlign="Right" />
                        </telerik:GridBoundColumn>
               </Columns>
                </telerik:GridTableView>
            </DetailTables>
            <ExpandCollapseColumn>
                <HeaderStyle Width="20px"></HeaderStyle>
            </ExpandCollapseColumn>
            <Columns>
                <telerik:GridBoundColumn  Aggregate="Sum"
                    FooterAggregateFormatString="Total NY Budget: {0:c}" DataField="TotalCost"
                    DataType="System.Decimal" HeaderText="NY Budget"
                    SortExpression="TotalCost" UniqueName="TotalCost" DataFormatString="{0:c}">
                    <HeaderStyle Width="50px" />
                  <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="BudgetCodeID" HeaderText="Budget Code" DataFormatString="{0:###-##-####-##-###-##-###}"
                    SortExpression="BudgetCodeID" UniqueName="BudgetCodeID" >
                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn DataField="DESCR" HeaderText="Description" SortExpression="DESCR"
                    UniqueName="DESCR">

                    <ItemStyle HorizontalAlign="Left" />
                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total CY App: {0:c}" DataField="CYApp" DataType="System.Double" HeaderText="CY App"
                    SortExpression="CYApp" UniqueName="CYApp" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total CY Exp: {0:c}" DataField="CYExp" DataType="System.Double" HeaderText="CY Exp"
                    SortExpression="CYExp" UniqueName="CYExp" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total CY Enc: {0:c}" DataField="CYEnc" DataType="System.Double" HeaderText="CY Enc"
                    SortExpression="CYEnc" UniqueName="CYEnc" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total CY Bal: {0:c}" DataField="CYBal" DataType="System.Double" HeaderText="CY Bal"
                    SortExpression="CYBal" UniqueName="CYBal" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total PY App: {0:c}" DataField="FY8App" DataType="System.Double" HeaderText="PY App"
                    SortExpression="FY8App" UniqueName="FY8App" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total PY Exp: {0:c}" DataField="FY8Exp" DataType="System.Double" HeaderText="PY Exp"
                    SortExpression="FY8Exp" UniqueName="FY8Exp" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total PY Bal: {0:c}" DataField="FY8Bal" DataType="System.Double" HeaderText="PY Bal"
                    SortExpression="FY8Bal" UniqueName="FY8Bal" DataFormatString="{0:c}">
                    <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>
                 <telerik:GridBoundColumn Aggregate="Sum" FooterAggregateFormatString="Total Change: {0:c}" DataField="Budget Change" DataType="System.Double" HeaderText="Change"
                    SortExpression="Budget Change" UniqueName="Budget Change" DataFormatString="{0:c}">
                     <HeaderStyle HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Right" />
                    </telerik:GridBoundColumn>
                   <telerik:GridBoundColumn DataField="BudgetChange Percent" DataType="System.Double" HeaderText="% Change"
                    SortExpression="BudgetChange Percent" UniqueName="BudgetChange Percent" DataFormatString="{0:p2}">
                       <HeaderStyle Width="60px" HorizontalAlign="Center" />
                     <ItemStyle HorizontalAlign="Right" />
                </telerik:GridBoundColumn>

            </Columns>

        </MasterTableView>
        <HeaderStyle Font-Size="Smaller" />
        <ItemStyle Font-Size="Smaller" />
        <AlternatingItemStyle Font-Size="Smaller" />
        <ClientSettings AllowDragToGroup="True">
                        <Scrolling FrozenColumnsCount="1" AllowScroll="True" ScrollHeight="400px"
                            UseStaticHeaders="True" />
                        <Resizing AllowColumnResize="True" />
                    </ClientSettings>
        <FilterMenu Skin="Sunset">
            <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
        </FilterMenu>
    </telerik:RadGrid>
            </td>
        </tr>
    </table>

    <br />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DB_BudgetConnectionString %>"
        SelectCommand="usp_SEL_AdminNames" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
    <asp:Label ID="lblError" runat="server" Text=""></asp:Label>
    <asp:SqlDataSource ID="SqlDataSource2"
        runat="server"
        ConnectionString="<%$ ConnectionStrings:DB_BudgetConnectionString %>"
        SelectCommand="usp_SEL_BudgetItembyBudgetCodeID"
        SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="RadGrid1" Name="BudgetCodeID"
                PropertyName="SelectedValue" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">

    </asp:Content>

Thanks,
Ed

 

 

 

 

[Rosen]

Hello Edward,

As you may know in order string format to be applied the data should be of the correct type. Thus in the your case the data should be of some numeric type (int, double, float etc) in order the supplied format string to work. More information on format strings can be found on msdn here.

All the best,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.