Change Decimal To % Using .net?

May 14, 2010

I have a variable Amount in my class...

this Amount value is comming from database as decimal something .0.000654345 while displaying in grid I need to show this as % value..

View 6 Replies

Similar Messages:

Forms Data Controls :: Test Mode Change In Gridview / Stating can't Change String To Decimal?

Sep 14, 2010

When i run the following code i get an error when gridview changes mode to Edit. stating that you can't change string to decimal!

To get around the occurance i want to disable code when in Edit mode or resolve another way?

For Each row As GridViewRow In GridView1.Rows
Dim cell As TableCell = row.Cells(7)
Dim invoicetotal As Decimal = CDec(cell.Text)

View 2 Replies

Data Controls :: Round Up Decimal Value Upto Two Decimal Places In GridView

Aug 22, 2012

i hav one data table in which some decimal values are up 6 decimal places.. im trying to bind that Data table to DataGridView while binding i want to round decimal values up to two decimal palces here is my code

dt.Columns.Add("Orderid", typeof(string));
dt.Columns.Add("tagnumber", typeof(string));
dt.Columns.Add("Minimum Value", typeof(string));
dt.Columns.Add("Maximum Value", typeof(string));
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)


hows hould i round up while binding..?

View 1 Replies

Data Controls :: GridView Export To Excel - Round Decimal Numbers To Two Decimal Places

May 7, 2015

I was read your post: "Export GridView to Excel in ASP.Net with Formatting using C#" and is very useful. That code works perfect. But I need create a new format for a specific column in my sheet before to export it. For example:My DataTable have a column with decimal numbers and I'm trying reduce the tenths for each number.I want this: 2,874444 ----> 2,87 for a specific range. In this case I need it for all numbers in the column 13 or well said for the Column called N in Excel. Only reduce two tenths.

I used:

xlWorkSheet.Range["N"+h,"N"+h].NumberFormat = "0.00";

And no works (h is for rows, N is the column. Into a foreach).

View 1 Replies

DataSource Controls :: Decimal Values Not Updating With Decimal Places?

Apr 6, 2010

I'm trying to execute this statement every minute with SQL Agent, I have it set up as a job:


It's trying to update a column which data type is set to decimal. Just so you know what I really need out of it, here is an example:


The answer of which should add on 0.5 to the original value. If I were to use the increase value of 60 which then becomes 60/60 it will work.I'm dividing by 60 because the increase value is per hour so I make it smaller to get per minute value. Why is it doing this?

View 2 Replies

C# - Doing A Math.Round(x,2) On A Decimal Value, But Need To Ensure 2 Numbers After Decimal As Its Money

Mar 3, 2010

Some values are returning 2.0 but I need it to be 2.00 as this is a money value that is displayed to the web page.

I am doing:

Math.Round(value, 2);

Is there a way to force it to 2 numbers after the decimal?

View 3 Replies

Validation Regex For Decimal - Allow Upto 5 Digits After Decimal?

May 5, 2010

I need a validation regex for decimal. It should allow upto 5 digits after decimal.


How Can I do regex for this?

View 4 Replies

MVC :: TextBoxFor Decimal Member Without Decimal Places?

Feb 28, 2011

I got a decimal member in my viewmodel and get populated from the database (say 55.5, or 100.00)

In my view I use TextBoxFor<> for this member.

