Configuration :: Decimal Place - Convert String To Double
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
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
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
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
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
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
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
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 3, 2010
The biggest difference between double and decimal is that double is a floating point variable type whereas decimal is a fixed point variable .What it means?? Please Explain the abovePoint with Example.According to me both are used to store the folating numbers,then whats the difference between two?
View 1 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
Mar 7, 2013
Select number,empname,empfathername from emp
where number column is float data type
I need first four dights of number where it consists 10 digits.
num is 1234567890
O/P like to be
1234
View 1 Replies
Jul 22, 2010
im getting a value from the database. it came out an error saying "Conversion from DBNULL to Double is not Valid." anyone,
[code]...
View 2 Replies
Jan 21, 2011
im getting a value from the database. it came out an error saying "Conversion from DBNULL to Double is not Valid."
Public Function Total() As Double
Dim Total As Double
Dim strConn As String
strConn = ConfigurationManager.ConnectionStrings("***").ToString
[Code]....
View 6 Replies
Sep 6, 2010
i wanna convert char to double type and convert it to date.char->double then double -> date type.I have a whole string and i trim it into 3 parts. In my item(2) is a UNIX Timestamp i'm trying to convert it into date type.
[Code]....
View 2 Replies
Feb 23, 2010
how to convert decimal to INR currency in asp.net C#. like- 28999345 into 2,89,99,345
View 2 Replies
Dec 21, 2010
In SQL ......
"reading_i" is smallmoney
"reading_f" is smallmoney
CAST(ABS((reading_i - reading_f)) AS VARCHAR)
I want four decimal places alwaysfor example
reading_i = 3.123
reading_f = 1.23
I want 1.8930 (always four decimal places)
View 1 Replies
Feb 9, 2011
is it possible to convert a Currency value $100.00 to a decimal value of 100.00?
View 1 Replies
Jun 25, 2012
i need to convert decimal amount to words for ex: 40300 the Result Should be: Fourty Thousand Three Hundred Rupees only if 40300.35 then: Fourty Thousand Three Hundred Rupees and Thirty Five Paise only.i have tried many Syntax and Functions bt nthing is Working Correctly,
View 1 Replies
Mar 6, 2014
i want to know how to convert number to word , i want only number no decimal or currency .is there any third party tool?
View 1 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
Nov 3, 2010
how this string concatenation taking place? i am really confuse what is happening why that slash i there and how the double quotes are used
SessionStateItemCollection items = new SessionStateItemCollection();
items["LastName"] = "Wilson";
items["FirstName"] = "Dan";
foreach (string s in items.Keys)
Response.Write("items["" + s + ""] = " + items[s].ToString() + "<br />");
Response.Write("items["" + s + ""] = " + items[s].ToString() + "<br />");
View 3 Replies
Feb 9, 2011
im using asp.net and somehow my escape characters dont seem to work
string testing = "my name is "abc"";
this gives the output : my name is "abc"
ive read all the tutorials, everywhere it says that ive to put " to use double quotes inside a string but i have no idea why my system isnt accepting the escape character.
View 7 Replies
Jan 21, 2011
I am developing a asp.net web application, i have a string (with a value in it from a database), with multiple lines that i put in a TextBox with mulitline type. (textarea)
Now the problem is, that in the string are multiple lines, with much empty space. so i want the remove only the double linebreaks.
example of my textbox:
{empty}
{empty}
'This is some text in the textbox on line 3
'some text on line 4
{empty}
'some text on line 6
{empty}
{empty}
'some text on line 9
{empty}
now somehow i want to remove line 1 and 2, and line 7 and 8
View 4 Replies