Is there a pause command?

  • Thread starter Thread starter Trint Smith
  • Start date Start date
T

Trint Smith

I need to pause one second here-|
|
|
Try |
<--------------------
conn.Open()
Dim sqlInsertCommand2 As New SqlCommand(sqlstr, conn)

How can I do that please?
thanks,
Trint

.Net programmer
(e-mail address removed)

.Net programmer
(e-mail address removed)
 
Trint Smith said:
I need to pause one second here-|
|
|
Try |
<--------------------
conn.Open()
Dim sqlInsertCommand2 As New SqlCommand(sqlstr, conn)

How can I do that please?
Click to expand...

System.Threading.Thread.Sleep(1000)
 
By more of a question is WHY do they NEED to sleep there for 1 second?

???
 
I found this , hope it helps

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Try
Sleep 1000
conn.Open()
Dim sqlInsertCommand2 As New SqlCommand(sqlstr, conn)
 
Jeff,
Unfortunately you got the define wrong, in .NET its:
Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Integer)
Click to expand...

Remember in VB.NET an Integer is 32 bits, a Long is 64 bits.

Also as Armin & Herfried showed, that API is already in .NET, no need to use
a Declare statement.

System.Threading.Thread.Sleep

The added advantage of the .NET version is it has the Integer version that
accepts milliseconds, plus a TimeSpan version that you can specify Hours,
Minutes, Seconds, and Milliseconds amounts with.

Hope this helps
Jay
 
thanks,
this worked:
System.Threading.Thread.Sleep(1000)

and the reason I needed it is because of a function prior too this...for
some unexplicable reason, needs time to let go of a file...
thanks,
Trint

.Net programmer
(e-mail address removed)
 
A more robust solution might be:

Dim i As Integer = 0

While i < (Max Number of tries)
If ( Check for file access here) Then
Exit For
End If
i += 1
System.Threading.Thread.Sleep(1000)
End While
If i = ( Max number of tries) Then
'Take appropriate action on error
End If

In general, pausing for any set period to solve a timing issue is asking
for trouble.

Francis Ingels
Visual Studio Update


--------------------
 
The 'Exit For' should be 'Exit While'

Francis Ingels
Visual Studio Update

--------------------
Newsgroups: microsoft.public.dotnet.languages.vb
From: ringels@subtract_this_field.microsoft.com (Francis Ingels [MSFT])
Organization: Microsoft
Date: Tue, 07 Oct 2003 18:55:47 GMT
Subject: Re: Is there a pause command?
X-Tomcat-NG: microsoft.public.dotnet.languages.vb
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

A more robust solution might be:

Dim i As Integer = 0

While i < (Max Number of tries)
If ( Check for file access here) Then
Exit For
End If
i += 1
System.Threading.Thread.Sleep(1000)
End While
If i = ( Max number of tries) Then
'Take appropriate action on error
End If

In general, pausing for any set period to solve a timing issue is asking
for trouble.

Francis Ingels
Visual Studio Update


--------------------
From: Trint Smith <[email protected]>
References: <efQS#[email protected]>
X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
Subject: Re: Is there a pause command?
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <[email protected]>
Newsgroups: microsoft.public.dotnet.languages.vb
Date: Tue, 07 Oct 2003 11:17:47 -0700
NNTP-Posting-Host: actionjackson133.dsl.frii.net 216.17.147.133
Lines: 1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:144656
X-Tomcat-NG: microsoft.public.dotnet.languages.vb

thanks,
this worked:
System.Threading.Thread.Sleep(1000)

and the reason I needed it is because of a function prior too this...for
some unexplicable reason, needs time to let go of a file...
thanks,
Trint

.Net programmer
(e-mail address removed)
Click to expand...
Click to expand...
 
Back
Top