Is there any way to have a number (it's actually a percentage) like 100.00 display as 100 instead, and 55.50 as 55.5?

View 1 Replies

Get Decimal Value Decimal.Round?

Feb 15, 2011

int Def[0] = {6};
iMaxValue = 55;
decimal val = Decimal.Round(Convert.ToDecimal((DefCount[I]) / iMaxValue),3);

here if i try to run this it says answer 0 ; but if i want 0.1090

View 1 Replies

Can't Multiply Int By Int And Get A Decimal (0,00)?

Sep 30, 2010

I have two int in my applicantion and I want multiply and share by 100. This number can be like 7,5 but my decimal result member always save just can I deal with this question?

decimal result = 0;
decimal a = 15;
decimal b = 50;
result = (a*b)/100;

View 5 Replies

How To Round Up To Two Decimal Places

Mar 29, 2010

i am not good at javascript, but trying to implement or google up a function that would only allow characters in a textbox to have

1. only numeric characters

2. 2 decimal places.

I got this online, but it slices the 3rd decimal, i want it to allow only 2 decimals, any pointers ?


View 10 Replies

Comparing Decimal Values In C#

Feb 22, 2010

I have a few values in c#, how do i compare if a variable is equal to 5.5 ?

here is my code

double res = 4.5;
double ehi = 5.5 ;
ehi= decimal.Compare( res, ehi);

View 3 Replies

How To Add A Decimal Point To A String

Jun 28, 2010

If I have a string/integer that looks like 123, how can I convert that to look like 12.3?Basically what I need is something faster (if possible) than thisMath.Round(Double.Parse(input / 1000), 1).ToString

View 1 Replies

Use Of MaskedEditExtender With Decimal Point?

May 21, 2010

I am using Ajax extender controls with 3.5 in particular MaskedEditExtender.My settinngs are:

Mask = 99.99
InputDirection = RighttoLeft
MaskType = number.

I can't seem to achieve what I want which is to set the focus just to the left of the decimal point. I try both InputDirection RightToLeft and LeftToRight. They both have problematic behavior. The example given by Microsoft on their web site, is close to want I want but I cannot achieve these results.See

View 1 Replies

Web Forms :: Numeric (28,15) VS Decimal (28,15)?

Dec 20, 2010

I am not sure of the answer, I have created a field in the Database and created a gridview.To show the .9393939393 a couple of decimal in the gridview. I used this format


Through out the experiment, I found out that the decimal and the numeric are getting same format, is that right.

View 1 Replies

Only Two Digits Allowed After Decimal?

Jan 4, 2011

I have a textbox where the user must not be able to enter more than two digits after a decimal.How do I do this without using javascript?

View 3 Replies

Web Forms :: Add Comma In Decimal Value?

Nov 2, 2010

how to Add comma in my Decimal value 11000. i want to result like this 11,000.00

View 4 Replies

C# - Number Decimal Format?

Mar 30, 2011

I have a textbox and user enter a number in it. I want to allow 2 decimal digits. For example; number: 12,256 -> I want to allow 12,25 not 3 digits after comma(2 number after comma). How can I do it?

View 4 Replies

Regular Expression For Decimal

Jul 24, 2012

I currently have this regular expression for a whole number with optional decimal to 2 places.

I need to change it so that the number has to be greater than 1.


View 5 Replies

How To Convert Exponent String To Decimal

Apr 10, 2010

I have 6E-11,4.4E-11 values in db and I am converting it to decimal. I have C# code:

string mystring = "6E-11";

decimal myno =Decimal.Parse (mystring, System.Globalization.NumberStyles.AllowExponent);

but it still not work.

View 7 Replies

How To Validate Multiple Decimal Points

Jun 21, 2010

How to validate if user enters more than one decimal points(dots) in fields such as Cost. ie; 250.45.66

View 7 Replies

Causes String To Lose Decimal Place?

Sep 7, 2010

Just to be forward, my .net and c# expierence is very limited, that one could say I'm a complete noob :) However I do have some grasp on OOP as I usually work in PHP (FWIW). My problem seems to be with this line:

Session["total"] = dt.Compute("SUM(price)", "").ToString();

which will output a total of say "9.2" where as the price is "9.20" from a few record lines as such:

dt.Rows.Add(strRecord, 9.20, dropDownListDistrict_stepTitle.Text);
thus 9.20 + 9.20 = "18.40", but the page displays "18.4".

The label that displays the total sum is:

<asp:Label ID="labelTotal3" runat="server" Text="0" />

From what I've gathered, I'm suffering from some kind of type casting problem? Hopefully I haven't missed anything, its a bit difficult to show all the code but hopefully someone can point me in the right direction? Question is; how can I get an extra decimal place to show up on my sum (or why is it dropping the last decimal place?).

View 6 Replies

Limit Double At Six Decimal Place?

Mar 4, 2010

i have a double, the decimal place isn't fix (8-?) i want to fix the decimal place to six (for example: 1,234567). this is my double:


View 3 Replies

Reading A Floating Decimal From A Text Box With $

Jan 2, 2011

eliminate a comma when reading a sales price from a text box.

Dim SPnc As String = Regex.Replace(txtValue.Text, ",", "")
Value = Convert.ToSingle(SPnc)

However, I am still at a loss to find out how to eliminate the $, which I believe is a metacharacter with a special meaning. If my user enters $100,000, the value is read as 0.

View 6 Replies

SQL Server :: Which One Is Better To Work With In Sql And - Money Or Decimal

Aug 18, 2010

I want a field to keep money value (up to 100,000,000.00). And I didn't work with money or decimal data type. Money data Type is 8 byte Decimal (9, 2) is 5 byte. (Exactly msdn only say Decimal (9, 0) is 5 byte and I don't really know how byte is Decimal (9, 2)) which one is better to work with in sql and (handling sql in VS)

View 2 Replies

Copyrights 2005-15, All rights reserved