Thousand Seperator in Grid view

how to get Thousand seperator in Gridview columns when the column is a number either any type

Re: Thousand Seperator in Grid view

<asp:BoundField DataField="YourFieldId" HeaderText="..." DataFormatString="{0:0,0.0}" />

Re: Thousand Seperator in Grid view

if it is boundfield... then try using dataformatstring

<asp:boundfield datafield="ColumnName" dataformatstring="{0:N}" />

hope this helps...

Re: Thousand Seperator in Grid view

k its fine but the data is coming through database its not a bound fiels or custom field

Re: Thousand Seperator in Grid view

You would normally use something like {0:#.##} when formatting data.

Re: Thousand Seperator in Grid view

which place did i use this after databind() method

Re: Thousand Seperator in Grid view

suribabuk

k its fine but the data is coming through database its not a bound fiels or custom field

I suppose, u have set autogeneratecolumns to true for gridview... so u dont have columns defined using boundcolumn or templatecolumn...

u can create RowDataBound event of gridview (select gridview and go to properties window... navigate to event section and doubleclick on RowDataBound event)

define event as this

protected void GridView1_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
	if(e.Row.RowType == DataControlRowType.DataRow)
         {
		e.Row.Cells[1].Text = Strings.Format(Convert.ToDecimal(e.Row.Cells[1].Text), "#,##0.00");
	}
}

considering second column (index 1) need to be formatted i have used Cells[1] in above code... replace index value based on column sequence number

hope this helps...

Re: Thousand Seperator in Grid view

thank u very much but i am using devexpress gridview its not have a rowdatabound event its only have databound event is it similar or different

Re: Thousand Seperator in Grid view

is it ASPxGridView? i think u can use HtmlDataCellPrepared event then

check the HtmlDataCellPrepared event in this link

http://www.devexpress.com/Support/Center/e/E84.aspx

the syntax for formatting the value should remain same

hope this helps...

Re: Thousand Seperator in Grid view

Thank u very much i will check it