I am having trouble with the datetimepicker. I use this and I tried as many as I could but didn't get a proper result, this one is the closest, so atleast while debugging I can see it having the right value:
datePContBDay.Value = dsn.Tables(0).Rows(0)("PContDOB")
But all it shows is todays date, don't know why?
I have a database that has null date values in it. When I call the columns from the database with the null datetime values and display it in the datetimepicker text box using a dataset, theres always values in the datetimepicker text box. It sets everything that was in the database with null values to the current date. This is what i have..
DateOPStartedRevisionDateTimePicker.Text = ds.Tables(0).Rows(0).Item(13).ToString
I just cant figure out a way to get the datetimepicker text box to display nothing if the values are null in the database.
Does anyone know what is the best way to check has datetimepicker been clicked and value selected before saving and updating database. I am working on a database app and database field for "Date" does not allow null so in order for app to work properly i would like before saving to check if the date is selected and if not to create warning for user. I have created that for "Name" and other columns, but those are text boxes so I had no problem with that. I could change the database field for "Date" to allow null, but that the easyer way and not what I really want. If someone has solution for problem
View 4 RepliesI am using visual basic 2008 and I am trying to create a form.
[Code]...
I have a form with a DateTimePicker and want to convert the user selected date into ddmmyy and then display the result in a label on the form.
[Code]...
How can I get the datetimepicker value to have a 2 digit day EX. If it was November 6, 2009 the value is showing as 11/6/2009 but I need it to be 11/06/2009
I have a search that searches by date and Im using the datetimepicker. the date format in from my sql database is in MM/DD/YYYY not MM/D/YYYY So my results come up ok if the day is a 2 digit day normally (ex. 11/20/2009)but if its a single date (11/6/2009) I don't get any results because it is looking for 11/06/2009 I don't see how I can get the value of datetimepicker to be MM/DD/YYYY Even if i set the custom format to MM/dd/yyyy the value is showing up as MM/d/yyyy
I am working VB.NET 08 Access Database. I have Two "DateTimePicker" controls one is "StartDate" and one is "Enddate". Now I am selecting Startdate like May 1st OK. Now when I select Enddate control this calender shows only Equal or Greater than dates should be Enable. EndDate should be Always Greater than Equal Date. That's why when ever user selects the Enddate Before May 1st dates should be disable..
View 2 RepliesWasn't really sure what to name this thread or how to explain it. I have a form with a dateTimePicker control on, textbox for days, button and label, when the button is pressed I'd like the amount of days put into the textbox to be added to the value in the datetimpicker then the result being put into the label.
E.g. Select 26th November in the DTP, then put 6 into the textbox, press the button then have 2nd December come out in the label. I've tried a few things but all fails and just gives me back the original value in the DTP.
We have this custom DateTimePicker in our project where you can alter the BackColor and so on. But normally, when you click on the month of a DateTimePicker, it gets highlighted and you can change it with for example the arrow buttons on your keyboard or by typing a different number. Now the problem is that in our DateTimePicker, the highlighting doesn't happen anymore. When you click on for example month, you'll be able to change month but you don't see wether you selected month or something else.
This is the code we have (it's old code from way before I even started working here):
Public Class ucBaseDateTimePicker
Inherits System.Windows.Forms.DateTimePicker
' true, when no date shall be displayed (empty DateTimePicker)
[Code]....
I am trying to make a time difference calculator using the Datetimepicker, (code as below)But I would if it is posible like to show it as the 24 clock system, anybody able to help or point me in the right direction?
[Code]...
In my detail form I would like to diaplay datetimepicker field as blank in case when user open new record. Is it possible to display blank datetimepicker? How it to do?
View 2 Repliestried in many ways and I know that very soon will succeed. at least I am very resourceful showing that ...... Please help me correct this code. because the DataGridView throws I query the data are in the range of dates
Option Explicit On
Option Strict On
Imports System.Data
Imports System.Data.SqlClient
[code]....
I am trying to show the date that stored in sql2008 in vb2010 by using datetimepicker.
Here is my code:
Private Sub Load_Project(ByVal cJobNo As String, ByVal nFlag As Integer)
Dim lnComboboxIndex As Integer
Dim lcSQL As String
'nFlag => 0-Edit 1-Copy Record
[Code] .....
how would i go about creating an ownerdrawn dtp, with highlighted dates in the dropdown + also in the collapsed view when a highlighted date is selected? i'm guessing i'd have to inherit a dtp + then handle an event or 2. does anyone have any insight or experience with this?
View 2 RepliesI was wondering if someone could help me. I have a database and i want to select all records between 2 dates.I use two datetimepickers and would like my datagrid to show only records between dates selected.
[Code]...
I just been working with datetimepicker and I can't get it working if it is unchecked. When it is unchecked looks like it is not taking anything in. I can't load the value in it if it is unchecked which I need to have unchecked until the user ticks it by selecting the date.even if I am trying to trick it by doing this:
dtpCallback.Checked = True
If (Convert.IsDBNull(dsOrders.Tables(0).Rows(0)("callbackDate"))) Then
Else
[code]......
I would like to create ToolStripe on my DGV form with 2 DateTimePicker tools. And when user open form those tools will display by default date:
- first DateTimePicker will show date on 2 month early then current date;
- second DateTimePicker will show current date.
In ToolStrip of DGV form I have DateFromDateTimePicker and DateToDateTimePicker. I would lke to filter DVG by values of these DateTimePicker.
View 3 RepliesI need this for displaying in my crystal report here's my
cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'"
and nothing displays on my crystal report, I need the right quert for that...
Im trying to change or increment the month value of the datetimepicker using a command button. I tried to use the sample code from MSDN site but I was only able to increment once. I want to increment the value of the month everytime you click the command button. Do I need to use a loop statement? If so, how do I do that? I used this code below which can only increment or change the month value once but when you click the button again, no changes will be shown.
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'DateTimePicker2.Value = New DateTime(2001, 10, 20)
DateTimePicker2.Value = New DateTime(DateTimePicker2.Value.Year, DateTimePicker1.Value.Month + 1, DateTimePicker2.Value.Day)
End Sub
I've got a form with following controls: Two Datetimepickers Two Buttons One TextBox One ComboBox The idea is adding and subtracting dates using Datetimepicker contols... I found codes for doing Dates Calculation but is'nt quit correct;for example: if i want to add 21years from today the result will be: sat 30 Aug 1930 The Adding Codes on comand button: Private Sub BTNadd_Click(ByVal sender As System.Object, ByVal e As
[Code]...
If DateTimePicker1.Value.Year <= DateTimePicker2.Value.Year Then 'dtp2 = expiry date
If DateTimePicker1.Value.Month <= DateTimePicker2.Value.Month Then
MsgBox("Expiry Date Correct!")
Else
MsgBox("Expiry Date incorrect!")
End If
End If
How would I get it to check the date? Datetimepicker1 is the current date, while Datetimepicker2 is the expiry date.
How can I get this to happen? I googled around and it seems setting the CUSTOM FORMAT to " " when the field is null will work but not for a BOUND datetimepicker.
View 12 RepliesI have a datetime picker which format is yyyy-MM(2011-09) and I need to choose all the records of a particular month, I use this like query but doesn't display anything
[Code]...
I got some problems with displaying a treeview in vb2008. I want to display a company departments and got two access records: one for the top department and one for the sub-departments. The code looks like this:
TreeView1.Nodes.Clear()
ProgressBar1.Maximum = rsDepartment.RecordCount
ProgressBar1.Minimum = 0
[code]....
I'm trying to display a image by treeview item checkbox with the code below.
Dim itm As ListViewItem
itm = New ListViewItem("Test")
itm.ImageIndex = 0
ListView1.Items.Add(itm)
I have database like this [URL]but I will need to display only certain columns, which will depend on which user has logged in. Each user will have a unique ID, and so I want that that datagridview would only display the rows, which are for him, well have his ID, so that he couldn't see other users information, but only the one associated with him.I also need to output that user's forename and surename into label, it is stored in the database.
View 2 RepliesI've got all the code figured out to make a picture box appear with a gradient inside of it. My problem is that the gradient doesn't appear in the picture box when the form loads, paints, or when the picture box is painted. I can only make the gradient appear if i click the picture box after the form appears.
Dim xFormTopColour As Color = Color.Black
Dim xFormBottomColour As Color = Color.DarkOrchid
Private Sub frmTestGradientBars3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call GradientPictureBox(xFormTopColour, xFormBottomColour, picSample)
[code]....
why is the notifyicon not working at all?i added it to the form filled the text and title and just to see it i put the following in the Form1_Load
NotifyIcon1.ShowBalloonTip(100000)
NotifyIcon1.Visible = True
i run it and nothing, no balloon ... why? what am i missing? my OS is Windows XP Pro SP3s...
How do i get this code to display my image using a database this is my code.
code
Private Sub Details()
Dim oleDBC As New OleDbCommand
Dim OLEDBDR As OleDbDataReader
con.Open()
[Code]...
Unable to cast object of type 'System.String' to type 'System.Drawing.Image'.
but if i use lblName.Text = (OLEDBDR.Item(1)) it will display the path to the image.?