I have a field in my database that holds dates as strings in this format: dd/MM/yyyy Now I want to load then into a var as dates vb.net Dim dte as date I am having problems with the format. Vb doesn't recognize my date format as a date when I use this for expample:
vb.net
Dim strDate as string = "22/05/2010"
Dim dte as date
dte = CDate(strDate)
I am doing a comparison of the date in my db and the date in my datetimepicker.I am using the following
While reader.Read()
Me.dtpGeboorteDatum.Text <> reader("GeboorteDatum").ToString Then
The value of me.dtpGeboortedatum.text is "1-1-1900 0:00:00"
[code]....
How can I get both dates the same format so I can do the comparison?
I would like to compare two dates in this format dd mmm yyyy, compare validators wont work because of the format and custom validator is server side validation. I would like to have a clinet side validation.
View 2 RepliesMy regional settings are UK standard Windows XP. When I ecexuted FileSystemObject.DateCreated I get #1/25/2010 1:57:36 PM# I would expect 25/1/2010 13:57:36. Can anyone explain what is going wrong?
View 6 RepliesI am trying to create a textbox that only allows dates in like mm/dd/yyyy format. So if a user types in a date like 2010/11/02, an error would happen. But if they type it in this format 01/02/2010, then it works fine. Is this possible?
View 2 RepliesDoes anyone have a regurlar expression available which only accepts dates in the format dd/mm/yy but also has strict checking to make sure that the date is valid, including leap year support?
I am coding in vb.net and am struggling to work this one out.
I have a datetimepicker, i am displaying short date in dd/mm/yyyy format... how do i store this value in ms sql server 2005 datatable with a field defined as smalldatetime.... ? If I simply save it, it is giving some error.....
View 1 RepliesI have the date format string dd-mm-yy. Please can you tell me how to add hours and minutes to the string (i.e 13-03-2010.21.03) ....
DateTime.Today.ToString("dd-mm-yy") ?
I'm trying to format a string so that when it's put into a RichTextBox, the bold, italics, etc... will be interpreted correctly. I found an example that shows the following string[code]....
View 4 RepliesCode:TimeTo_dtp.CustomFormat = "dd/MM/yyyy - HH:mm:ss"This works fine, but what I also want is for the the user to be able to select their time more precisely using miliseconds. After searching around I came across this web page:It has all the different formats on there. If you scroll down you will see format 'f' then format 'ff' then format 'fff', 'ffff', 'fffff', 'ffffff', 'fffffff.'What I am asking is how do I use that in my example?
I tried
Code:
TimeTo_dtp.CustomFormat = "dd/MM/yyyy - HH:mm:ss.fff"
[code]....
I have an application which uses the calendar. I guess the control DataTimePicker is a choice. For this month "June", the format looks like.
[Code]...
The VB format(object,formatString) command fails when placed in the handler routines of a DataGridView.In the following procedure the newCellValue returns the Format string value instead of a formatted cell value.This pproblem occurs in both the dgv_CellFormatting and the dgv_CellClick routines.The same commands work properly when placed in a procedure on the form.
Private Sub dgv_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dgv.CellFormatting
If e.FormattingApplied = False And Not e.CellStyle.Format = Nothing Then[code]...........
In the past I've been able to pass a format string to the tostring method.It's not working any more Here's an example from my Watch window:
1.1.tostring String
1.1.tostring("0.00") {"Enum value was out of legal range."} System.ArgumentOutOfRangeException
[code]......
I'm trying to read back a string that I wrote into a binary file, but it's giving me problems and I don't know what's going on. I open and read my file using the code below:
ifstream input([filePath UTF8String], ios::in | ios::binary);
int numStringBytes;
input.read((char*)&numStringBytes, 4);
[Code]....
I'm trying to read back a string that I wrote into a binary file, but it's giving me problems and I don't know what's going on. I open and read my file using the code below:
ifstream input([filePath UTF8String], ios::in | ios::binary);
int numStringBytes;
input.read((char*)&numStringBytes, 4);
[code]....
There is a lot more to the file reading code, but it's proprietary and this is the part that keeps crashing. It runs fine loading the first two files, but when I try to open a third file, it crashes with EXC_BAD_ACCESS at the input.read((char*)names, numStringBytes); line. I don't see any reason that this should crash. I'm writing the binary files in VB.NET using the below code:
Dim myFS As New FileStream(savePath, FileMode.Create)
Dim encoding As New System.Text.UTF8Encoding()
Dim stringBytes() As Byte = encoding.GetBytes("++string")
[code]....
Say I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
View 2 RepliesMy textbox6 represents the dateprinted of my asssessment form.. i code it like this :
TextBox6.Text = My.Computer.Clock.LocalTime.Date
then in the my SAVE Button coded like this :
Dim cn As OleDbConnection
[code].....
I'm using a database to store a load of data and some of which is the date from a datetimepicker and its storing the date and time for me. but its not saving the date and time for me its just leaving it blank any ideas
i set up the database vis the database creater in VB 08
call the field Dateout and the other column "Datetime" and i would of thought that would of saved me date and time.
in datetimepicker_value changed section ive got it down as datetimepicker.text as now.date.tostring
I used a code to get the dates between 2 dates from the database (column with dates dd/mm/yy) , I think it works nice first time,[code]as you see , the code let the user to insert a number and minus it form the date of today , then calculates the date that I want , after that I use BETWEEN Clause to get all dates between them But now , this code gets some data and overpasses others , I mean some of the dates is between the tow dates but the code never get it , why that happens ?
View 2 Repliesmy problem is want to use WHERE clause to extract only year that fulfill a specified criterion. My coding as below, the coding below is extract all the month,day and year. But i only want year only. I am using MS Access. My textbox(cbYear) can select January To December. Can anyone give me a guideline to correct the coding.
sql = "SELECT * FROM sumPercent WHERE plants = '" & yieldsummary.cbPlant.Text & "' AND [b]dates = #" & cbYear.Text & " #[/b] AND line = '" & ds.Tables("sumPercent").Rows(a).Item("line") & "'"
I have an accounts program. My cash book shows data based on date picked from DateTimePicker. Cash book is not entered everyday. I want to make my datetimepicker so that based on dates found in the database, it changes colour or enable / disable some dates, for which cash book has been entered. How is it possible?
View 6 Repliesi was wondering is there a build in class in vb.net for get a range of dates from a column:What i mean is say i had the following dates in a column
10/03/2012
11/01/2011
14/05/2011
[code].....
I am currently making a college project for which i need to send scheduled emails.I googled for it and found out the we can do it through outlook. Is there any way to automate that process through vb, so that it will check for the dates in the database and send an email whenever necessary?Outlook is not important for me... I just need to send scheduled emails.And i even need to send sms (single and bulk) according to the needs... is there any free API for that too???I have already tried the google sms feature but it didnt work for me
View 8 RepliesI'm working with time and attendance application and i need to do something will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
[Code]...
I'm working with time and attendance application and i need to do some thing will help the data entry that will use my application so i want to create form to insert enter/leave time and date for all employees
textbox1 for inserting start of employee code
textbox2 for inserting end of employee code
textbox3 for inserting the date and time for enter
textbox4 for inserting the date and time for leave
I have a database (MDB, Access) and I connect it to my program using an OLE object,
now I have in the db a column filled with dates (ddmmyy),
I want to search and view (in Data grid view) all the fields that has a date before a Specific Date that I define .
the code of search that I used is :
SQLstr = "SELECT * FROM tb WHERE anomber = '" & TextBox1.Text & "'"
I am reading dates from a table in a database to display in a DataGridView column that is formatted as a date. The problem is that when the value is null in the database my program errors out because it cant convert the value to a date. How do you guys handle this? *Edit: If I set the value of my date variable to "Nothing" it displays as "1/1/0001" in my DataGridView, and I would like the cell to be empty for the null dates.
View 24 RepliesI am currently using VB. I want to do a Calendar Control which have dates highlighted/selected. All these dates are retrieved from a database.
how to put all the dates into an array Second thing I need to know is how to highlight all the dates in the array.
I have done some research on the internet and they said something about selectedDates and selectedDates collection and dayrender. But frankly speaking, I can't really find any VB codes regarding this. Dates format will be in dd/MM/yyyy
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
[Code]....
I'm using one Access Database and DataSet, BindingSource And Table Adapter. My question is: how to fill one listbox on my form with dates from one row from Database.
Look at the picture:
[url]
So listbox needs to have 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20.
How to to this, code?
Ours is a transportation company. We do services/transportation/logistics for various companies.I am working on Scheduling a work order process for those companies who are registered with us.While during the process of registration, a company will specify the week number to execute a job during the contract period.So this will be a routine service which we need to perform for every number of weeks specified For Example: if any company specifies the week number as : 2. that means for every 2 weeks we need to do the service for that company during the contract period.
How to update the dates into the database server for each company for their jobs to be performed.So if my Admin wants to know all the jobs in this current week. I should be able to pick only those companies and their jobs in this week only.