Problem Displaying moneyfield in gridview

[Bubbles2]

I am trying to display a moneyfield in a gridview but it displays as 14.9500 instead of 14.95$ Can anyone help please , I have tried editing as {0:c} and {0:0.00} which works for a datalist but not for the display in gridview.:confused::confused::confused:

[kubben]

Create a template column and then in the label set the text to: Text='<%# Convert.ToDouble(DataBinder.Eval(Container.DataItem,"moneyfield")).ToString("C") %>' Hope that helps. Ben

[Hayder Marzouk]

Hi, Set the DefaultCellStyle.Format property of the column to c HTH. Hayder Marzouk

[Bubbles2]

Thanks for your prompt reply but when I edit Gridview columns I can't find this property.:confused:

[Hayder Marzouk]

Hi, My response works in a .Net 2.0 Windows Forms application not is an ASP.NET Project. So... - Edit the gridview columns - Select ure column - Select the property DefaultCellStyle and click the button in the right. - You will find the Format property in a new opened property form - Set the property to c HTH. Hayder Marzouk

[Bubbles2]

Thanks a lot for your help I am using an ASP.NET web site.