how to remove decimals from a value.

Question

4.00/5 (2 votes)

See more:

I have two textboxes one to display quantity and the other for price.What i want is to remove decimals from the quantity and format the second value "price" upto two decimals.

The problem is that the textboxes gives the decimal value however the code gives the correct value.Below is my code for review.

Example: My code gives a value 1 for 1.00 but displayes 1.00 as the value in the textboxes.

Any Help would be appreciated.
ASPX
Below is the aspx

ASP.NET

<asp:Panel ID="pnlOrderCurrent" 
               style="Z-INDEX: 101; LEFT: 23px; POSITION: absolute; TOP: 103px" 
               runat="server" Height="102px" Width="327px">
          <table style="height: 98px; width: 324px">
              
                  <tr>
                      <td>
                          <asp:Image ID="Image1" runat="server" Height="30px" 
                              ImageUrl="~/Images/customer.png" />
                      </td>
                      <td>
                          <asp:TextBox ID="txtCurrentCustomerCode" Runat="server" Height="12px" 
                              Width="70px" AutoPostBack="True" 
                              ontextchanged="txtCurrentCustomerCode_TextChanged">
                          </td>
                      <td>
                          <asp:Image ID="Image2" runat="server" Height="30px" 
                              ImageUrl="~/Images/showvalqty.png" />
                      </td>
                      <td>
 <asp:TextBox ID="txtCurrentValue" Runat="server" Height="12px" Width="70px" Style="text-align: right"> 
                          </td>
  </tr>
 <tr>
                      <td>
 <asp:Image ID="Image3" runat="server" Height="30px" 
                              ImageUrl="~/Images/neworder.png" />
                     </td>
                      <td>
   <asp:TextBox ID="txtCurrentOrder" Runat="server" Height="12px" Width="70px" 
                              >
                      </td>
                      <td>
   <asp:Image ID="Image4" runat="server" Height="30px" 
                              ImageUrl="~/Images/showorder.png" />
                      </td>
                      <td>
 <asp:TextBox ID="txtCurrentQty" Runat="server" Height="12px" Width="70px" Style="text-align: right">
                     </td>
                     
                    </tr>
                    
                   </table>

public void orderitemsummary()
    {
        DataTable dtfrqtyval = new DataTable();
        connfordata.Open();
        SqlCommand cmdfrupdcust = new SqlCommand("sp_SRXO_OrderItemSummary", connfordata);
        SqlDataAdapter dafrqtyval = new SqlDataAdapter(cmdfrupdcust);
        cmdfrupdcust.Parameters.AddWithValue("@W113_XMLID", txtCurrentOrder.Text.Trim());
        cmdfrupdcust.CommandType = CommandType.StoredProcedure;
        cmdfrupdcust.ExecuteNonQuery();
        dafrqtyval.Fill(dtfrqtyval);
        connfordata.Close();

        double qtyval = Convert.ToDouble(dtfrqtyval.Rows[0]["SumQty"].ToString());
        string currentval = dtfrqtyval.Rows[0]["SumVal"].ToString();
        int qtyvalcast = (int)Math.Round(qtyval);

        string[] array = currentval.Split('.');
        string first = array[0];
        string second = array[1];

        string sub = second.Substring(0, 2);

        string final = (first + "." + sub).Trim();


        txtCurrentValue.Text = final;
        txtCurrentQty.Text = qtyvalcast.ToString();
    }

Posted 6-Oct-13 21:19pm

Amit Karyekar

Updated 6-Oct-13 21:32pm

Zafar Sultan

v4

Add a Solution

Comments

Azee 7-Oct-13 3:23am

Could you all post aspx side of the code (TextBoxes) in your question?

Amit Karyekar 7-Oct-13 3:30am

ya please see the edited question.

Azee 7-Oct-13 3:41am

I am a little confused, do you want you TextBoxes to have values with Decimal or without?

5 solutions

Solution 2

Try

Convert.ToInt32(); // instead of Convert.ToDouble()

and for 2 decimal value try

Math.Round(mydoublevalue, 2);

Hope will help you out.

Posted 6-Oct-13 21:41pm

Padam Agrawal

Comments

Amit Karyekar 7-Oct-13 4:16am

even this approach doesnt work out.The value is perfect in the debug mode but when i see it from on the screen automatically decimals are added.

Solution 3

See it's simple do it this way

txtCurrentQty.Text = ((int?)qtyval).ToString();

Posted 6-Oct-13 23:06pm

sankarsan parida

Solution 4

hello professional

try this
may help you

txtCurrentQty.Text = Convert.ToInt32(qtyvalcast);

Happy to Help!!!

Posted 7-Oct-13 1:27am

Shubh Agrahari

Solution 5

plz write below code in our code -

string second = array[1];
string sub = second .Substring(0,second .LastIndexOf(".")+3);

C#

string final = (first + "." + sub).Trim();


        txtCurrentValue.Text = final;
        txtCurrentQty.Text = qtyvalcast.ToString();

Posted 7-Oct-13 8:44am

manvendra patel

Updated 7-Oct-13 8:47am

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

sankarsan parida · Accepted Answer · 2013-10-06T21:41:00

See I have changed your code with comment
See the edited code are following below

C#

double qtyval = Convert.ToDouble(dtfrqtyval.Rows[0]["SumQty"].ToString());
     decimal currentval = Convert.ToDecimal(dtfrqtyval.Rows[0]["SumVal"]);
     //string currentval = dtfrqtyval.Rows[0]["SumVal"].ToString();
    // int qtyvalcast = (int)Math.Round(qtyval);

     //string[] array = currentval.Split('.');
     //string first = array[0];
     //string second = array[1];

     //string sub = second.Substring(0, 2);

     //string final = (first + "." + sub).Trim();


     txtCurrentValue.Text = Math.Round(currentval, 2).ToString();// final;
     txtCurrentQty.Text = qtyval.ToString("n"); //qtyvalcast.ToString();