How can I loop through each date in a given time period so that I can add those dates as a column name in a table. I want to create datatable with the person's name and hours he worked in a given time period. The user will select the dates and I want to show each day/date in that table as a column name.
View 1 RepliesI have been trying to find out of the last hour how to do something proberbly very simple ?
I have a button, when I click on it, I want to loop the code inside this button for 60 seconds.
I am looking for a library doing set operations on time periods with support of weekdays and time of day. I have started to roll my own, but it seems like a error-prone job so I would like a tested solution for this.I don't mind spending money. If I have a set of two time periods (this can be several)
[Code]...
I know about DateDiff and TimeSpan. I am doing a project. I save a date in the registry. Now, I have to test this date against today's date and calculate the differences in minutes, hours, days, months, weeks and years.
I save the date in the registry like this:
Application.UserAppDataRegistry.SetValue("Date", [Date])
I then made a sub to calculate the differences:
Private Sub Calculate()
Try
Dim DateGen As Date
DateGen = CType([Date], Date)
Select Case TimePeriod
[Code] .....
As you can see, based on the difference between these dates ( today's date and the registry date ), a sub gets called and the program continues. Unfortunately, the minutes and hours never calls the RandomAlpha sub. How can I calculate the difference in minutes, hours etc.????
I'm trying to find a VB code that checks if my date on a label is between a certain dateperiond that is chosen from two DateTimePickers..[code]...
View 6 RepliesI am trying to display a dialog for a period of time. if the user is not present, I want it to close and perform a task. I am using a background worker, which is supposed to simulate a button click. It performs the button click fine, but the dialog never goes away.
Private Sub Backgroundworker_ProgressChanged() Handles BackgroundWorker1.ProgressChanged
If Me.BackgroundWorker1.WorkerReportsProgress >= 100 Then
[Code].....
take a shot from a camera every last day of the month at midnight. I know how to to take the shot, but I don't know how to generate an event repetitively after a time period. I thought about to calculate the time between now and the next shot time, but how to run a method after a time period?
View 3 RepliesHow I can stop my application if not use it for a period of time ?
View 1 RepliesI have set up a simple quiz where you drop answers to the correct question. I have implemented a system where the are 18 text boxes (9 for questions, 9 for answers) and it can be customised but I want the questions to be able to be 'saved's since it in another form the if I give them special names when I close the form and open it again it has lost the values. Is there a way to remember the variables for a set period of time (cookies?) or if not just for that session?
View 2 RepliesI want my program to work for a certain period of time, may be one month.. two month..
View 1 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]...................
Is there a way to code, so that if your program freezes over a period of time (5sec), it just stops trying to do it, and goto something else.
"On ERROR" wont work, since its not a error. "Try" doesnt work ether.
Its because I'm am programming something that can login to a router thought telnet, and sometimes the telnet ActiveX doesn't read the buffer or the line proberly, so when the .GetLine() func is called, it freezes. And i want away to goto another point if it keeps freezing for more than 5secounds. The telnet ActiveX that, I am using is Dimac w3sock.
I have created a windows service in C# .net and now I want it to alert me if its going to shutdown. For this I make use of Dispose/Unload events but now I want if the services are stopping due to system shutdown process it will alert me.
View 1 RepliesI have already made an algorithm for the problem but it still got a trouble.Suppose that I have the recap of schedule (contains on gridview named GV):
TimeStart TimeEnd TotalOccuredOnThisTime
----------------------------------------------
08.00 08.50 1
08.00 09.40 43
08.00 10.50 2
What I want to get from the algorithm is, to count the time that occured on the same period, e.g. on the time of 08.00, it's occured 46 event (see the yellow colored row).This is my algorithm:
Dim ColumnLength As Integer = GV.Rows.Count
Dim TimeStart(ColumnLength - 1) As Integer
Dim TimeEnd(ColumnLength - 1) As Integer[code]......
I am developing an application that prompts an user for doing certain tasks in a form. What i want is that a certain message should be popped for a certain amount of time and then close (probably say 2 seconds or so). I tried doing it with message boxes but they do not close on their own as they are designed to be modal (to wait for user command ). i do not want to display the text in a textbox of listbox. Is there a certain way i could do this.
View 4 RepliesI have looked through couple of threads about making the trial application to be expired within certain time. Most of the advice is to set a timer and store it in somewhere in the system with encrytion. Then later decrypt and compare with the date installed in the system.
View 12 RepliesI'm making a financial application, I need the application to close if the user did not do anything for a cretin period of time.
View 9 RepliesI have developed a system which i want my client to use for trial purpose for 1 month. i want a software or an idea to time the system for that period after which it should cease to work.
View 1 RepliesI have the below code. What happens if the Upload method takes more than one minute for completion? Does the timer kick off another call to the Upload method immediately after one minute is over or Does it wait until the method finishes executing? I am implementing this as a windows service.
Protected Overrides Sub OnStart(ByVal args() As String)
Dim tmr As Timer = New Timer(New TimerCallback(AddressOf Upload), Nothing, 1000, 60000)
While Not tmr Is Nothing
[code]....
How do programs like antivirus keep track of time passed for the trial period? Eg I want to make a program that expires and stop working in 30 days One way I thought of is to make use of the system time.
View 6 Repliesive been wanting to put some kind of self destructing code in my application that deletes itself after a given period of time. (like 2 weeks)
View 3 RepliesWhen displaying a message to the user using 'msgbox', is it possible to have the msgbox close after a set period of time, if the user has not clicked on OK?
View 2 RepliesTitle 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'm trying to connect a remote mysql database. I'm doing it from a vb.net 2005 application with a connector mysql.data.dll What's happening is, suppose if I try to connect thrice it connects twice and once throwing an exception that says A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. there's nothing wrong with the code, otherwise it would never have connected
View 4 RepliesOut of curiosity, is there a way i can make a program stop or pause for a period of time (which i would choose) before continuing the code WITHOUT a timer.I think I've seen this done before, but I'm not positive.Also note that I'm talking about a forms application (not a console app if that would be any different.)
View 3 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?
I am constructing a program, i am new to Visual Basic, but i have past programming experience. I was wondering if anyone knew how to form a loop that could...lets say calculate the answer when two numbers are added together,and it would repeat this thousands of times, etc. And if there is a way, would it be possible to calculate the time taken to complete this loop.
View 5 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 Replies