How to insert a comma into a value that is present in a Hyperlink column in a gridview

Question

Here is my markup:

<asp:TemplateField HeaderText="Loss" SortExpression="Loss" HeaderStyle-CssClass="StrongText" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Medium" HeaderStyle-ForeColor="Blue" HeaderStyle-Font-Underline="true" HeaderStyle-VerticalAlign="Bottom" ItemStyle-Width="3%" ItemStyle-HorizontalAlign="Left" ItemStyle-VerticalAlign="Bottom" HeaderStyle-HorizontalAlign="Left"> <ItemTemplate> <asp:HyperLink runat="server" ID="HyperLink8" NavigateUrl='<%#"db_LossofPay.aspx?UserID="+ Eval("User ID")%>' Text='<%# Eval("Loss","{0}")%>' ForeColor="BLUE" Target="_blank"></asp:HyperLink> <asp:Label ID="lblLoss" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> 

Could you help me with this? In BoundField, I wrote DataFormatString="{0:N2}" , which works fine, but I'm stuck when used in a hyperlink (template field)

Answer 1

Try the following:

 <asp:HyperLink runat="server" ID="HyperLink8" NavigateUrl='<%#"db_LossofPay.aspx?UserID="+ Eval("User ID")%>' Text='<%# Eval("Loss","{0:#,##0.00}") %>' ForeColor="BLUE" Target="_blank" /> 

Answer 2

Try

 Text='<%# String.Format("{0:N2}", DataBinder.Eval(Container.DataItem, "Loss"))%>'