how to decrease decimal places in gridview column asp.net C#

Question

I want to show only 2 decimal places in gridview column. column name is InsuaranceAmount,TotalAmount and TravelAssistAmoun.

for (int i = 0; i < bookingDetailsEmailRS.Length - 1; i++)
 {
BookingDetailsEmailRS[] bookingDetailsEmailRS = b.GetBookingDetails(soap, emailid, out    errorCode, out  errorAtNode);
 GridView1.DataSource = bookingDetailsEmailRS.Select(obj => new
        {
            TravelerName = obj.Travelers[0].FirstName + obj.Travelers[0].MiddleName + obj.Travelers[0].LastName,
            obj.BookingNumber,
            obj.BookingStatus,
            obj.ContactNumber,
            obj.CouponDiscountAmount,
            obj.DepartureDate,
            obj.FromCity,
            obj.ToCity,
            obj.PaidAmount,
            obj.TicketType,
            obj.InsuaranceAmount,
            obj.TotalAmount,
            obj.TravelAssistAmount
        }).ToList();


        GridView1.DataBind();    
 }

In this variable bookingDetailsEmailRS, I got the response.

How are you binding data into your gridview? – whastupduck Feb 22 '13 at 07:51 — whastupduck, Feb 22 '13 at 07:51

score 6 · Accepted Answer · answered Feb 22 '13 at 07:53

6

Use DataFormat property :

<asp:BoundField DataField="InsuaranceAmount" HeaderText="Total Data"  
     ReadOnly="True" SortExpression="totaldata" DataFormatString="{0:0.00}" />

For the second part of your question use Eval method's second parameter to format your data :

<%# Eval("InsuaranceAmount", "{0:0.00}") %>

This might also be helpful

answered Feb 22 '13 at 07:53

Silagy

3,053
2
27
39

I tried these syntax in the tag. – Anurag Jain Feb 22 '13 at 07:59
try instead of DataFormatString="{0:n2}" try: DataFormatString="{0:0.00}" – Silagy Feb 22 '13 at 07:59
1

It's work but It create new column. I am not want create new column. I want this action apply on these particular column. – Anurag Jain Feb 22 '13 at 08:04
can you add the grid view to your question? – Silagy Feb 22 '13 at 08:09
In .aspx page I added these code and .cs page I shown in my que. – Anurag Jain Feb 22 '13 at 08:14
If it worked for you, please consider mark it as the right answer so others will also find it useful. – Silagy Feb 28 '13 at 18:52

score 2 · Answer 2 · answered Feb 22 '13 at 07:54

2

The Eval function has two parameters, the first is the Bindable field and the second is a format for the field. Use something like {0:0.00} in this portion of the control's fields definition.

answered Feb 22 '13 at 07:54

Paul

4,160
3
30
56

score 1 · Answer 3 · answered Feb 22 '13 at 07:59

1

In case of bound columns, you have a DataFormatString attribute. You could do something like to show only 2 decimal places in gridview column:

DataFormatString="{0:0.00}"

Ex:

<asp:BoundField DataField="TotalAmount" HeaderText="Total Amount" DataFormatString="{0:0.00}" />

Reference: Numeric Custom Format Strings

answered Feb 22 '13 at 07:59

palaѕн

72,112
17
116
136

It's work but I want to edit these particular column not create the new column. – Anurag Jain Feb 22 '13 at 08:09
Then you need to use the `asp:TemplateField` http://msdn.microsoft.com/en-us/library/bb288032.aspx – palaѕн Feb 22 '13 at 08:13

how to decrease decimal places in gridview column asp.net C#

3 Answers3

Linked