Help! Gridview not formatting with DataFormatString

[Burt]

My GridView won't format! See code below, I've got HtmlEncode turned
off, and still nothing works...the GV just has the raw data. Pulling
my hair out over this. Could it be because I'm building the source
(DataTable) dynamically? Thanks for any help. Using .Net 2.0, VS 2005,
VB - Burt


<asp:GridView id="dataGridResults" runat=server
AutoGenerateColumns="False">
<Columns>

<asp:BoundField DataField="Gross Return" HtmlEncode="false"
HeaderText="Gross Return" DataFormatString="{0:#,##0.00}"/> </Columns>
</asp:gridview>


Dim dt As New DataTable
dt.Columns.Add("Gross Return")

For Each Y As Year In u.Years
dr = dt.NewRow()
dr("Gross Return") = py.EndValue
..
..
..

dataGridResults.DataSource = dt
dataGridResults.DataBind()

 

[Angel]

It could be the mixing of the declarative and code that's confusing things.

Try this instead in code.

Dim bf as boundfield = new boundfield
bf.HtmlEncode = False
bf.DataFormatString ="{0: #,##0.00}"
bf.HeaderText="Unit Price"
bf.DataField = "UnitPrice"
GridView1.Columns.Add(bf)

I am going to try your example see if I can get it to work

 

[Angel]

I think that I got it.

In my opinion there is a bug in format. It will not format to specification
if the data type is already a string

So, when you define column do as follows

dt.Columns.Add("Gross Return", GetType(Decimal))

or whatever as long as is not string. I mimic your problem and had the same
results and this fixed it.

Good luck!