Thousand seperator in devexpress aspxgridview RSS

• • Reply
  

  suribabuk

  Member

  2 Points

  42 Posts

  Thousand seperator in devexpress aspxgridview

  Apr 16, 2012 08:13 AM|LINK

  Thousand seperator in gridview the data is comin to the grid through the database and autogeneratecolumns is set to true i can bind the data to grid but i want thousand seperator in grid data like numeric numbers on all the columns how to do it just like 10000 i want 10 000

• • Reply
  

  ramiramilu

  All-Star

  97849 Points

  14494 Posts

  Re: Thousand seperator in devexpress aspxgridview

  Apr 16, 2012 08:40 AM|LINK

  Please post your question in DevExpress forums - http://community.devexpress.com/forums/ 

  Thanks,

  Website
  JumpStart
• • Reply
  

  suribabuk

  Member

  2 Points

  42 Posts

  Re: Thousand seperator in devexpress aspxgridview

  Apr 17, 2012 01:04 PM|LINK

  k i found the technique but it display precision value also

  i want to remove for some of the columns what can i do

  example 10000-  10 000.00 i want only 10 000

  here my code

    <dx:GridViewDataSpinEditColumn FieldName="InvoiceBrackets" VisibleIndex="0">
                          <PropertiesSpinEdit DisplayFormatString="n" ></PropertiesSpinEdit>
                          </dx:GridViewDataSpinEditColumn>

• • Reply
  

  YunJiang

  Participant

  1124 Points

  122 Posts

  Re: Thousand seperator in devexpress aspxgridview

  Apr 28, 2012 03:29 PM|LINK

  <Columns>
      <asp:BoundField DataField="Thousand" DataFormatString="{0:0,0}" />
  </Columns>

  Or

  <asp:TemplateField> 
      <ItemTemplate> 
          <asp:Lable ID="Lable1" runat="server" Text='<%# string.Format("{0:0,0}", Int64.Parse(Eval("Your bind field").ToString())) %>' /> 
      </ItemTemplate> 
  </asp:TemplateField>

  read: Numerical Format Strings

  http://sharpertutorials.com/string-formatting/

   

  • Edited by YunJiang on Apr 28, 2012 03:30 PM
  • Marked as answer by Ming Xu - MSFT on Apr 30, 2012 02:34 PM