I have an Excel application, that is converting values of type "double" from one to another. I have the same data as Excel in SQL 2005.I have procedure, that is making all calculation apart rounding. In Excel I have specific format result of this calculation - "_-* # ##0,00_-;-* # ##0,00_-;_-* "-"??_-;_-@_-".How to implement it in VB.NET or C#?
View 2 RepliesI'm trying to delete the 2 last characters of a string if they are "||". This is my
Dim MyReader As Microsoft.VisualBasic.FileIO.TextFieldParser
MyReader = My.Computer.FileSystem.OpenTextFieldParser(playlist)
Dim TextFields As String() = MyReader.ReadFields()
Dim last As String = TextFields.Last
If last.Substring(last - 2) = "||" Then
last.Remove(last - 2)
End If
But it gave me the following error on the highlighted line:
"The converting from the string to the type Double is not valid."
I have a program that calculates commission, but if the commission is nothing then I do not want it to show a zero commission. I want a message box to show a message that there is no commission earned.
View 1 RepliesIs there such a thing as a type similar to a point, but contains a pair of decimals, or a pair of doubles, rather than integers? I searched the forums and google with no luck. I can't believe this has never come up before, I must have been using the wrong search terms.
View 4 RepliesWhenever I store values to a double-type variable, and ask to display it on the screen, there seems to always be a discrepancy, for example, I entered 7.416 to a textbox and assigned it to a double. When i ask for it to be displayed, it used to be that the 7.416 is returned to me. But just a few days ago, when I debugged my program again, it returns numbers like 7.4159987.......[code]....
View 7 RepliesWhen i use VB6 i get the following outputs
961.605 * 100 = 96161
936.495 * 100 = 93650
929.295 * 100 = 92929
NOW..... When i do the above in vb.net 2005 i get the following
961.605 * 100 = 96160
936.495 * 100 = 93650
929.295 * 100 = 92930
How can i get the same output as the VB results. And i have tired it ! Type conversions, math functions, everything i can think of to get the same VB6 output !
When i use VB6 i get the following outputs
[Code]...
I want to use explicit conversion (CType function in VB.NET) to convert the variable d from double type to integer type and store the result as 132.
Imports System.Console
Module Module1
Sub Main()
[CODE]...
This is my code. But Visual Basic tells me an error: Error1Type 'i' is not defined.C:\Users\mihaispr\Desktop\Conversie explicita\Conversie explicita\Module1.vb1922Conversie explicita
I updated an MS Access file with data and it showed the data is there. When I tried to retrieve I get this message " Conversion from type DBNULL to type Double is not valid" Below is the code to retrieve.
[Code]...
i am converting a string to double?i would like to know in advanced whether it would case an error to convert a string to a double. for example if i try to convert "hello" to a double, it would give me an error. is there a way for me to know ahead of time whether converting something will cause an error?
View 2 RepliesThe message does not appear if a number is not entered - why?
Dim
IAL As Double
Dim inputIAL As Double
[Code].....
I was trying to convert from Double to String and everything working fine. But when I tried some bigger number with fractions in it. I got the number but rounded. I tried something like that:
Dim dd As Double = 1235212435.3453636
Dim str As String = dd
MsgBox(str)
But what I got is 1235212435.34536 instead of 1235212435.3453636
Public Class frmWaiter
Private Sub btnCalculate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCalculate.Click
'Bill Amount Input Box
Dim txtBillAmount As String
[code]....
I am storing a value (represented as a string originally) like this -2345678901234.12345678912 - in a double variable. After storing, it is represented in an exponential format (with an e). How do i convert this exponential representation to the original(string) representation?
[Code]...
I want to convert an array of numbers to a string with a colon imbetween splitting it. I tried:
StringA = Join(Array(), ":")
I get the error: 'Number of indices is less than the number of dimensions of the indexed array.'I seem to get this error alot in my programming but don't exactly know what causes it. Even if I can fix this error I heard that Join only works for string arrays so this wouldn't work anyway.
I'm new to VB, I'm now want to know how to convert received string to double.I'm receiving string as 420.8 280.9 140.2 like this from serial port.. and transferred it into textbox..I'm using following code to split string and to convert to double
Dim ReceivedText As String
ReceivedText = txtReceived.Text
Dim str_RY_1U, str_RY_1V, str_RY_1W As String
[code]....
i have a column in datagridview composed of numeric as well as aphanumeric. What i want is when the user sorts the column, it will be sorted according to its number value, 1,2,3,4,5,6,7,8,9,10. However it my current module, the program sorts basing the first digit of the column. like 1,10,11,12,2,3,30,31.
i was thinking of converting the type to number so that it will be arrange properly, is this possible in the datagridview to covert type? because i saw only a readonly property celltype? i have also tried casting it in the sql query itself to INT but it did not work.
The only post I can find on this matter is one that coverts the double to a decimal before converting it into a string. However the numbers I'm using are far larger than what a decimal can store.
Example: 1/(16^10)
So how can I convert the solution to the problem above. Which equals 0.00000000000090949470177292824, to a string value that is exactly as it's shown?
Cause when I convert this to a decimal I still end up with a string in scientific notation..
Dim Button As ToolStripButton = New ToolStripButton
Button.image = Icon.ExtractAssociatedIcon(exefile)
I try that code, and it just throws me the error that type Icon cannot be converted to Image. So how do i get around this? And does "ExtractAssociatedIcon(exefile)" work on exe files? Admittedly i don't really know what im doing
Dim Button As ToolStripButton = New ToolStripButtonButton.image = Icon.ExtractAssociatedIcon(exefile)I try that code, and it just throws me the error that type Icon cannot be converted to Image.So how do i get around this? And does "ExtractAssociatedIcon(exefile)" work on exe files?
View 3 RepliesI am using a VB.NET(VS2010) to read data from serial port. I have 8-bit data to collect through rs232. This data is represented numbers. What reading method should I use and how to convert it to double format?
View 3 RepliesI'm new to VB, I'm now want to know how to convert received string to double. I'm receiving string like this 420.8 280.9 140.2 from serial port.. and transferred it into textbox.. I'm using following code to split string and to convert to double
[Code]...
how to convert received string to double.
I'm receiving string as 420.8 280.9 140.2 like this from serial port.. and transferred it into textbox..
I'm using following code to split string and to convert to double
Dim ReceivedText As String
ReceivedText = txtReceived.Text
Dim str_RY_1U, str_RY_1V, str_RY_1W As String
[Code]...
For calculating percentage RY_R is calculating fine.. But when it comes to RY_Y it showing error "string not in a correct format..."
I've been just making random programs trying to get the hang of the new language this time I was making a leap frog game where it switches back and forth beetween frogs every time a button is pressed. It also checks if the frog can land in the text box above the button pressed, if there is another frog there a message box will pop up saying sorry space is filled other wise the frog should land there.
[code]...
The error message says "Conversion from string "frog1" to type 'Double' is not valid." I understand what a double is but I've tried And If and that causes a bunch of errors.My Question is whats wrong with this cod and how can I make a double if statement???PS I did try to make an array to shorten this but thats in a different fourm will post URL later
I need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesI created an application in vb.net 2005. It works fine on my machine. I tested several different test machines and all were working fine. As for the client, it's generating an error. My application reads from an excel sheet and imports the values to an oracle database. the error being generated is: "conversion from type string to type double is not valid". Why is it generating only on the client's computer and not mine?
View 13 Replieswhen a user inputs a value into a text box, i am searching that value in my dataset.although the number that i entered is in my dataset, i am getting this excemption.
View 3 Replieshere is a very important matter to be corrected as soon as possible. generally,type double can display an answer correct to more than 20 decimal places. yes,it works fine until here except for exponential system. whenever i try to find a decimal raised to the power of a proper fraction, i get a correct answer but only upto 13 decimal places. that is not fair at all! it is important to get as high precision as possible. consider this example:-
[code...]
i want that number of correct decimal places or approximation,which a windows 7 calculator has. i believe that this is someway easy to get rid of. please support.it is important for programs like calculator,worksheets,databases,etc.
Here is an issue that i am facing - VB6
[Code]....
The value of d3 is not coming to 301006308001004.5 but it is getting rounded off. Is there a way to fix this. When I use currency data type, the issue looks solved. However currency cannot hold a larger decimal number. the value of d2 can have more decimal value like 0.343324532553 .
integer 51 is the result of Math.Round(mX ) where mX = 50.8026755852843how do I ensure that an integer value is created but doesn't round up but rather rounds down.the application is a location coordinate system begin displayed and if the mouse pointer hovers over a point just slightly to the right of the vertical x grid line as determined by a MouseEventArg, I want the resultant integer value to be 50 if the Mouse
View 5 Replies