«

I have tried everything to display a bound column in a gridview to 2
decimals only. The column is a price, and when I run the query in sql, he
value displays as 10.00. Yet in the grid view it displays as 10.0000. I
have tried various settings in the dataformatstring, and it seems to ignore
everything I put there; I've tried: {0}, {0:F2}, {0:d}, {0:c}, among
others. What am I doing wrong?

hook into the itemdatabound event handler and set the cell the way you want
it. consider
e.item.cells[colInQuestion].Text = "#.##";//picture format

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc

"et" <> wrote in message
news:...
>I have tried everything to display a bound column in a gridview to 2
>decimals only. The column is a price, and when I run the query in sql, he
>value displays as 10.00. Yet in the grid view it displays as 10.0000. I
>have tried various settings in the dataformatstring, and it seems to ignore
>everything I put there; I've tried: {0}, {0:F2}, {0:d}, {0:c}, among
>others. What am I doing wrong?
>

Set HtmlEncode = false for the column.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net


"et" <> wrote in message
news:...
>I have tried everything to display a bound column in a gridview to 2
>decimals only. The column is a price, and when I run the query in sql, he
>value displays as 10.00. Yet in the grid view it displays as 10.0000. I
>have tried various settings in the dataformatstring, and it seems to ignore
>everything I put there; I've tried: {0}, {0:F2}, {0:d}, {0:c}, among
>others. What am I doing wrong?
>