I'm currently struggling on how to make a comparison between a timespan value and the current time.I went up to here, but the comparison totaal with the current time doesn't work .
[Code]...
These two TimeSpan are stored in the Database with 24hr format. No date, only TimeSpan.
Dim r As TimeSpan
Dim tsStart As TimeSpan
Dim tsEnd As TimeSpan
[Code]...
Is there any TimeSpan method to get this right?
i have a table "Contracts", with fields CompanyNumber, MaturityDate and other fields.i have a form in vb.net, with a textbox that should check if the entered company number exist in my db, if it does it should check whether the maturity date is bigger or less than current date.Any one out there that knows how to go about it? Here is the code am trying with;
Private bindingSource1 As New BindingSource()
Private dataAdapter As New OleDbDataAdapter()
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mtc.mdb"
[code].....
I would like to format a gridview based on comparing the current row value (column 2) with the previous row value. So if they are the same the background color would be that same, say green. If they are not the same the background color would be red. For example: [Code]
View 3 RepliesI have a requirement that regardless of the start and dates that I need to loop through that timespan and calculate figures at the month level. I cannot seem to figure it out, and maybe it is not possible, but I would like to do something like:
FOREACH Month As TimeSpan in ContractRange.Months
Do Calculations (Month.Start, Month.End)
NEXT
Is this possible or do I need to calculate the number of months, and just iterate through the amount of months and calculate the start/end of that month based on my index?
I know nothing of VB.NET, but if I were you
View 2 Repliesi want to create a table that include a current year data and as well as previous data to be compare. here is the example of the table that i want to create: but i want to compare one of the annual data with the previous year. as example i want to compare between the data of current AR of 2007 with the current AR for 2006, Current AR of 2006 with current AR for 2005 and go on~, but i have no idea how to do it.
View 1 RepliesI'm trying to compare the modify date of a file vs the current system date. I've found an MSDN article describing how to get the modify time of a file:
Dim infoReader As System.IO.FileInfo
infoReader = My.Computer.FileSystem.GetFileInfo("C: estfile.txt")
MsgBox("File was last modified on " & infoReader.LastWriteTime)
This gest the Date and Time, but I want just the Date not the time.
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 RepliesI need to compare the current time with different time intervals, how can i get the time in this format so i can compare them.Format: 09:45:00
View 3 RepliesOK, I have this loop I want to perform which involves the serial port. Not to get too specific I'm actually sending data to an external device within a loop The loop involves a Start number, increments by a Step and ends when it gets to Stop This repeats until I click a STOP button.
View 15 RepliesI have a stored procedure that when I run it within my application it times out, but when I use Management Studio and pass in the same exact parameters, the stored procedure executes under a second. I had this exact same issue with the same stored procedure before, and all I did was recompile it, and it fixed the problem, but I do not want to keep having to recompile this stored procedure every few days or so. Has anyone else ran into this issue before?
Another note I would like to mention, is that I'm currently working on a test database, so I'm not inserting, deleting or updating any of the records that the Stored Procedure is using. So the database itself is not changing, but for some reason the Stored Procedure is showing degradation, and at the most we have 2 users in the database at a time.
Below is the code I use to call the Stored Procedure from my app.
cmd.CommandText = "sp__RECAP_SELECTION_GET_GRID_RECORDS_RECAP_TYPES"
cmd.Parameters.Add("@FK_KitchenID", SqlDbType.SmallInt).Value = cmbKitchenCustomer.KitchenID_SelectedPrimaryKey
[Code]....
As I mentioned, if I run the Stored Procedure within Mangement Studio, it runs with no problems. Also if I recompile the stored procedure, it runs fine within the app, but after a few days, the stored procedure starts to timeout again within the app and I need to recompile it again.
The program operates a board and activates relays when the buttons are pressed, the code works fine and i have published it to use on a PC however, after about 2 days the port times out and it stops operating the port, am i missing any code such as close port anywhere.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I use combo boxes with the Autocomplete turned on (Source = ListItems and Mode= SuggestAndApplend). The problem is that if the user stops typing for two seconds and then continues typing, the Autocomplete starts matching only on a new characters being typed. For example, I have a list with two items: "apple" and "please". I type "ap", then pause for a couple seconds and then continue typing "ple". I want the list to match on "apple" but instead it matches on "please". I'm looking for a property or some way to set the length of time the control resets the matching. Do you know if one exists?
View 6 RepliesI am a complete noob at programming, so I need all the help I can get with my new program.I am building a web-browser which is linked to one webpage. The content of this page is constantly changing, so I need the web-browser to auto-refresh after 2 minutes. But if it refreshes while NOT connected to the Internet, the browser will show an error message, so that is why I have build in an Internet check. This check is working. The browser also have to be in the same place at the screen every time the software is loaded. This code is also working.
But the timer and the refresh is bugging me. I cannot get it to work. The code is not responding.
[Code]...
I need access to very precise timing in a .NET application. I need microsecond precision. Is there an easy way to do this in .NET?
View 5 RepliesIm trying to check to see if a value of a label changes over time. however I can't seem to get it right.
dim val1 as string
dim val2 as string
private sub form1_load()
dim val1 = label1.text
end sub
[Code]...
problem is it will only check it once after ten seconds when the timer is set to 10 seconds i need to to check it every 10 seconds becuase these values display altitude, and if the server freezes the altitudes dont change. I need to make sure they are updated and not frozen.
I am using VB2008 SerialPort to communicate with a device. My problem is, using RTS handshake I am missing the first 50 or 60 chars, after that everything is intact. I tried to change the buffer size - Has no effect, used standard, bigger, smaller and no change.
The device timing says when it sends CTS signal, it will start listening 100ms after that. I have no clue how to delay the write to test this. Should I first write to the buffer then write to the port after a a 100ms timer event?
I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably infinite) timeout (although I've also tried 12 hours as a timespan parameter). Then I use GetDtcTransaction on the ambient transaction (created by transactionscope) to get a DTC transaction to link to the third party SDK. Things work nicely for about 10 minutes, but after 10 minutes, the transaction disappears and an error occurs. How do I determine why the transaction is disappearing. I suspect it's a timeout because it regularly occurs after 10 minutes even though slightly varying degrees of work have been done at that point. But I'm at a loss about how to determine what terminated the transaction, why, and how to extend its life.
[Code]...
So, I got an SSD drive for my computer the other week, and decided to have a little fun. I wrote a program which starts every single program in the Windows Programs folder in the Start Menu, via clicking the "Go" button on my Form. It works beautifully. Only thing I would like to add to it is some sort of timer, which I have never tried in any programming language. I would basically like for a timer to be running, counting in real time (seconds), until my loop ends, and then display the total time taken at the end. I was thinking about setting a variable equal to the current time, before the loop starts, and then another equal to the time right after it ends, and then taking the difference of the two.
View 7 RepliesIs it possible to hide some control on timer event. Initially when the page loads, i am label control on the form. So after some seconds, can i able to hide that label?
View 5 RepliesOur production database as grown to a size where several of our longer running stored procedures are taking more than the default 30 seconds to complete. I've programatically set some of the CommandTimeouts on the command objects but the calls to the store procedures still appear to be timing out after 30 seconds.
Here's what I did:
In web.config set this property
add key="CommandTimeOut" value="180"
Added this to the top of my class that needs the timeout set:
Dim COMMAND_TIMEOUT As Integer = ConfigurationManager.AppSettings("CommandTimeOut")
After creating the command object set the timeout property on the object.
cmd.CommandTimeout = COMMAND_TIMEOUT
Unfortunately my stored procedures still seem to be timing out when they take longer than 30 seconds to execute.
I have a timer routine (basically just a timing loop) that moves shapes around the screen. The problem is that it isn't in sync with Windows (Vista). If a Windows background program runs (like an antivirus) the screen goes gray. The timing routine still runs but the display is shut off. Only when the shapes are done moving does the screen return to normal (but I didn't actually see the shapes move). Another good example of my issue is when I finish debugging and press the Start button, again I don't see the shapes move, I just see a grayed out screen with the cursor in "busy" mode.
All the other VB.NET programming I've done doesn't assume so much control as this timing loop. I've never had to worry about coordinating a routine with other windows functions. What's the trick to getting this stuff to work together smoothly?
Why does this code works for the first few then gives timeout on all the rest ? VB removed, resolved like when i run it with say 50 threads, the first few work fine but then the rest after that all time out, i have tryed moving the ones that work to the bottom of the list but they still timeout after the first few are done.
View 2 RepliesI added a web reference to my VS 2005 console application [Code] The call to this WS times out with :"The CLR has been unable to transition from COM context 0x1a3008 to COM context 0x1a3178 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages.
This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations."
I used WCFStorm to call this WS and the result comes back in an instance, so I don't think the WS is a problem. I deleted the web reference a few times and added it back again. did the clean and rebuild operations.
I have two textbox in my application.
Textbox1.Text="19-Jan-2010"
Textbox2.Text="Jan 2010"
May I know how can I compare that Textbox1 and Textbox2 text is within same month and same year?
MVC3 vb.net. In my app I have a point where 500+ emails with attachments are sent out using a for each loop to accomplish this.. Nothing is returned to the browser the entire time this is running so eventually the browser think it has timed out... I tried just having it redirect to another actionresult function after every email and that function just passes it back to the email function. This is not working and I feel the reason is that nothing is actually being sent to the browser window its self.. Is there a way to fix this issue??
[Code]...
I am having an issue with serial port timing when using it to read large flash content. If I slowly step through the code the program works as expected. If I let it runs by itself it only shows part of the result. The problem is not related to displaying the data on the form but mainly the "Serialport.BytesToRead".
Here is the code
Private Sub MemoryReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MemoryReport.Click
Me.BackgroundWorker1.RunWorkerAsync()
'Memory_Report()
'SerialPort.DiscardInBuffer()
[Code] .....
I'm trying to measure the performance of seven sorting algorithms in a single VB 2008 program. I've tried using a Timer componend, the Stopwatch, and DateTime.Ticks but nothing works. The following simple code produces a result of about 500 (milliseconds), which is correct, but when I change 500 to 1000, I get a ridiculous result like 0 or 8.
[Code]...
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
Suppose I want to add 2 hours to this timespan what would be the method for it + code .