My application require to have Synchronized time for all userI have several PC connected to same Database in a LAN, but each PC Clock is set differently, maybe few minute before or after. I need to capture the time from the PC where the Database is located
View 9 RepliesIs there a way to check if the date time picker has been changed? I have a date time picker set to allow a person to put in their date of birth and I have it set to no greater date than 12/1/1992, but I need to check that the user has actually selected a date before the form is submitted. Can it be checked?
View 6 RepliesThought I'd see if Stack overflow is quicker than me testing something while I get a thousand interruptions from other work :)
I'm updating an old VB net application and trying to refactor some of the logic as I go. The app looks for data from a single date across a few tables and writes that view to a file.
Writing the query in SQL I'd get the equivalent of
SELECT * FROM table
WHERE CAST(FLOOR(CAST(table.date AS float))AS datetime) = '15-Jul-2010'
Ideally I'd use
SELECT * FROM table WHERE date=@input
and add a date object as a parameter to a System.Data.SqlClient.SqlCommand instance
Are those two comparable? Will I get the results I expect?
I am using VB 2008 and want to record a start date and time and then the stop date and time in a rich text box, i can get the start time into the box but so far can only stop the time instead of 2 seperate times, what i have is a drop down box with a list of computers 1-10 i was trying to get it so you picked a certain computer and that went into the text box then you started the timer and that was recorded, finally you stopped the timer and that was recorded but as i am a total newbie it does not work
Here is the code i have.
Public Class Form1
Dim time2 As Date
[CODE]...................
Title pretty much says it all. How do I format the date of a dateandtimepicker to insert it into the SQL date datatype?
View 20 RepliesI have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
Makes a long time I do that on web program(with frames...on Dreamweaver), but now, I want to do the same on my VB interface.I have a menu on the side of a form(main form) and I want, on the menuitems click events, to have the corresponding form to appear in the other part of my main form.I tried the mdicontainer stuff, either it doesnt resize correctly with my main form or it makes a title bar in the top of the child form(on maximize).
I also tried to show my form in a panel but again, i ave issues.Now, I don't know what to try. My last solution will be to erase/dispose all the controls of the form(except the menu) and always dynamically recreate the controls on items clicks.
how can I create following thing with Visual basic?I would like my excel to check the date value in a cell and compare it to current date and if the value in the cell is older than 2 months compared to current date it would change the cell's colour.
View 1 Replieshow can i open file .exe in the same my application directory i tried Call Process.Start(IO.Path.Combine(Application.StartupPath, filename))but it open my application not anther one?
View 2 RepliesI am attempting to import data in a batch from an Excel Worksheet to a Sql Server database. Everything works except for the one date field in the spreadsheet. The date returned is off by four years from the value in the spreadsheet. Example: The Excel sheet has a date 10/24/2010 14:18, but when I look at the column in my query, the date is 10/23/2006 2:18. This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.
The Excel column comes to me as a custom type, formatted m/d/yyyy h:mm. I receive this from an outside vendor and having them change the column is not going to be my simplest solution.
For what it's worth, the relevent part of the query is:
Select [Date Created] From MyWorksheet
Would it be possible to search a table, confining to a specific date range based on a date-time column, and get a count of the 10 most used words in a particular var-char column excluding a list of words?All in SQL?Currently I am pulling out the records that match and sorting through the contents outside of SQL, I would think where I can do it directly on the server it would be more efficient.(SQL 2008)
View 4 Repliesi am using date time picker and i am selecting 1 date from calender.after selection of that date i want to refresh date time picker i.e. it should display todays date.
View 2 RepliesI have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date
newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd")
'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
[Code]....
Is it possible to read a label's text property of another app?I know how to get the handle of the main window, and i got the code for the child.But the problem is that there's like 20 other labels on the window and when i use winID to get it's class, it's just "Edit", and it's the same for all the labels. And the title is the value of the labels text property.
View 7 RepliesI'm using
Days = Dat2.Subtract(Dat1).Days
where
Dat2 = today
Dat1 = installed date
to trace the days of a program installed in user's computer.However, the user can changes the system time of his computer to a advancing date. How can I get a SNTP time from internet to solve this problem?
I am using this line of code on form load event it is working very fine but i have to problems
1. It replaces the form name and display the date and time but i want to keep both date and time and forms caption separated by some space.
2. When form loads it load the current date and time but the time does not change it should run.
What should i do please please help me code is as follows
Me.Text = Date.Now.ToLongDateString & " - " & TimeOfDay
The problem that I'm having is that when I try to select a different date, the text doesn't go away. That may make no sence, but let me tell y'all what I've done.
1: Created a GroupBox
2: Put a DateTimePicker in the GroupBox
3: Put TextBoxs in the GroupBox
4: Changed the DateTimePicker to look like this:
A)Checked - False
B)Allow Drop - True
I thought that if I changed that, then the text in the text box would go to that specific date. It didn't do that, it just stays the same. What I'm trying to do is enter text in say 3/7/11 and when I choose date 6/12/12 it will display blank text boxes for me to enter something different.
How do i code a date time picker in form 1 and show the date and time in a label in another, I have 2 forms and a module to transfer.
View 4 RepliesHow to get the current date and time in textbox in IST ( Indian Standard Time) in vb.net ?
View 1 Repliesi'm using a date time picker with format set to time. i want to be able to trigger an event at the time selected in the date time picker
View 19 RepliesI have a datetime picker in one of our apps. When loading up the win form I need the date time picker to default to the Wednesday following todays date. Any idea how to do this? We are using .Net 1.1 for this app.
View 1 RepliesI have a DB table with the following columns
PolicyNumber
NextPremiumDate
PremiumNumber
Example For each PolicyNumber i have 5 NextPremiumDates.I want to display the 1st NextPremiumDate which is easy ...but i want to show the next NextPremiumDate only after the last NextPremiumDate has passed...How do i check if the last date has passed?I mean if i have 5 dates in the table given above...how do i check if the 1st date has passed then show 2nd date ...if 2nd has passed show 3rd and so on.
I have a program that reads a file with Pacific Daylight Time, I want users to see the time and date in their local environment.
At present I have in Australia a time difference of 18 hours, so I have a list box with -24 to +24 and currently set at 18, my code is elementary as long as I have moved past day one of the month it suits me personally, but I want to distribute my app, so I need something better.
i'm using a date time picker and want an event to trigger with just the time so it will trigger every day at a certain time. can anybody help
View 1 RepliesThe Now() function in VB.NET returns date and time which is different from the system time that I see on the right-bottom on the notification bar. It is 15 hours slower than the system time. Has anyone ever met this problem? I'm using .NET 2.0.
View 2 RepliesIm using vb.net and the database is mysql to write a time management system. how i store date and time to the database?
View 2 RepliesI have a problem. I'm making a alarm clock and I need a way of converting a "dd/MM/yyyy HH:mm:ss" format into a date time format. This means I'll be able to compare the dates in a listbox using the for each function, to the current date and see whever it has passed and therfore the alarm should be deleted. It is currently in a string form so I can't use < and > to compare it to the current date as that is in a date form. I've tried using CDate but it doesn't work as it only will convert these formats:
"August 12, 2004", "2:07:30 PM" and "August 12, 2004 2:07:30 PM"
I have a date entered in from at DateTimePicker (dtDate.Value) and am writing it to an access database. This insert code works without the date, but not with it.
"INSERT INTO Deads (Location, LotNo, Date, Head, Cause, BookCost, JournalEntry, Pasture) "
InsertRow(StrComp, InsertSQL)
[code].....
cant seem to get this to work , I am tryin gto get the date from last week exactly 7 days ago i get an error when i try this "cannot convert to date "
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dateTimeInfo As Date = Date.Now
MessageBox.Show(dateTimeInfo.Date.ToString(Format(DateAdd("", -7, "yyyyMMdd"))))
txtFileDate.Text = ""
End Sub
I am using this datetimepicker by Trent Richardson, I can get the date time picker to work, however after the date is changed i need it to be put into a hidden asp.net control that is in an update panel. So how can i make it so everytime the user changes the date and time it is sent to a label. url...
View 1 Replies