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
Similar Messages:
Feb 14, 2011
how to convert the string to 3 decimal place?i want 0.033 for below:
[Code]....
[Code]....
View 2 Replies
Oct 9, 2010
i have a strange error creaping into my web app but am unsure as to how to fix it. When i run this code on my debug workstation it works fine but when i transfer it to my server things seam to go wrong.
dev station (windows 7) + VS2010
regional and language settings all set to uk
server (windows 2008r2)
regional and language settings all set to uk
What seams to be happening is that when converting a string to a double it works correctly on the dev environment but moves the decimal place to the end on the server.
example code(vb)
dim lat as string = "52.983829"
dim long as string = "-0.036500"
dim latint as double = lat
dim longint as double = long
now on the dev server the value of latint is 52.983829 as you might expect but on when published to the server it becomes 52983829.0 the same with longint on the dev staion it is -0.036500 but on the server it becomes -36500.0 i get equally confusing problems if i try to change it to an integer instead.
View 2 Replies
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:
CStr(score)
View 3 Replies
May 11, 2010
In a formview I need to present a new value calucalted by dividing one field value by another. I need to present the result to one decimal place. The code I am using is the following, however it presents the resulting value rounded up or down to the nearest whole value:
<asp:label id=lblTotal text='<%# Convert.ToInt32(Eval("Value1")) / Convert.ToInt32(Eval("value2")) %>' runat="server"></asp:label>
I did try and insert refernces to {0:N1} but this just threw asp.net errors. Any advise on how I can guarantee that the value calculated is presented to one decimal place?
View 4 Replies
Jan 16, 2011
I am displaying a money values in a gridview. Is possible to use inline code to set the decimal places to two? Would like to do it inline instead of in the C# code behind if possible. Database table column [Rate] is datatype money.
GridView1. . . . .
<asp:TemplateField HeaderText="Rate" SortExpression="Rate">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# " total monthly " + "$" + Eval("Rate") %>' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
View 1 Replies
Aug 6, 2010
I'm trying to convert a string to decimal but I get this exception:
Exception Details:
Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: 'string' does not contain a definition for 'AsDecimal'
Here is the code:
decimal PriceHT = 0;
var PriceRequest= "SELECT * FROM Price_" + HttpContext.Current.Session["PriceTableId"] ;
foreach (var Price in Database.OpenFile("Base.sdf").Query(PriceRequest)){
PriceHT = PrixceHT + (Price.PT).AsDecimal(); //Price.PT returns a string
}
View 4 Replies
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
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
Aug 17, 2010
I have a string, that could look like "123,34", "123123,09", "1234", "123.34", "123123.09"
(Stringrepresentation of 10,2 decimal that will be stored into a MySql DB)
Due to the culture of the ASP.net thread may differ, because my application supports localization, I need to find a safe way to convert the most likely user input into a decimal.
How is that possible?
I tried various Decimal.Parse attemps, that all failed so far.
Solution:
My final solution was a mixed one. I used string replace to ensure my date is formatted into the specified CultureInfo I used for parsing
View 6 Replies
Nov 30, 2010
I have below digits. I want to show one digit after to decimal. How to format it?
2.85
2
1.99
I was using ("{0:0.0}". But data showing like
2.9 //It should be 2.8
2.0 //It should be 2
2.0 //It should be 1.9
View 2 Replies
Mar 2, 2011
i have a repeater item that displays a double. occasionally the double seems to be coming out with 3 decimal places like this 1165.833. im trying to force it to two decimal places by wrapping it in a string.format method but it still comes out the same:
<%# String.Format("{0:f2}",DataBinder.Eval(Container.DataItem, "pricerange").ToString())%>
View 3 Replies
Feb 24, 2010
I have a field in my products table called dProductPrice which is a datatype of money. In my datalist i need to display the field as currently it shows price as e,g, 1.3500 but i need it to 2 decimal places so it is 1.35? in my datalist i have done this using the format as well
<%# DataBinder.Eval(Container.DataItem, "dProduct_price", "{0:n2}") %>'
now i have a datatable with a column called cost with datatype decimal.
cartDR["Cost"] = Decimal.Parse(lblProductPrice.Text);
But when i try to populate it i can the input string was not in a correct format. But it works ok if i remove {0:n2}
View 5 Replies
Nov 11, 2010
I'm not getting a trailing zero on currency values and I have no idea why not. This is my code:
[Code]....
Yet this is what is showing up on the screen:
$18.7
Very aggrevating...It should not be doing this as I understand it.
View 4 Replies
Mar 9, 2010
When running our web application the following message appears:
Failed to convert parameter value string to decimal. We believe that the problem might be with the sequence which generates the user_id. The user_id should be the output after successful insert of record. The stored procedure works well from within the DB and Visual Studio. Our DB version: 11gR1 on Windows.The web form has a button event with this c#-code:
[Code]....
[Code]....
View 7 Replies
May 24, 2012
I have to validate for whether the string is decimal/numeric in code behind in asp.net.
View 1 Replies
Sep 14, 2012
I have one dropdownlist control.
But when I Convert It.
It is giving me error:-
System.FormatException: Input string was not in a correct format.
decimal addDomain = Convert.ToDecimal(ddlAddDomains.SelectedValue);
View 1 Replies
Nov 7, 2013
I have qi1 decimal field ... coming error in line ...
txtCostPrice = Convert.ToInt32(((TextBox)GridView2.Rows[i].FindControl("txtcostprice")).Text);
my code
public void savedata() {
con = new SqlConnection(dbcon);
con.Open();
int txtCostPrice = 0;
//int txtSellPrice = 0;
int Primarykey = 0;
[code].....
View 1 Replies
Aug 5, 2010
How can I make the code string connStr = ConfigurationManager.ConnectionStrings "staceys_cakesConnectionString"].ConnectionString;
work generically and not need the staceys_cakesConnectionString? Or how can I set it somewhere else so I only have to change it one place when I change it?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
[Code]....
View 3 Replies
Mar 26, 2010
I read a CSV file into a DataTable.The DataTable in the first image shows each column and type.The types are exactly what they are supposed to be and the data loaded all the rows it was supposed to load.From the second screen shot you can see the database table. SqlBulkCopy is supposed to map column names to database columns by default.According to that logic each column matches up exactly to the database and the column types also match.However,when I run the command it errors on the first row with:
"The given value of type String from the data source cannot be converted to type decimal of the specified target column."
Here is the StackTrace:
"at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at
[code]...
Anyone have any ideas why this will not import correctly?
http://www.daviddelella.com/Images/Image1.jpg
http://www.daviddelella.com/Images/Image2.jpg
View 4 Replies
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++)
[code]...
hows hould i round up while binding..?
View 1 Replies
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
Apr 6, 2010
I'm trying to execute this statement every minute with SQL Agent, I have it set up as a job:
[Code]....
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:
[Code]....
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
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
May 5, 2010
I need a validation regex for decimal. It should allow upto 5 digits after decimal.
Allow:
1
1.0
12.0
12.01
123.01
1,123.01
1,123.013
21,123.01234
3,21,123.01234
How Can I do regex for this?
View 4 Replies
