Skip to main content

Removing unnecessary ZEROs while converting decimal data type to string data type

Sometimes we will come across situation like, while converting decimal value to string, unnecessary '0' will be added to decimal value after decimal point like suppose I have decimal value 100.456 and I want to assign this value to one of my textbox, textbox with (currency) decimal number formatting.
So value will be assigned to textbox like 100.4560. this is because of only conversion of decimal to string.

So we can avoid this if it's really required as per project need by below line of code.

decimal myValue = 100.456;
textbox1.Text = myValue.ToString().TrimEnd('0');

I hope this logic will be helpful for all of us.....

Popular posts from this blog

Creating package in Oracle Database using Toad For Oracle

What are Packages in Oracle Database A package is  a group   of procedures, functions,  variables   and  SQL statements   created as a single unit. It is used to store together related objects. A package has two parts, Package  Specification  and Package Body.

Resolving 'Setup Account Privileges' error while installing SQL Server

A new installation of Microsoft SQL Server 2012 or Microsoft SQL Server 2008 R2 fails You see the following error message when you try to install a new instance of SQL Server 2012 or SQL Server 2008 R2: Rule "Setup account privileges" failed.

Creating Oracle stored Procedures using TOAD for Oracle

In a database management system, a  stored procedure  is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. The use of  stored procedures  can be helpful in controlling  access to data, preserving  data integrity  and  improving  productivity.