How do i reduce the decimal RowsOrdered in GridView to something like this 84 instead of this 844444444444444long numbers behind 8 ltaspGridView runat34server34 ID34gvSell34 Width3410034 CssClass34table tablestriped tablebordered responsive34 AutoGenerateColumns34False34 DataKeyNames34SellId34 gt ltColumnsgt ltaspBoundField DataField34SellId34 HeaderText

Hi micahIf this is your decimal field then you can use DataFormatString to format ltaspBoundField DataField34RowsOrdered34 HeaderText34RowsOrdered34 SortExpression34RowsOrdered34 DataFormatString340N134 gt

Formatting double decimal value to single decimal place in ASP.Net GridView using C#

micah

SOLVED CLOSED ACTIVE ANSWERED
User: micah
Posted: on Dec 15, 2017 06:26 AM
Forum: Data Controls
Answer: 2
Views: 10641

How do i reduce the decimal Rows_Ordered in GridView to something like this 8.4 instead of this 8.44444444444444long numbers behind 8?

                      <asp:GridView runat="server" ID="gvSell"  Width="100%" CssClass="table table-striped table-bordered responsive" AutoGenerateColumns="False" DataKeyNames="SellId" >
                          <Columns>
                              <asp:BoundField DataField="SellId" HeaderText="SellId" SortExpression="SellId" InsertVisible="False" ReadOnly="True" />
                              <asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
                              <asp:BoundField DataField="CustomerName" HeaderText="CustomerName" SortExpression="CustomerName" />
                              <asp:BoundField DataField="CustomerAddress" HeaderText="CustomerAddress" SortExpression="CustomerAddress" />
                              <asp:BoundField DataField="CustomerPhone" HeaderText="CustomerPhone" SortExpression="CustomerPhone" />
                              <asp:BoundField DataField="ProductCategory" HeaderText="ProductCategory" SortExpression="ProductCategory" />
                              <asp:BoundField DataField="RowPrice" HeaderText="RowPrice" SortExpression="RowPrice" />
                              <asp:BoundField DataField="PaymentStatus" HeaderText="PaymentStatus" SortExpression="PaymentStatus" />
                              <asp:BoundField DataField="Rows_Ordered" HeaderText="Rows_Ordered" SortExpression="Rows_Ordered" />
                              <asp:BoundField DataField="Cartons" HeaderText="Cartons" SortExpression="Cartons" />
                              <asp:BoundField DataField="TotalAmount" HeaderText="TotalAmount" SortExpression="TotalAmount" />
                              <asp:BoundField DataField="Balance" HeaderText="Balance" SortExpression="Balance" />
                              <asp:BoundField DataField="OrderDate" HeaderText="OrderDate" SortExpression="OrderDate" />
                          </Columns>

                         <EmptyDataTemplate>
                             <asp:Label ID="Labelsal" runat="server" Text="No Sales found" Font-Bold="True" Font-Size="Large"></asp:Label>
                         </EmptyDataTemplate>
                      </asp:GridView>

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Dec 15, 2017 06:28 AM
Report

Hi micah,

If this is your decimal field then you can use DataFormatString to format.

 <asp:BoundField DataField="Rows_Ordered" HeaderText="Rows_Ordered" SortExpression="Rows_Ordered" DataFormatString="{0:N1}" />

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Dec 15, 2017 06:52 AM
Report

Handle it on gridview rowdatabound event.

protected void RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        e.Row.Cells[0].Text = e.Row.Cells[0].Text.Split('.')[0].ToString() + "." + e.Row.Cells[0].Text.Split('.')[1].Substring(0, 1);
    }
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Formatting double decimal value to single decimal place in ASP.Net GridView using C#

Company

Explore

Follow us

Contact Us