How can I get the value of the year, month and/or day from the DateTimePicker if I'm trying to compute for the age? I've tried
Dim x As String = ""
x = Date.FromOADate(Val(DateTimePicker1.ToString))
MsgBox(x)
But it only gave me 12:00 AM.
and
DateDiff(DateInterval.Year, DateTimePicker1, Now.Date)
This time it said datetimepicker1 cannot be converted to date.
I am working on program in vb2008 and facing problem in making a PAYROLL SYSTEM.. well, I've done some of its parts and functions but the main part of it is still unsolved -- the computation of tax!! our boss want that when you input a basic monthly salary, the semisalary will be computed.. minus the sss, pag-ibig and philhealth.. then the tax will be computed but also depending on the number of dependents the employee have...
Code:
Private Sub semiSalary_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles semiSalary.Click
If basicSalary.Text = "" Then
MsgBox("Please enter a salary.", MsgBoxStyle.Exclamation, "Invalid")
Else
Dim result2 As Double
[Code] .....
What I've done is that I'm trying to display those values when the the textbox corresponding to it was clicked. We get each value in our database stored on textboxes from the formtables of sss & philhealth.
Attached image(s)
How to display computation process on VB 2008 form?
View 3 Replies[code]...
i would like to have a computation on the table (in sql) im creating en example computation:
Dim FiKg As Integer = ((txtFeNum.Text * txtFiFe.Text + txtMaNum.Text * txtFiMa.Text) * 7 / 1000)
Dim FemaleNum As String = txtFeNum.Text
Dim MaleNum As String = txtMaNum.Text
[code]...
i'm still developing my project bout evaluation of employees. I'm using the code below,I want to multiply the values of the two specific row/column inside my datatable and then insert the product in the KPIGRDEQUI field in the KWEEKDTL table.Is it possible to be done?
[Code]...
for example i have this table
x ! y ! z ! Result !
54 ! 12 ! 5 ! !
54 came from --> Textbox1.Text
12 came from --> Textbox2.Text
5 came from --> Textbox3.Text
and i will display the result at row rowResult
[Code]...
im having a simple computation problem here....
[Code]....
I have a 2 DateTimePicker on my design.1 DateTimePicker for Due Date and another 1 DateTimePicker for Date Returned. Now I would like to automatically compute for penalty which is 24 per day just clicking on the Date Returned's DateTimePicker.For example,A student borrowed a book today and the librarian assigned the due date when to return it.
Take note, the date today is 03/23/2012.and the librarian assigned a due date into 03/25/2012 (the exact date when the student should return it).When the student attempts to return the book at 03/28/2012, and the librarian clicks on the Date Returned's DateTimePicker, the penalty will show as 72 and so on and so for.So I am asking on the codes or tips on how should i do it to make this things work?
I recently made a change to the code within a loop in my code, and now when I run the code through Visual Studio 2010 Express, the loop runs about 10x slower than the previous loop.I did not make any significant changes (to my knowledge) to the code within the loop.I made the change so that the loop could handle various conditions I imposed in another section of the code.I know that it is this loop that is slowing everything down because I report the loop progress on my form.[code]I feel like my changed code should run better, but it doesn't.I know that my code is not written very efficiently (and feel free to comment on ways to improve it), but my main concern is the significant increase in computation time that resulted from my changes.The loop above is the main block of code within the Sub, which is run via a thread.In my tests, it is the only thread running at that time.Everything works, and the computation yields the correct result, but takes 10x longer than previously. Additionally, the number of iterations does not increase.So the new code isn't iterating excessively, it is simply taking much longer to compute within each iteration.
View 19 RepliesI have been trying to compute the checksum for a line of hex code. This is to create a hex file which will be loaded onto an embedded micro.Some of you guys may not know how this is done so very briefly:
a line of hex bytes:
: 10 01 00 00 21 46 01 36 01 21 47 01 36 00 7E FE 09 D2 19 01 40
The underlined bytes are taken and summed. (in this case the decimal 960). and the bold is the checksum Only the 8LSB (or single least significant byte) is needed to compute the checksum... which in this case, 960 = 03C0 in hex, so only C0 is needed.Two's complement is then taken:
step 1) logical not of C0 which is
step 2) add one (integer)
BIN...........DEC...HEX
[code]....
So here is the code I have been using: (quick mention that in the string passed, the hex bytes are all grouped together, there are no space characters)
Public Sub CreateLine(ByVal Data As String)
'Dim BDataArray(DataLength) As Byte
Dim IDataArray(Data.Length) As Integer
[code]....
where i get into trouble is where i commented 'i get into trouble'. My code works, but it's rather crude Now, in that line i first convert the hex value (string) "SChecksum" into an integer. I want to NOT this, so I get my step 2 from my explanation. However, the results appears to be a signed logical NOT. which gives me the wrong answer. My hashed togther version simply subtracts 256 before the not, in order to give me the correct answer.
Basically, I would love for someone to chime in and point out the flaws in my function, and push me towards figuring out the 'proper' way of doing this. Also I can't quite wrap my head around what would happen in the case a string were passed to my function that is over 16 bits, but I imagine I would have to subtract a larger value than 256, before doing the NOT in this case?(whilst we're on the subject of functions, I've used a 'sub', in which case should I used a sub, and which case should I use a function?).
how can i show for each datetimepicker value
a datatable with data
that means that when i select a value in a datetimepicker
the data of a datatable also change
what is the code?
My form has a subform with a few fields including a datetimepicker.When I select other items in the subform they save to that particular record within my DB no problem, but when I use the datetimepicker it does not seem to bind.
View 1 RepliesI was wondering what was the proper way to create a If statement for if the datetimepicker date is greater than 2 weeks from the current date.
I was thinking something along the lines of
If (datetimepicker.value > DateTimeInterval.Day(14))
but I am not sure the correct way.
From the WINDOWS Date & Time settings FORM is this accessible as an alternative
View 1 RepliesI have seen application which click a button and a calander pops up from that we can select a date and time which intern goes to a textbox. When i burows through net i found that we can make use of datetimepicker..Is there any way to use datetimepicker in web application can any one tell me how to use it.
View 4 Replieshow to bound datetimepicker to dgv
View 3 RepliesI want to save the time in the format hh:mm:ss from the DateTimePicker to MySQL database, How to format the DateTimePicker into hh:mm:ss only without date and What is the appropriate type to save time in mysql?
View 1 RepliesI want to get the date value from datetime.now till the selected value from datetimepicker. Ex.
date Today is 08/09/2011
selected date from datetimepicker is 02/08/2012
I want to show the dates between the 2 dates mentioned. For example I want to show the value of
09/09/2011-Firstmonth
10/09/2011-SecondMonth
11/09/2011-thirdMonth
12/09/2011-FourthMonth
01/09/2012-FifthMonth
Until it reached the selected value from datetimpicker.
I have a date time picker where the dates available to be selected on it is affected by the choice made in a combo box above it. If the user selects "Express Air" in the combo box for example, the minimum date in the date time picker must be either Today or Tomorrow. Nothing before, nothing after. How do I go about this? I tried:
Private Sub DateTimeExpressAir()
If cmbShipmentMethod.Text = "Express Air" Then
DateTimePicker1.MinDate = DateTime.Today
End If
End Sub
If also possible how do I set the MAX date to like, tomorrow, or 6 days after today, etc? DateTimePicker1.MaxDate = ??
But no success. I am using Visual Basic 2008.
How to allow the user to select the date from the DateTimePicker and store that selected date ,month and year in the database table?
View 3 RepliesI need to have my date into a label.text = 03/10/2011I'm able to do that on my datetimepicker1 but when I try to pass to the text it brings in short date = 3/10/2011 I need the zeros.
'format the datetimepicker value
Me.DateTimePicker1.CustomFormat = "MM/dd/yyyy"
Me.DateTimePicker1.Format = DateTimePickerFormat.Custom
[code].....
having a bit of bother with the DateTimePicker control in .NET 3.5. I created a very simple form. It consists of just one DateTimePicker control called "DateTimePicker1". In the Load event of the form, I placed the following
DateTimePicker1.MinDate = "01/02/2010"
DateTimePicker1.MaxDate = "07/02/2010"
Running: Win7Pro, VS2010Pro
Try this:
New project (WindowsApplication1), new form (Form1) with one DateTimePicker (DateTimePicker1), one TextBox (TextBox1) and one Button (Button1).
The DateTimePicker's properties changed are: ShowCheckBox: True, Checked: False
The code on the form is:
Public Class Form1
Public Sub New()
' This call is required by the designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
Me.DateTimePicker1.Value = DateSerial(2011, 1, 31)
[Code] .....
I want to get date from database to my datetimepicker, but I got problem
here is my code.
Dim sStatement As String
sStatement = "SELECT Transactions.RentDate " & _
"FROM Transactions INNER JOIN TransactionsDetails ON Transactions.[TransactionID]
[Code]...
No data exists for the row/column. But I have many data... and the second time i click the button
The connection was not closed. The connection's current state is open.
i have 2 datetimepicker and i need to get the difference of the two dates in two different way
1- Suppose that i have choosed 15/12/2009 and 20/12/2009 i need the result to be as below in order to record them in my database,
15/12/2009
16/12/2009
17/12/2009
18/12/2009
19/12/2009
20/12/2009
2- i need the different between 2 datetimepicker in days
i have a simple VB.NET application with a datetimepicker-control. Now i want that the datetimepicker always shows this format 01.07.2009, always the first day of the month
View 8 RepliesI have a Date Time Picker control and need to get it to display as H:mm in a text box as a declaration so that I can transfer to a database, I do not want the seconds. I have tried using :ToString("H:mm") but it just zero's off the seconds ie..."13:45:00".
View 3 RepliesI'm having a little problem trying to figure out how to get only the time from a datetimepicker.I've set up a datetimepicker to only allow user selection of time by setting Format to Time and ShowUpDown to True.However, when I store the value of the datetimepicker to a variable, it returns a date as well.[code]However, this seems like a really inelegant solution and I can't figure out how to get an AM/PM behind that.I feel like I'm missing some really simple solution that I'm just not seeing! There HAS to be a way to get just the time!
View 3 Replieshow can i set my datetimepicker borderstyle = none in vb2010? i found something on google that uses getwindowlong + setwindowlong but it doesn't seem to work in vb2010.
View 5 RepliesI have a Nullable DateTimePicker but it lacks a vital property, that is to be able to change its ForeColor, anyone who has some suggestion on how can this be done? Or perhaps a free nullable DateTimePicker out there that supports changing of backcolor and forecolor?This is C# but it should not be different with .Net, and I prefer posting it here since there is more traffic here over the C# section.
using System;
using System.Collections.Generic;
using System.ComponentModel;[code].....
