Putting $ symbol into Datagrid

[gi11ies]

Hi

I have a datagrid, and wish to put a $ symbol in beside the cost, has anyone any tips on how to do this?

My datagrid code is:

<aspataGrid id="scartdg" AutoGenerateColumns="false" runat="server">
<columns>
<asp:HyperLinkColumn HeaderText ="Product" DataTextField="Product" DataNavigateUrlField="ProductID" DataNavigateUrlFormatString="../products/item.aspx?id={0}"/>
<asp:boundcolumn HeaderText="Qty" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left" DataField="Quantity" />
<asp:boundcolumn HeaderText="Price (each)" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left" DataField="Cost" />
</columns>
</aspataGrid>

I'd like to put it along with:

<asp:boundcolumn HeaderText="Price (each)" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left" DataField="Cost" />

Any help would be great !!!!

Gillies

 

[ca8msm]

There are lots of ways of doing it. You could:

1) Return it in the SQL
2) Add it in the ItemDatBound event
3) Add another control with it in (e.g. a Literal)

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[vbkris]

yeah:
<asp:templatecolumn HeaderText="Price (each)" HeaderStyle-HorizontalAlign="left" ItemStyle-HorizontalAlign="left">
<itemtemplate>
$<%# DataBinder.Eval(Container.DataItems,"Cost") %>
</temtemplate>
</asp:templatecolumn>

Known is handfull, Unknown is worldfull

 

[ca8msm]

I would put it inside a Literal control though rather than just writing it as plain text in the HTML though (i.e. my third suggestion).

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[vbkris]

an e.g.?

Known is handfull, Unknown is worldfull

 

[ca8msm]

The easiest example would actually be in a Label so that it could be easily retrived. e.g.

<asp:Label id="lblCurrency" runat="server">$</asp:Label>

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[vbkris]

i want an example with the control within ItemTemplate(My reference book doesnt have one)...

Known is handfull, Unknown is worldfull

 

[ca8msm]

Just copy the label code so it's within the itemtemplate tag...

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[vbkris]

oh, whats the advantage over simply typing text there???

Known is handfull, Unknown is worldfull

 

[ca8msm]

What if you wanted to change that currency value to a £ sign in code?

If you needed to do it and you used a label, you could use FindControl to get a reference to the label, and set the Text property to equal "£".

How would you change it if you had just written it like in your example?

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[vbkris]

oh ok. is there any performance benefits?

Known is handfull, Unknown is worldfull

 

[vbkris]

>>How would you change it if you had just written it like in your example?

hi did some research and came up this

http://www.dotnetjunkies.com/Tutorial/FFFA1157-CE39-406A-BD0C-7EF3188A91F7.dcik

Known is handfull, Unknown is worldfull

 

[ca8msm]

That example uses a label like I suggested!

If you tried to update to a £ sign using your exmaple you couldn't do it (without a lot of work)!

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[vbkris]

yes it does, but i just pointed out the other approach

Known is handfull, Unknown is worldfull