I want to store a decimal value, but there is the possibbility that no value has been entered. So i would like the decimal value to store a nothing instead of a 0D if no value has be entered is this possible?
View 2 RepliesI'm traying to write some query but I don't know much about DataBase. I have a variable that store the value entered on a textbox and I want to look value in the DataBase and then show the record on the DataGrid. I'm traying to build some query but I think I'm way off.
Here is my query:
SELECT Name, Record, Plan, [Numero de contrato]
FROM [Record de Pacientes]
WHERE (Name LIKE '%Variable%')
Is there a way to make NumericUpDown control hide decimal places but still can show if i entered manually?For example, i want to set NumericUpDown DecimalPlaces to 0 but when i enter something like 6.52, it remains 6.52 and not rounded to 7.
View 2 Repliesmy application has a data table, one of the column set as decimal type to store number, data is read from a text file and store into the data table, then display in a datagridview, I found when that number is only 1 digit, that cell displays nothing (I think no number is being store in that cell), if I type a 1 digit number into that cell is fine. for example,
1.1 [ok]
12 [ok]
0.15 [ok]
4 [not display]
9 [not display]
-23.8 [ok]
so which data type I should use on this column, in order to display all this possible numbers
What is the cleanest, most readable way to String.Format a decimal with the following criteria
start with a sign symbol (+ or -)
a fixed number of fraction digits
no decimal separator
right aligned
pre-padded with "0"'s
I am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
I am creating a Calender application using the monthly calender control.I am trying to implement a search for the calendar so a date can be entered into a text box which intern moves the calender to show the date entered. I have been try to figure this out with no luck, is it even possible to do?
View 2 Replieshow do you convert a decimal ( decimal place holder = dot) to a decimal (decimal place holder =comma)?
View 6 RepliesOdbcDataReader in showing decimal fields Decimal separator disappear with DB2 dsn
View 3 RepliesAfter converting all degrees-->decimal, and decimal-->hours, how can i use Tan, Cos and Sin formula in vb.net? I want the user must enter an input (which it is a coordinat-->i already convert the degrees-->decimal value as suggested by stanav and paul.
The questions like this (i only calculate on paper but dont know how to implement in code):
Input user need to enter:
-latitude local (e.g. 1.4875)
-longitude local (e.g. 103.3883333)
[CODE]...
My user requests to change the . on the numpad to a when entering text in a multiline textbox.So I was thinking about the KeyDown event.To determine if the numpad . was pressed I can do something like this [code]But now how do I change the returned charachter as a , ? All e.Key... properties are ReadOnly. The KeyPress events let me change this by providing e.KeyChar, but in that event I can't check for the numpad .
View 2 RepliesHow would I go about rounding up decimal numbers to the nearest 2 decimal places? For example $7.0000032 would be $7.01 In theory, VB would make it $7.00 but if it is > $7.00, I want it to reflect that to the nearest penny... so $3.0000001 would be $3.01
View 5 RepliesIf I have the code:Dim x as Decimal = 100.0m
Is it casting from a double to a decimal implicitly. How would I do this explicitly in vb.net?
1) One Decimal Varibale stores a decimal value
2) The value must be converted in string ( some time the comma is used as decimalplaceholder some time the dot)
3) the user modifies the value
4) i need to riconvert the string back in decimal
how can i do this
so:
Variable 123.34D ----> textBox 123,34 or 123.34 -----> variable 123.34D
One number is represented with four hex values.First two hex parts are my "whole number" part, third and fouth hex numbers are my "decimal" part. I just wanted to store my complete number (whole and decimal) in an excel table.My problem is following when I am storing whole part and decimal part of my number separately, then it works fine am getting f.e. 3017 and 0,9445123 in my excel table, but when I am concatenate them, then I am getting following expression in my excel table f.e. 30,179,445,123 but I want 3017,9445123.
rx_str_buf(str_cnt) = CStr(Convert.ToInt64((Hex(rx_str_buf(Factor + 7)) & Hex(rx_str_buf(Factor + 8))), 16) +
(Convert.ToInt64((Hex(rx_str_buf(Factor + 9)) & Hex(rx_str_buf(Factor + 10))), 16) / 65536))
[code].....
Is there a way in VB .NET to have a decimal variable with 40 decimal places?
View 3 RepliesMaybe this is just a really basic question that everyone knows the answer to, and is why I couldn't find the answer. What I want to do is pretty simple. I want to declare a custom type that's just like a Single, except when you access the value, you get the value rounded to the second or third decimal place. Something like this:
Dim MyNumer as TwoDecimalNumber
MyNumer = 1.124
Msgbox(MyNumber) 'This would pop up a box showing "1.12"
[Code]....
i know that integer is a variable to store whole numbers and that a string is a varialbe used to store any text, but what variable type would you use to store a number that has decimals?
View 7 RepliesProblem: Using the sub routing below, when adding a value to another value the results eventually change from 2-decimal places to multiple decimal places.Basically, the amount stored should always only be 2 decimal places, because the values passed in are always 2 decimal places. Output from calling the sub routine multiple times.
Running total = 329430.75
New Withheld Amount = 710.79
Running total = 330141.54
[code]....
As a workaround, I have a new routine that uses a custom round function to properly store only 2 decimal places - as the VB round function does not perform the type of rounding desired.I understand that we are removing the value from the dictionary and adding it back..
format number to hower many number on left of decimal and 1 decimal without rounding
View 2 Replies"Create a class called Invoice that a hardware store might use to represent an invoice for an item sold at the store. An Invoice should include four pieces of information as instance variables--a part number (type String), a part description (type String), a quantity of the item being purchased (type Integer) and a price per item (Type Integer). Your class should have a constructor that initialize for each of the four instance variables. Provide a property for each instance variable. If the quantity is not positive it should be set to zero. If the price per item is not positive it should be set to zero."
I attached the code I have. obj is underlined and says "Argument not specified for parameter 'Invoice4' of the 'Public Sub New (Invoice1 As Object, Invoice2 As Object, Invoice3 As Object, Invoice4 As Object)' and so the program won't run. What am I doing wrong?
Public Class Form1
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim obj1 As New Invoice(Val(TextBox1.Text))
TextBox1.Text &= obj1.Invoice1 & vbNewLine
TextBox1.Text &= obj1.Invoice2 & vbNewLine
TextBox1.Text &= obj1.Invoice3 & vbNewLine
TextBox1.Text &= obj1.Invoice4 & vbNewLine
[CODE]...
I have this code
If ValueTXT.Text.Contains(".") = True Then
Dim r As String = ValueTXT.Text
Dim mv As Integer = ValueTXT.Text.Length - 3
r.Substring(1, mv)
ValueTXT.Text = r
End If
I want to check if there is a 5.00 entered into my value box, if there is i want to remove the .00
I am trying to perform a task while the word count of a richtextbox is less than a user entered value, but the word count keeps coming out miles out, here is what I have:
Dim count As Integer = 0
RichTextBox1.Text = ""
Do While count < NumericUpDown1.Value
[code]....
How can I ensure that a user enters data in one text box before being allowed to move on to the next text box Example I have four text boxes the user can enter a grade in. I want to lock the other three box until the user has entered a number in text box 1. Once a valid number has been entered in text box 1, that releases or enables text box 2. Once a valid number has been entered in text box 2, that releases or enables text box 3. And once a valid number is entered in text box 3, that releases or enables text box 4.
View 5 RepliesIm writing a program that is supposed to display a name, which is one array, and then show the phone number to that persons name, which is another array. What happens is when you enter the name, without any capital letters, it will show the number, then show the exception messagebox that says you have no friends with that name. When you enter a capital for the first letter, it will show the number, then it will show the messagebox with the name and phone number. My issue is 2 things,
1.) I need to have the exception messagebox come up only when a name is not entered, and
2.) I need to have a partial code snippet that will display the correct information even when a full name is not entered. [code]
I have here a code that will get the address entered. We want a dialog box to pop out with the city entered. Here is the code.
Code:
' displays the city name
Const Prompt As String = "Please enter a city name followed by a comma, a space, and a state name."
address As String
[code].....
How to get if the date entered is in the range?
Ex. the month of April, the number of days is only 1 to 30. What if the user will enter the date range of 4/1/2011 to 4/31/2011 in the mask textbox? I am using Mask textbox because datetimepicker will not accept empty value and it cannot be empty either.
I'm asking this because I encountered an error when querying in MS SQL SERVER 2005. It says "The conversion of char data type to smalldatetime data type resulted to in an out-of-range smalldatetime value." I thought it was the casting or conversion problem. I've observed the SQL when transacting and I found no difference with my code.
So then, I just figured it out that my date exceeded the number of days of the April month.
I am trying to get the last entry from my database based off the date entered. The sql is not working exactly as I want it. Here is my sql SELECT TOP 1 * FROM BILLS_HITS ORDER BY DATETIMEADD DESC.Can anyone see anything wrong with it? The sql returns a record with the date - "6/6/2012 7:10:11 AM" and not one that is for 6/10/2012.
View 1 RepliesI have created a program that solves the right-angled triangle by just needing to input two known quantities. I have adapted this code from some I found on another website, it never actually worked, so I spent two weeks figuring out how to get it to work. I have finally succeeded, what I would like to do is display a message box if the user has not entered the required two inputs and presses the 'Calculate' button (see image). I just want it to say "At least two known quantities are required".I have some code that clears all the text boxes so you can enter new data, but I have tried countless times to find a way of coding so the message box appears.
[code]...
I have a few instances of a user control that has just a TextBox to search for items. The cursor is in one uc TextBox but the text I type appears in another uc TextBox. How can this be possible. Notice the cursor in model number, but the text is in upc.
Code:
Private Sub TxtScan_KeyDown(ByVal sender As Object, ByVal e As KeyEventArgs) Handles TxtScan.KeyDown
'When typing in the model number uc I see that the sender
'is the txtbox is the one in the UPC user control.
End Sub