Dim q = From p In ds_raport.Tables(1) _
Group p By p!Cod_Prj Into g = Group _
Select New With {g, .TotalVal = g.Sum(Function(p) p!Valoare)}
The problem is because column "valoare" is of type string ( i import this from a file that is not always properly formatted) my sum has no decimals.So how can i make the sum to display decimals ?
I am trying to do a simple summary of table data using a LINQ query.a regular SQL Query looks like:[code]This query works fine and returns the correct results.[code]This LINQ query returns the incorrect results some of the time. Off by .01 in most cases.The "value" column is of type Numeric (12,2) in the database.Now when I show the values from the Sum in a msgbox I get extra precision and thus incorrect results as my end result because of rounding.For example I get 835.18 + 54.62 = 889.80960 from the above LINQ query.I am running Visual Studio 2008 9.0.30729.1 SP on Vista 64Bit with .NET 3.5 SP1.
I have a field that I display via: String.Format({0:c},amount) This produces the string "$28.28" However, when I try to convert back to a decimal amount, I get an incorrect format exception: amount = Decimal.Parse(amount.Text, NumberStyles.Currency) I also tried it with NumberStyles.AllowCurrencySymbol with the same results. I verified that the value in amount.Text is "$28.28". Am I missing something? Shouldn't these two operations use the same currency symbol and formats?
I'd like to convert a string which contains a decimal number into string that contains the binary value, the octal and the hexadecimal value of that decimal number.Afterwards I also like to convert a string containing a binary, octal and hexd. number into a decimal string.Basically I'm looking for the functions:
dec2bin dec2oct dec2hex bin2dec oct2dec hex2dec
I'd not prefer to rewrite a function, I'm sure the framework must have these functions already.
I'm trying to filter the results of a xml file. One of the fields I've been requested to filter is the attribute price of each node. The problem is the xml is from a spanish source and the prices are with decimal separator being , instead of . and thousands separator is , instead of .I'm trying to get an xml file filtered where only nodes withprices lower than one supplied appear.
I've tried to filter using XPath and Linq2Xml. I've come to the conclussion I have to replace , with . and . with , but I get 0 results.With values below 1000 where there is only , I've got it using:
First: Ok so I'm trying to do a project in my beginning VB .Net class. We are supposed to be taking information from 5 different sections of a form and store them into an array and then call upon them later. We have Name, Address, City,State, and Zip. How would I go about saving the information into an array and then calling upon it later through File IO?
Second: I'm having a problem converting my string into a decimal. Whenever I calculate the price of the order I get 3-4 decimal places. Here is a little snippet of my code for the this:
[code]...
I have dimmed pricewithout tax as a decimal and stateselect as a string. The stateselect is based off a drop down list.
How to add decimal point (with two decimal places) to string, without converting string to decimal? For example (Dim str1 as String), regardless str1 has value: 100 , 100.0 , 100.00, or 100.5 , 100.50..I'd like to get the output: 100.00 or 100.50, with two decimal places.
I'm sure this is simple to do but I'm struggling to get this work, I've tried using convert.tostring, decimal.tostring, ctype(object, type) and cstr(object) but without success. I guess I'm trying to change the decial object to a string object and then assign it a value of empty string but always get type mismatch error.[code]
in simple application, when i am trying to convert string "$2432.23" to decimal (i have taken reference from a book, that cDec can handle $ and , ), it gives error InvalidCastexception
Dim amt As Decimal = CDec(txtSubtotal.Text) i entered "$2432.23"
I have an app that deals with currency. For display purposes I use the nifty VB FormatCurrency function which will format based on the OS's region setting. So, if in France you might get 123,45 where in the US you would get 123.45. To perform calculation on these amounts I use CDec() to convert to decimal.
My problem is that when I convert the Decimal to a String using toString() it formats according to the currently set region. I need to be able to always convert the decimal into a String representation for the US, i.e. with decimal points. I thought I would be able to do something similar to this: .toString("#0.00")
i'm a little stuck with a personal project, i'm interfacing a MiniBee usb output card to my pc and having a few code problems, i am trying to control outputs 1 to 8 which requires a decimal number that relates to the binary pattern of the ouputs if that makes sense i.e
1 = output 1 on 2 = output 2 on 3= output 1 and 2 on etc etc
So, i figured the easiest way to individually control outputs was to use public boolean vars Out1 to Out8 so i can use those anywhere in the code and use a form timer to trigger the updating of the output
So the bit im stuck on is i've done a test using 8 checkboxes to set Out 1-8 as true/false
format a decimal value to a string with a single digit after the comma/dot and leading spaces for values less than 100?For example, a decimal value of 12.3456 should be output as " 12.3" with single leading space. 10.011 would be " 10.0". 123.123 is "123.1" I'm looking for a solution, that works with standard/custom string formatting, i.e.
decimal value = 12.345456; Console.Write("{0:magic}", value); // 'magic' would be a fancy pattern.
how can i make hexa decimal string from my own text? [code] then it will generate hexa string (below is only sample, not true generated) 3F2504E0-4F89-11D3-9A0C-0305E82C3301...is it some algorithm or function in VB NET to generate HEXA?
I have a problem converting decimal number from label's string to decimal... (for example Label1.Text = "0.5"). It works fine on Vista, where I made my application, but it doesn't work on XP and 7. It converts from 0.5 to 5
VB Dim dec1 As Decimal dec1 = CDec(word1) * CDec(u1.Text) 'word1' is an integer. For example, if word1 is 100, on XP I get result 500.
I am struggling to get this to output calculations correctly. Have I properly made my conversions between decimal,string and so forth. Is that the only reason that a calculation would not produce the right result or is there another reason? I have negative total results for output when they should be positive.
Dim decAmount As Decimal Dim decInterestRate As Decimal Dim mdecFutureValue As Decimal