Execute Sql Script And Not Wait For Completion?
Aug 26, 2010
I have a sql stored procedure that runs for about 3 minutes, I am looking to execute this stored procedure from asp.net, but I know that if I do, that asp.net will most likely time out.
I'm thinking of just creating a job within sql to have it execute that stored procedure, and have asp.net call a stored procedure to call that job. I have a table that is updated when the stored procedure starts, and when it ends.
My application will use this to determine when the script has finished, however, I wanted to know if there is another way to run the stored procedure and not have it wait for it to finish to push a response back.
I just want to know if there is a more efficient way to do this, or if I should just stick to creating jobs for scripts that take forever to run.
View 3 Replies
Similar Messages:
Feb 27, 2010
I have written a code to download a file . I require that if the file is successfully downloaded on the clients then only certain code should be executed otherwise not.
View 4 Replies
Mar 21, 2011
1. How can I create a delay in C#.I know Thread.Sleep(0) but it is blocking my GUI.2. Also I need to pause the execution of the normal flow until a function return a result.
View 13 Replies
Feb 4, 2010
What I'm trying to do is fill in a questionnaire, and have the option to not complete it then it automatically saves, once clicked on "Save" button. However, what I want to search for is previously non-completed questionairres.
Would I have a "status" field in the questionairre table to trigger either "completed"/ "non-completed" when the "Save" button is clicked (in the event of non completed questionaires? How is this normally done?? Im sure there are a hundred and one different ways to do it!
View 4 Replies
Jun 22, 2010
Detecting Page load Completion? How could we do this using jscript or jquery, would it be possible? Kindly give your views and ideas. I have an asp.net web page, which is huge and takes time to load. If the user clicks on any buttons on the page, before the page completes it's load, we get error messages. Since some of the hidden field values in the page, have value=0 because the page did not complete it's load. I hope I was clear with my question. Meanwhile I need to work on improving my code to process quick.
I do have an update panel, on my page.
View 1 Replies
Feb 4, 2011
I am using a GIF image in ProgressTemplate . Now I want to show percentage of completed (like 20% completed) while loading.
View 3 Replies
Dec 27, 2010
i have an aspx with the following code (i don't want to bother you with unecessary additional code but basically the page will contact a remote proxy server and try to authenticate some requests and then redirect back to another page based on the response status)
[Code]....
How can i display a loading gif image before completion of the code behind code.
ps: if you can post some real code examples, not just concepts and how to do... i've tried many things so far without success, including pre-loading images using javascript and MS AJAX toolkit stuff.
View 8 Replies
Aug 30, 2010
I'm using ASP.NET 3.5 (c#) with SQL Server 2008 server. Recently, I started getting error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.".
After looking at forums for solutions, I added the below common code to my application.
[Code]....
However, intermittently, I'm still getting the timeout error. I added the logging to see where error is occuring. And found that before executing one of the query, it is giving this error. Now, my assumption is that I should have received this error after runnign query for 600 seconds (10 minutes) since I set it in the above function. But the timeout error is occuring instantaneously within 1 second itself. In the log, I printed one line above & after the query to identify how much time it would take. Surprisingly, the log says that 9:00 AM "Before query execution" & at 9:01 AM "timeout expired...."
View 3 Replies
Mar 17, 2010
There are a million examples of how to generate an Excel file from a web page. I've done that and it is no problem.
What I haven't been able to work out is: how can I update the screen to let the user know how many rows were exported?
It seems to me that after you've done your:
[Code]....
then pumped the data our, then done the:
[Code]....
there's no way to cause a postback or do any subsequent server-side or client-side processing on the webpage with the Export button.
I've tried a whole bunch of different methods, but have not found one that allows me to "play on" after the export has finished with the Response.End() call.
View 2 Replies
Feb 15, 2011
I'm trying to understand how to execute AJAX animation on an asp button that has to execute code on Postback. In other words, I have button with code behind that needs to be excuted, but at the same time want to be able to have one of animation extenders be applied to it. I understand that I need to use the BeginRequest Event, I'm just not sure how, or which javascript commands to use to call the ajax animation so the postback will still occur.
View 5 Replies
Mar 10, 2011
I am looking through a sql stored procedure which I might need to update in the near future. Basically the stored procedure is about 20 lines long. The stored procedure first builds a query
and stores it in a variable named "@Sql". And then for the last two lines of the stored procedure it appears that the big sql statement stored in "@Sql" is executed by using the "EXEC" command. See below. What is confusing though is that the query appears to be exectuted twice? Why was the query written in this way. Don't both lines do the same thing? Why is it being done twice? Could this possibly be a mistake on the
part of the person who wrote the query. Below are the two lines I am talking about?
EXEC sp_executesql @sql
EXEC (@sql)
View 4 Replies
May 20, 2010
Error occured: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
View 3 Replies
Jan 22, 2010
How can we add any wait image or progress bar when we upload a big size file to upload and it take several minutes to upload a file.
I want to show any Image or progress bar.
View 5 Replies
Mar 29, 2011
I'm currently using ASP.net. I wonder what would I need to do to let the browser wait for 3 seconds so my users can read the text "Customer Successfully Added" before turning to another page? I have attached my code as follows.
Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim db As New DatabaseClass
db.addProfile(txtLN.Text, txtFN.Text, txtUsername.Text, txtPassword.Text, txtAddress.Text, txtZip.Text, txtPhone.Text, txtEmail.Text)
lblMessage.Text = "Customer Successfully Added"
End Sub
In addition, I'm not sure how to utilize MSDN. For me, its information overload, I'm wondering how to go about finding the solution on MSDN so i would be able to solve my problems in the future.
View 3 Replies
Feb 1, 2010
how to create a popup box that is used as a wait box? This box has a circle in the middle that has a pointer that changes colors and spins when waiting for the next window or page to appear.Is this AJAX or a programming option?
View 3 Replies
May 3, 2010
i am calling a function which is creating a PDf. now i want to wait that function to call untill the pdf get created for 10 seconds. My code is something like this
MakePDF.PDFCreation(MyPath, Type, TypeID.ToString()); it is creating a PDF file.
after that i want to open the pdf automatically in new window. I can do this but how can i put this function to wait untill PDF get created,
View 1 Replies
Feb 1, 2010
In my web application (ASP.NET) I have a block of code that uses HttpWebRequest to make a call to a REST service and continue execution. Right now it's taking longer than I would like to complete the full web request. The thing is that what the REST service returns isn't useful. Ideally I would like to send an Async web request to the REST service and then NOT wait for a response. The problem is that I've tried it out using request.BeginGetResponse(New AsyncCallback(AddressOf myFunc), Nothing)
To start an async request and instead of NOT waiting (which I would assume would be the default behavior of an async request) it continuously executes the callback function before executing the next line of code after BeginGetResponse.I'm suspecting that ASP.NET may convert it to a sync request when it's within a web application. I'm led to believe this because there's a IAsyncResult result object that is passed into the callback function and when I examine its CompletedSynchronously property it's always set to true.if it's possible to do an async HttpWebRequest (with no wait) from within an ASP.NET web application or is it always converted to a synchronous request?
View 2 Replies
Mar 30, 2010
I need to run the HttpContext.Current.Server.Execute method in my ASP.NET application. This application has a WCF operation that does some processing. Currently, I am to do my processing correctly from within my WCF operation. However, I would like to do this asynchronously.
In an error to attempt this asynchronously, I tried running Server.Execute in the DoWork event handler of a BackgroundWorker. Unfortunately, this throws an error that says
"object reference not set to an instance of an object" The HttpContext element is not null. I checked that. It is some property nested in the HttpContext object that appears to be null. However, I have not been able to identify why this won't work. It happens as soon as I move the processing to the BackgroundWorker thread.
My question is, how can I asynchronously execute the Server.Execute method?
View 1 Replies
Apr 30, 2010
I have a 'Generate' button on form that does some file processing. It creates files, zips it etc etc. I would like to add some wait time (3-5 seconds) in the logic so as to complete the file processing logic. What happens right now is visitor clicks the button to generate those files and clicks another button to download. When they try download button many times the files are not created as in processing. So it fails to download. The only way I can ensure it does processing for longer period to allow completion.
View 7 Replies
Nov 5, 2010
How can I use JQuery to be able to show some kind of "Please wait"-dialog when a user clicks a button? I want to be able to show for example an alert saying "Your request is being transmitted" while the request is sent to the server and processed through the controller (I use MVC). Once the response comes back, I want to reload the page with the viewmodel returned from controller action, just as usual. Is this possible to do with JQuery or ASP.NET AJAX?
function Save()
{
alert("Please wait);
//make the request async and reload the page when it returns...
}
View 1 Replies
Mar 17, 2010
I'm trying to create a simple portfolio page. I have a list of thumbs and an image. When you click on a thumb, the image will change.
When a thumbnail is clicked, I'd like to have the image fade out, wait until the image is loaded, then fade back in. The problem I have right now is that some of the images are pretty big, so it fades out, then fades back in immediately, sometimes while the image is still loading.
I'd like to avoid using setTimeout, since sometimes an image will load faster or slower than the time I set.
Here's my code:
$(function() {
$('img#image').attr("src", $('ul#thumbs li:first img').attr("src"));
$('ul#thumbs li img').click(function() {
$('img#image').fadeOut(700);
[Code].....
View 3 Replies
May 12, 2010
I'm calling a web service called GetTooltip from inside Javascript. However, since the web service is called asynchronously, it doesn't wait until I get the return value from the web service, before it continues again. This is a bit of a problem for me, since the web service is in a for-loop. How do I make the Javascript wait until I hear back from the web service, before letting Javascript continue the for-loop?
[code]....
View 3 Replies
Mar 7, 2011
I want to show a wait cursor on Text Changed event till the data is fetched from the server.And then reset the cursor to default. Should work in ie6.
View 2 Replies
May 7, 2010
I'm using the standard ASP membership provider
The first user of my site per day (or if nobody has used the site for awhile) gets a pretty long wait to bring up login.aspx. Subsequent users, site comes up immediately.
I understand this is an IIS setting to save resources. (I'm on IIS6). What is the community doing about this problem? I've read about writing programs to keep the site alive by hitting it every 20 min, but there must be a better way. One of my project is for a small business to provide order information for their customers -- gets used every day but not that many times per day.
Is this the reason most developers will have the first page as index.html then you click to login from there while it says "please wait for login" or similar?
View 3 Replies
Jan 13, 2011
I have a button that needs to check if a contact exists.I have used the Jquery ajax function to do this and I do successfully gind out if the contact exists or not.However I cannot find a way for the javascript code to wait until the ajax has finished so I can return true/false to the button for it to continue server side function. I.e.
[Code]...
View 4 Replies
