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 .
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 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 !
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 RepliesWhen i use VB6 i get the following outputs
[Code]...
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 RepliesI'm using the Double data type in a subroutine and it's giving inaccurate results. Basically I've got:
Dim Temp as Double
Dim A,B as Single
Dim C as Byte
Temp=A*B/C
When A=996 B=4 and C=1.6 Temp should be 2490 but that's not the case. I get something like 2489.9999628961091. This later screws up another calculation that's based on getting the value and remainder.Whatever the case I set the Temp variable to Single and it works. What I want to know is WHY does this happen? I'm a bit confused.
How do you validate input when you are dealing with doubles. I have successfully gotten the message box to pop up when the user enters a number in a text field, but what if I have a text box that requests a number from the user and they enter text? This is the code, the even for btnDisplayFull works fine, but not btnDisplayRqst: [code]
View 2 RepliesOk, I'm half convinced that this is such a simple question that no one has ever needed to ask it in the history of google.I have a double datatype, which contains a currency value. This is returned by an API, so I can't just change it to decimal.The variable gets populated with this: 5.37979542325911E-315, which I took to mean that the current balance was $5.3797. This is incorrect!
So my question to you guys is: How do I convert a double to a data type I can use for currency?
Note: Cdec() and other casting to decimals hasn't workd. It's set the decimal to 0D.
I am using two textBox's. The first to enter the data. The second to convert to answer the program complies with no error, the debugger cannot convert data type from string to double.
[Code]....
why does the program not convert the textbox txtFahrenheit from string to double?
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 am using Combobox in data grid view as one of my column type.I am populating this combobox from table in DB.
Now, I want to do is that I can be able to add text in that combobox cell and on clicking submit button on form, this text should get added to table in db.
When i load the form again, again in that combox cell it should display this text along with previous text . means, two items will now get displayed.
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 creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 Repliesi want to know that how can we add two cells of a datagrid view.I have 5 cells, quantity,rate,discount,tax and Total amount.I want to show the total amount in "Total Amount" cell.
View 3 RepliesI have a vb.net 2010 form with 22 data bound controls from two tables held in a dataset which is navigated by a bindingnavigator. This successfully adds deletes and updates. However what I need is when adding a new record I need some of the fields to be pre filled out. More specifically I have points balance fields etc which could be any value but will normally be 0 on a new customer so I want to initialize them to 0 when adding new records.
View 1 RepliesI'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
For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
I 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.
I'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
I'm having an issue with 'access levels' The database is connected and my user levels are set up, Admin and User, I'm trying to set up so when you log in it checks if the username falls under an admin in the database. but I seem to be getting this Conversion from string "Admin" to type 'Double' is not valid error, [code]
View 5 RepliesI have this program i have to do for my Intro class. The assignment is to have the user enter a pay code(A,B or C) and the amount of hours worked. If the hours is more than 40hrs, they will receive time 1/2. And it must also calculate a 22% Tax.I was getting this error: Conversion from string to type 'double' is not valid. But some how i eliminated it.[code]
View 1 Repliesi always got error every time i run this program . here's the code.
'declaring variables
Const DEPOSIT As Double = 30
Dim dbltotal As Double
[Code]....
I am trying to update MS-Access database where one field is boolean and updating a string. I am getting a error message "Conversion from string "Update Claims set appointed=" to type double is not valid".
View 1 RepliesI'm getting this run time error using VB 2008 Express:
"Conversion from string "" to type 'Double' is not valid."
Below is my coding
If cmbxitem.Text = "Brownish" Then
TextBox2.Text = 37
ElseIf cmbxitem.Text = "White Feathers" Then
TextBox2.Text = 30
'ElseIf cmbxitem.Text = "B/Wchicken" Then
'TextBox2.Text = 15
[Code] .....
Imports System.Math
Public
Class Form1
'Declaration
Public
NotInheritable
Class Convert
[Code] .....
The error I am getting is: Error1Value of type 'Double' cannot be converted to 'System.Windows.Forms.DataGridViewTextBoxColumn'.C:\Users\Finley & Angelique\Desktop\Visual studio 2008\Mortgage Calculator CR 17\Mortgage Calcultor CR17\Form1.vb8922Mortgage Calcultor CR17
Public Class MortgageCaluclator17
'Write the program in VB.Net (not Web based) and have it accept user input of the amount, term and interest rate.
'Display the mortgage payment amount. Then, list the loan balance and interest paid for each payment over the term
[CODE]...........
If I remove the datagridview code the 1st part of the program runs fine and works well, it is when I add in the datagridview that the error occers.
I have code that loops through a string array to add words one at a time to a line of limited length. I am trying to fit a phrase on up to four lines, centering the words on each line. My code appears to add the first word but on the 2nd word I get a "conversion from string "IS" to type 'Double' is not valid" error.
Here is my code so far:
varResult = Split(strPhrase)
intWordCnt = UBound(varResult) 'count words in phrase
'make words fit on one line
[Code]....
The phrase in strPhrase is "GOD IS LOVE"
I don't understand why I am getting this error when I didn't on the first loop through the code and it Put the word "GOD" into the line.
