Hi just wondering if there is a way to set up a wait for object in vb.net as
if a put a delay in between the fill and the databind things work ok, but if
not the page is reloading without the updated information,(st ored procedure
is taking too long to complete).
the time needed for this delay will change depending on the time the "stored
procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset.
(delay -for loop)
datagrid.DataBi nd() 'bind the data grid.
This is related to a previous post, that did not include enough information.
thanks.
--
Paul G
Software engineer. 6 1884
"Paul" <Pa**@discussio ns.microsoft.co m> wrote in message
news:06******** *************** ***********@mic rosoft.com... Hi just wondering if there is a way to set up a wait for object in vb.net as if a put a delay in between the fill and the databind things work ok, but if not the page is reloading without the updated information,(st ored procedure is taking too long to complete).
the time needed for this delay will change depending on the time the "stored procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset. (delay -for loop) datagrid.DataBi nd() 'bind the data grid.
Paul,
DataAdapter.Fil l is synchronous. When it returns, the data have all been
loaded. If a delay is helping things at all, it's for a different reason.
John Saunders
ok thanks for the information. Does seem like it would wait for the
procedure to finish, will have to figure out why the delay seems to be making
things work, the delay is between the fill and the datagrid bind.
"John Saunders" wrote: "Paul" <Pa**@discussio ns.microsoft.co m> wrote in message news:06******** *************** ***********@mic rosoft.com... Hi just wondering if there is a way to set up a wait for object in vb.net as if a put a delay in between the fill and the databind things work ok, but if not the page is reloading without the updated information,(st ored procedure is taking too long to complete).
the time needed for this delay will change depending on the time the "stored procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset. (delay -for loop) datagrid.DataBi nd() 'bind the data grid.
Paul,
DataAdapter.Fil l is synchronous. When it returns, the data have all been loaded. If a delay is helping things at all, it's for a different reason.
John Saunders
Hi Paul:
The Fill method is going to block (wait) until it has the results from
the stored procedure. If there is a timeout it will throw an
exception. Any chance you have this code inside of a try catch that is
eating the exception?
Depending on which data provider you are using you can generally set a
timeout threshold (like the CommandTimeout property of a SqlCommand
object).
--
Scott http://www.OdeToCode.com/blogs/scott/
On Tue, 9 Nov 2004 16:14:04 -0800, "Paul"
<Pa**@discussio ns.microsoft.co m> wrote: Hi just wondering if there is a way to set up a wait for object in vb.net as if a put a delay in between the fill and the databind things work ok, but if not the page is reloading without the updated information,(st ored procedure is taking too long to complete).
the time needed for this delay will change depending on the time the "stored procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset. (delay -for loop) datagrid.DataBi nd() 'bind the data grid. This is related to a previous post, that did not include enough information. thanks.
Hi Scott, thanks for the response, not sure what you mean by eating the
exception.
I am using a try, catch and stepped through it, does not seem to create an
exception,
try
several select commands like below
dataadapter.Sel ectCommand().Pa rameters("@para m1").Value = somevalue
dataadapter fill
delay
datagrid bind
Catch ex As Exception
s_message = ex.Message()
End Try
The stored procedure builds the query dynamically based on inputs, and uses
the EXEC sp_executesql.
Think I will set the timeout period as well as this has not been set.
"Scott Allen" wrote: Hi Paul:
The Fill method is going to block (wait) until it has the results from the stored procedure. If there is a timeout it will throw an exception. Any chance you have this code inside of a try catch that is eating the exception?
Depending on which data provider you are using you can generally set a timeout threshold (like the CommandTimeout property of a SqlCommand object).
-- Scott http://www.OdeToCode.com/blogs/scott/
On Tue, 9 Nov 2004 16:14:04 -0800, "Paul" <Pa**@discussio ns.microsoft.co m> wrote:
Hi just wondering if there is a way to set up a wait for object in vb.net as if a put a delay in between the fill and the databind things work ok, but if not the page is reloading without the updated information,(st ored procedure is taking too long to complete).
the time needed for this delay will change depending on the time the "stored procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset. (delay -for loop) datagrid.DataBi nd() 'bind the data grid. This is related to a previous post, that did not include enough information. thanks.
Seems to be working now without the delay, had something wrong with a
validator so removed it and added another. Thanks.
"John Saunders" wrote: "Paul" <Pa**@discussio ns.microsoft.co m> wrote in message news:06******** *************** ***********@mic rosoft.com... Hi just wondering if there is a way to set up a wait for object in vb.net as if a put a delay in between the fill and the databind things work ok, but if not the page is reloading without the updated information,(st ored procedure is taking too long to complete).
the time needed for this delay will change depending on the time the "stored procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset. (delay -for loop) datagrid.DataBi nd() 'bind the data grid.
Paul,
DataAdapter.Fil l is synchronous. When it returns, the data have all been loaded. If a delay is helping things at all, it's for a different reason.
John Saunders
Seems to be working now without the delay, had something wrong with a
validator so removed it and added another. Thanks.
"Scott Allen" wrote: Hi Paul:
The Fill method is going to block (wait) until it has the results from the stored procedure. If there is a timeout it will throw an exception. Any chance you have this code inside of a try catch that is eating the exception?
Depending on which data provider you are using you can generally set a timeout threshold (like the CommandTimeout property of a SqlCommand object).
-- Scott http://www.OdeToCode.com/blogs/scott/
On Tue, 9 Nov 2004 16:14:04 -0800, "Paul" <Pa**@discussio ns.microsoft.co m> wrote:
Hi just wondering if there is a way to set up a wait for object in vb.net as if a put a delay in between the fill and the databind things work ok, but if not the page is reloading without the updated information,(st ored procedure is taking too long to complete).
the time needed for this delay will change depending on the time the "stored procedure" which will vary, takes to excecute.
dataadapter.Fil l(dataset, "stored procedure") 'fill the dataset. (delay -for loop) datagrid.DataBi nd() 'bind the data grid. This is related to a previous post, that did not include enough information. thanks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Robb Gilmore |
last post by:
We inherited an ASP.NET application which is not thread-safe. Many copies of
this application are in the field and customers are having problems, which we
believe is due to the thread safety problem.
Is there any way to configure IIS to run single-threaded, so that these
customers can get along without errors until we can get them updated software?
Some will have IIS 5.0 ( Win2K and WinXP ) and some will have IIS 6.0 (
Win03 ). For...
|
by: swin |
last post by:
I've a wrapper class around axBrowser which logs into a site,
navigates to a data page and harvests info from it.
It works fine for a single data page (passing it a key for the data),
but my next task is to put it in a loop so that I can retrieve
multiple pages of data.
My problem is that how can I control the loop such that it won't try
and get the next page of data until the previous one has completed -
bearing in mind that I have...
|
by: 6tc1 |
last post by:
Hi all, I have just finished debugging a windows application and have
solved the problem - however, I want to be sure that I understand the
problem before I move on. Before I detail the problem, this problem
requires some understanding of threading concepts.
Basically, the class contained both a PictureBox object as well as a
corresponding Image object (they both had a copy of the same picture).
The following was used to access the...
|
by: Coder |
last post by:
Howdy everybody!
How do I do the following...
while (myVary != true){};
Obviously I do not want to use 100% of the processor to stay in this
infinite loop till myVar == true. But wait do I do?
Thanks yal!
|
by: Perecli Manole |
last post by:
I am having some strange thread synchronization problems that require me to
better understand the intricacies of Monitor.Wait/Pulse.
I have 3 threads. Thread 1 does a Monitor.Wait in a SyncLock block
protecting a resource. Thread 2 and 3 also have a SyncLock block protecting
the same resource and after executing some code in their blocks they both do
a Monitor.Pulse to hand of the locked resource back to thread 1.
While thread 1 has...
| |
by: Pexi |
last post by:
Hi,
we have a component developed with VB6 (compiled as a single threaded dll),
which we have used as Application level object for several years in classic
asp without problems. Yet now, when we are trying to use this same component
in Win2003 + IIS6 environment, we get following error:
-----------
Application object, ASP 0197 (0x80004005)
Cannot add object with apartment model behavior to the application intrinsic
object.
|
by: Bill Nguyen |
last post by:
below is the error message I received when about 2/3 of the process is done.
Where in my code I sould look for?
Thanks
Bill
---------
The CLR has been unable to transition from COM context 0x1afa18 to COM
context 0x1afb88 for 60 seconds. The thread that owns the destination
|
by: Nayan |
last post by:
Hi,
If I make a call to function which is in external library, and it goes
into wait sate.. disabling my app to proceed further, how can I break
this state elegantly? So far, I had to kill my process.
Someone suggested to code multi-threaded app in which one can monitor
other and if one goes into locked state, other kills it.
It sounds okay, but I don't know how to do it. Any code sample or
|
by: Deepak |
last post by:
I am programing a ping application which pings various centers . I
used timer loop and it pings one by one.
Now when i finish pinging one center it should wait for the
ping_completed function to be executed and then continue pinging
another certer.
The ping_completed function is called on completion of ping by the os
and i have no control on it .
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |