Chow.Net
Chow.Net

Reputation: 593

How to insert comma in the value which is present in Hyperlink column in gridview

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 please help me with this? In BoundField I wrote DataFormatString="{0:N2}" which works fine, but I got stuck when using in hyperlink (template field)

Upvotes: 4

Views: 755

Answers (2)

chridam
chridam

Reputation: 103395

Try

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

Upvotes: 1

phemt.latd
phemt.latd

Reputation: 1803

Try with this:

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

Upvotes: 4

Related Questions