Click here to Skip to main content
11,578,241 members (67,097 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET
hello all,


I have a grid view where i am binding the value of price and tax and i want to show them upto two digits after decimal..

.aspx code:-

<asp:GridView runat="server" AllowPaging="True" AlternatingRowStyle-CssClass="alt"
        CellPadding="4" CellSpacing="2" CssClass="mGrid"
        EmptyDataText="There is no Item in your Cart" ForeColor="Black"
                                GridLines="None" ID="Grid1"
        AutoGenerateColumns="False" DataKeyNames="pid"
        onrowcancelingedit="Grid1_RowCancelingEdit"
        onrowdeleting="Grid1_RowDeleting" PagerStyle-CssClass="pgr" ShowFooter="True"
                                Width="100%" onrowediting="Grid1_RowEditing"
        onrowupdating="Grid1_RowUpdating"
        onpageindexchanging="Grid1_PageIndexChanging"
        onrowdatabound="Grid1_RowDataBound">
                                <RowStyle BackColor="White" />
<Columns>
<asp:TemplateField HeaderText="Product ID">
<ItemTemplate>
<asp:Label runat="server" ID="lblpid" Text='<%#Eval("PID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:Label runat="server" ID="lblname" Text='<%#Eval("Name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Quantity">
<ItemTemplate>
<asp:Label runat="server" ID="lblquantity" Text='<%#Eval("Quantity") %>'></asp:Label>
&nbsp; &nbsp;
<asp:LinkButton runat="server" ID="linkedit" CommandName="Edit" Text="Edit" Font-Underline="false"></asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtquantity" Text='<%#Eval("Quantity") %>'></asp:TextBox>
&nbsp;&nbsp;
<asp:LinkButton runat="server" ID="linkupdate" CommandName="Update" Text="Update"></asp:LinkButton>
&nbsp;
<asp:LinkButton runat="server" ID="linkcancel" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Price">
<ItemTemplate>
<asp:Label runat="server" ID="lblprice" Text='<%#Eval("UnitPrice") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tax">
<ItemTemplate>
<asp:Label runat="server" ID="lbltax" Text='<%#Eval("Tax") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Total">
<ItemTemplate>
<asp:Label runat="server" ID="lkbltotalprice" Text='<%# Eval("TotalPrice") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton runat="server" ID="linkdlt" CommandName="Delete"><asp:Image runat="server" ImageUrl="~/WebSiteImages/delete_button.gif" /></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
                                <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
                                <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
                                <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
                                <AlternatingRowStyle CssClass="alt" />
</asp:GridView>


kindly suggest me any solution to format it in eval function...
Posted 20-May-12 19:35pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

use:


 
<% # Eval("Amount","{0:#0.00}") %>
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

hi dear

use displayformat = "{0}:2D" in Gridview colum

thanks
  Permalink  
Comments
abhishekagrwl25 at 22-May-12 3:09am
   
but how to set displayformat in GridView column.??

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web03 | 2.8.150603.1 | Last Updated 21 May 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100