Professional Web Applications Themes

How can I format a number column in a datagrid - ASP.NET Data Grid Control

I tried <asp:BoundColumn DataField="Logins" HeaderText="Logins" DataFormatString="{#,##.0}"></asp:BoundColumn> But it s up. Is there a better way....

  1. #1

    Default How can I format a number column in a datagrid

    I tried
    <asp:BoundColumn DataField="Logins" HeaderText="Logins"
    DataFormatString="{#,##.0}"></asp:BoundColumn>

    But it s up.
    Is there a better way.
    Arne Guest

  2. #2

    Default Re: How can I format a number column in a datagrid

    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsBoundColumnClassDataFor matStringTopic.asp[/url]

    Eliyahu

    "Arne" <Arnediscussions.microsoft.com> wrote in message
    news:86ADA09B-6269-4F71-B212-A858D7159A10microsoft.com...
    > I tried
    > <asp:BoundColumn DataField="Logins" HeaderText="Logins"
    > DataFormatString="{#,##.0}"></asp:BoundColumn>
    >
    > But it s up.
    > Is there a better way.

    Eliyahu Goldin Guest

  3. #3

    Default Re: How can I format a number column in a datagrid

    Eliyahu,
    That didn't work for me.
    Arne.

    "Eliyahu Goldin" wrote:
    > [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsBoundColumnClassDataFor matStringTopic.asp[/url]
    >
    > Eliyahu
    >
    > "Arne" <Arnediscussions.microsoft.com> wrote in message
    > news:86ADA09B-6269-4F71-B212-A858D7159A10microsoft.com...
    > > I tried
    > > <asp:BoundColumn DataField="Logins" HeaderText="Logins"
    > > DataFormatString="{#,##.0}"></asp:BoundColumn>
    > >
    > > But it s up.
    > > Is there a better way.
    >
    >
    >
    Arne Guest

  4. #4

    Default Re: How can I format a number column in a datagrid

    Then do it in code behind in either ItemDataBound or PreRender event. Get
    the cell value and apply formatting string of your choice in ToString
    method.
    For formatting strings look at
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp[/url]

    Eliyahu

    "Arne" <Arnediscussions.microsoft.com> wrote in message
    news:55275D36-AE0F-4D83-83B8-ED04A7A14D63microsoft.com...
    > Eliyahu,
    > That didn't work for me.
    > Arne.
    >
    > "Eliyahu Goldin" wrote:
    >
    > >
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsBoundColumnClassDataFor matStringTopic.asp[/url]
    > >
    > > Eliyahu
    > >
    > > "Arne" <Arnediscussions.microsoft.com> wrote in message
    > > news:86ADA09B-6269-4F71-B212-A858D7159A10microsoft.com...
    > > > I tried
    > > > <asp:BoundColumn DataField="Logins" HeaderText="Logins"
    > > > DataFormatString="{#,##.0}"></asp:BoundColumn>
    > > >
    > > > But it s up.
    > > > Is there a better way.
    > >
    > >
    > >

    Eliyahu Goldin Guest

  5. #5

    Default Re: How can I format a number column in a datagrid

    Eliyahu,
    I had read the two above help files prior to posting my news item. After
    having read you first post a second time I came up with
    <asp:BoundColumn ItemStyle-HorizontalAlign="Right" DataField="Logins"
    HeaderText="Logins" DataFormatString="{0:N0}"></asp:BoundColumn>
    Arne

    "Eliyahu Goldin" wrote:
    > Then do it in code behind in either ItemDataBound or PreRender event. Get
    > the cell value and apply formatting string of your choice in ToString
    > method.
    > For formatting strings look at
    > [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp[/url]
    >
    > Eliyahu
    >
    > "Arne" <Arnediscussions.microsoft.com> wrote in message
    > news:55275D36-AE0F-4D83-83B8-ED04A7A14D63microsoft.com...
    > > Eliyahu,
    > > That didn't work for me.
    > > Arne.
    > >
    > > "Eliyahu Goldin" wrote:
    > >
    > > >
    > [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsBoundColumnClassDataFor matStringTopic.asp[/url]
    > > >
    > > > Eliyahu
    > > >
    > > > "Arne" <Arnediscussions.microsoft.com> wrote in message
    > > > news:86ADA09B-6269-4F71-B212-A858D7159A10microsoft.com...
    > > > > I tried
    > > > > <asp:BoundColumn DataField="Logins" HeaderText="Logins"
    > > > > DataFormatString="{#,##.0}"></asp:BoundColumn>
    > > > >
    > > > > But it s up.
    > > > > Is there a better way.
    > > >
    > > >
    > > >
    >
    >
    >
    Arne Guest

Similar Threads

  1. calculate number of checked boxes in datagrid column
    By lak25 in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: December 23rd, 06:09 PM
  2. right align a number column in a datagrid
    By Arne in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: January 6th, 01:52 PM
  3. Format Phone Number String in Datagrid Column
    By Dave in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: December 6th, 01:49 PM
  4. Datagrid Column Date Format : Recognizes Browser Culture
    By Rod Billett in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: August 27th, 04:19 PM
  5. Column number of datagrid
    By Mago Merlino in forum ASP.NET General
    Replies: 2
    Last Post: July 9th, 08:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139