Cancel A Long Running Database Insert / Update Operation From UI When Operation Is Being Performed By A Windows Service?
Mar 7, 2010
in my case, It is the windows service which in running the long running insert/update on a table and I need to cancel the operation from my ASP.NET application. In the above link Burnsys suggests that one should kill the Sql server session. Is that really only way and a goood practice to do this? Also, in the same poset can use SqlCommand.Cancel to cancel. However, I am not sure how can I cancel the command from the windows service from ASP.NET application.
View 1 Replies
Similar Messages:
Jan 27, 2010
My application is a asp.net 3.5 running on iis 6 (windows 2003)
This application is serving 1000's of users daily (100-500 users online).
I want to send an email newsletter to customers weekly.
Around 200,000 emails every time.
This is the code im using:
ThreadPool.QueueUserWorkItem(new WaitCallback(AsyncProcessMailerQueue), null);
private static void AsyncProcessMailerQueue(object data)[code]....
When testing this locally (on my dev machine) i see the application is working alot slower.
Is there a better way to write this code? Should i use ThreadPool.QueueUserWorkItem or create a new thread using Thread t = new Thread(new ThreadStart(DoWork)); ? Will it be better to create a totally seperate application for the purpose of sending the newsletters. will that help if ill run this application on the same machine?
i've seen other posts here talking about ThreadPool vs Thread but its seem no one is sure which is better.
View 3 Replies
Jul 23, 2010
When an ASPX page needs to make a call to a potentially long-running operation (lengthy DB query, call to a remote webservice, etc.), I use RegisterAsyncTask, so the IIS worker thread is returned to the pool, rather than being tied up for the duration of the long-running operation. However ASMX webservices don't have a RegisterAsyncTask function. When an ASMX webservice needs to call a potentially long-running operation, how can I implement the same behavior as RegisterAsyncTask? Note: the ASMX webservice is implemented as a script-service: returning json to a direct jQuery/ajax call. Therefore, I cannot use the "BeginXXX" approach described by MSDN, since that implements the asynchronous behavior within the generated client-stub (which isn't used when calling the webservice directly via ajax). EDIT: Adding source code: implemented the BeginXXX/EndXXX approach listed in John's answer. The synchronous "Parrot" function works fine. But the asynchronous "SlowParrot" function gives an internal server error: "Unknown web method SlowParrot"
WebService1.asmx:
[code]....
View 2 Replies
Mar 24, 2011
heavy operation which takes long time to be completed in my asp.net application. I don't want to run the entire operation in one request which may result in a TimeOut error. Instead I want to invoke the operation in a separate thread and poll for the result every x seconds. How can I do this?If the operation gets completed I need to register a script in the ajax postback to hide the loading panel and show the content. However I'm not able to register new scripts and invoke it during ajax postbacks.
View 2 Replies
Sep 30, 2010
I am experiencing a request timeout from IIS when I run a long operation. Behind the scene my ASP.NET application is processing data, but the number of records being processed is great, and thus the operation is taking a long time.
However, I think IIS times out the session. Is this a problem with IIS or ASP.NET session?
View 1 Replies
Aug 13, 2010
Wondering if there is a performance difference between letting a long running process hang in asp.net vs running the process via a windows service. I have done this once before and the windows service was much quicker and didnt bog down my system, whereas the asp.net request seemed to wreak havoc.
View 1 Replies
Aug 4, 2012
I need to dispay confirm box on server Side.. senario is like Im Trying To upload Image During Upload Im Checking some properties like Image type,image size, etc.. While Uploading i want to check properties like
if(type=="xxxx")
{
confirmbox(" ");
if(confirmvalue=="yes")
{
next condition
}
else
{
exit ;
}
}
like this i want check different properies of file.. how can i do this
View 1 Replies
Jan 12, 2010
I have a long-running WCF service that I need to call, but I would like to do is to open modal window (modal popup extender) that simply shows progress and stops the user from interacting on the page until the service returns. What I was trying to do was the following:
1. Click button to activate the process which calls a method in my code-behind.
2. This method opens my modal panel with some pretty animation.
3. I call my WCF service asychronously so that the UI will refresh.
4. Service ends which calls my delegate I setup.
5. My delegate method would then refresh the page with results, and dismiss the model popup.
View 1 Replies
Dec 10, 2010
I did some service operation in mywcfdataservice.svc Now I have to use the service operation in my controller but I don't find them.I can use:
Entities2Voice context = new Entities2Voice();
and so I can read the table of my db, but I didn't find the way to see sevice operation.I have my model.edmx to use sql db and the code in mywcfdataservice.svc works right. I can call the service operations from my browser and they work.I try to add service reference to my .svc file, to use it as a service, but when I press ok button after some seconds, I take an error (is in Italian):Il documento HTML non contiene informazioni per l'individuazione del servizio Web.I metadati contengono un riferimento che non può essere risolto: 'http://localhost:2873/WcfDataService2Voice.svc'.Il tipo di contenuto text/html; charset=utf-8 del messaggio di risposta non corrisponde al tipo di contenuto del binding (application/soap+xml; charset=utf-8). Se si utilizza un codificatore standard, verificare che il metodo IsContentTypeSupported sia implementato
correttamente. I primi 1024 byte della risposta erano: '
View 3 Replies
Jan 5, 2011
In my application i am having nearly 10 lacs row of data in a dataset with the columns like customer name,address,id,etc.. I have to update a single customer detail in the dataset using id.Is there any way for updating a customer details without using loops?
View 2 Replies
Mar 16, 2011
I want insert data's via Datagrid,How Can Do That
View 2 Replies
Mar 23, 2010
This is the first time i am using ms access database for the c# asp.net .
I am getting the following error when i try to insert the record.
Operation must use an updateable query.
[code]....
View 2 Replies
Dec 15, 2010
I am inserting mortgage loan scenarios in via GridView table. Let's say $100K loan with FICO score 700 in state of MN.
Sometimes I want to apply the same scenario to multiple states rather than Inserting one row at a time. I figured a Listbox with SelectionMode="Multiple" option would be to way to go.
Here is some code snippets:
[Code]....
View 7 Replies
Mar 17, 2011
I need to perform update operation in a datatable without using loops. Is there any way to perform update in a datatabel...
View 3 Replies
Jun 20, 2012
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" ForeColor="#990000"
AutoGenerateEditButton="True" onrowupdated="GridView1_RowUpdated"
[Code]....
these are my avaiable controls on the page
now on clicking the update button
i want all the values to be displayed on textboxes as above mentioned
View 1 Replies
May 12, 2010
I have a detailsview which has a button for insert and edit depending on mode plus a cancel button. What I am looking to do, is to use the cancel button to stop any insert or update to the database if clicked.
View 2 Replies
Aug 6, 2012
I want to do one thing that when i edit the gridview then it will not go back to main form for editing.it will remain there in the form for the row editable.
i-e when i edit any row then it will be editable on the gridview.
<asp:GridView ID="noticeDetails" runat="server" BorderWidth="1px" AutoGenerateColumns="false" PageSize="10" Width="10%" CellPadding="10"
AllowSorting="true" AllowPaging="true" AutoGenerateEditButton="true" onrowediting="noticeDetails_RowEditing"
onrowcancelingediting="noticeDetails_Rowcancelingediting"
[CODE] ...
View 1 Replies
Jan 12, 2011
I have two textBox, one button and one gridview. In one texbox, I enter a value, click the button to add this entry to the gridview and the footer is computing the sum as i add more entries to the gridview.
I also have a textbox outside the gridview that will hold an amount, now I want to perform an operation like...(txtOutsideGridview - gridviewEntry1 - gridviewEntry2), and display the result of this operation inside the footer of the gridview, instead of the sum. How do I go about doing this?
So far all I have been able to do is sum up the total of entries within the Gridview, but that is not my desired operation...here is what my current code looks like
[Code]....
View 2 Replies
Jun 6, 2010
i hv been trying to perform insert operation on Oracle 10G database using asp.net 3.5. So far i m new to oracle and i m confused as back end queries seems different froms sql server. this code is in submit button click event:-
[code]....
View 2 Replies
Jan 11, 2010
I am working on Edit operation for dropdownlist box using linq to sql in asp.net mvc.During edit operation i could retrieve it from database but i am not able to restore the selected value back to the database.
View 2 Replies
Dec 20, 2010
These types of exceptions always irritate me because they are almost impossible to reproduce consistently and have almost no documentation other than the cryptic error itself to have any idea on how to fix the problem. So I have a Windows Service that makes a call to a .asmx web service over https on a polled interval every 20 minutes. Once in a great while the following exception message is returned:
Message: The underlying connection was closed: An unexpected error occurred on a receive.
Inner Message: System.IO.IOException: The decryption operation failed, see inner exception. ---> System.ComponentModel.Win32Exception:
The specified data could not be decrypted --- End of inner exception stack trace --- at
System.Net.Security._SslStream.ProcessReadErrorCode(SecurityStatus
errorCode, Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest, Byte[] extraBuffer) at System.Net.Security._SslStream.ProcessFrameBody(Int32 readBytes, Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) at
System.Net.Security._SslStream.StartFrameBody(Int32 readBytes, Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security._SslStream.StartFrameHeader(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security._SslStream.StartReading(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.Security._SslStream.ProcessRead(Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest) at System.Net.TlsStream.Read(Byte[]
buffer, Int32 offset, Int32 size) at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)
So from reading the above message there was an error on receive and the data could not be decrypted. The does not occur consistently, so I don't have a good way of reproducing it. I also lack at low level messaging knowledge and I feel that this is the answer behind this exception; i.e. dropped packets and an incomplete message not appearing to be the same message as sent from the service or something. Any .asmx gurus out there that can give insight and possibly prevention suggestions for the above issue?
View 2 Replies
Jan 12, 2011
I would like to makea windows service. whenever the user of my ASP.NET application has to do a time-consuming task, the IIS would give the task to the service which will return a token(a temporary name for the task) and in the background the service would do the task. At anytime, the user would see the status of his/her task which would be either pending in queue, processing, or completed. The service would do a fixed number of jobs in parallel, and would keep a queue for the next-incoming tasks. In addition there would be a WinForms application for system administrator that would allow adding special ADMIn tasks such as "Clean orphaned files" or "archive data of inactive users".
Can you point me to something that can jump start me on this as a whole concept - I know I can google for windows services and I am able to do it myself from scratch but time is of the Essence so maybe you know of something that is already there and i can use block to build out of.
View 1 Replies
Aug 25, 2010
I have Requirement to update the label text as we are processing the code (Long running).
Example:
I have Label and button on aspx page.
On button Click Iam calling the AppCode which is going to do long work for me.
I want to update the label text from the appcode (which should reflect in the page then and there.)
I have tryed to pass the text value to the label but it shows the changed text only after the event for the button click is finished.
I tryed using timer but as soon as i click the button the refreshing stops.
I tryed progress template and UpdateProgress without success. (I know we can update at the start and end of proccess using this)
I dont want to use iframe (I know we can do using iframe)
View 3 Replies
Jun 16, 2010
I've developed a web application to accept video file uploads and then pass them to a backend service on an external server. The application runs without error on the visual studio debugging webserver, but once on a production iis 6 or 7 server, yields a timeout error at about a consistent amount of time into handling a large upload. Specifically, it errors in the middle of transferring the video file to the external server, once the application has successfully received it from the client. I'm aware of several timeouts to be configured related to the problem, and have done so. The application's web config has been tested with one or both of the following settings
<system.web>
<httpRuntime executionTimeout="9999999" maxRequestLength="2048000" />
</system.web>
and
<configuration>
<location path="default.aspx"> (the page at issue that's timing out)
<system.web>
<httpRuntime executionTimeout="9999999" maxRequestLength="2048000" />
</system.web>
</location>
</configuration>
And within the initialization of the webrequest made to the external server to send the video received from the client browser:
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(url);
httpWebRequest.ContentType = "multipart/form-data; boundary=" + boundary;
httpWebRequest.Method = "POST";
httpWebRequest.Timeout = System.Threading.Timeout.Infinite;
So with the execution time limits on both the webform as a whole and the connection made to the external server, I'm at a loss for what timeout is left unconfigured, or how to determine such, when I continue to get the following error: Unexpected error executing Brightcove Upload:...........................
View 3 Replies
Mar 29, 2011
Hello all. I created a class that runs fine when using it with web forms, however when i create a Windows service and try to run it I recieve a NullReference error. Im not sure what else to do since the class works fine.Here is a snippet.
The service
public partial class Service1 : ServiceBase
{
//Timer object
Timer RunTime;
QBridge bridge_object = new QBridge()
double test_interval = 40000; //test value
public Service1()
{
InitializeComponent();
}
protected override void OnStart(string[] args)
{
//Send email notification that intakes were pushed
//bridge_object.SendNotification(bridge_object.service_startedtext);
RunTime = new Timer(30000);
//set the elapsed event
RunTime.Elapsed += new ElapsedEventHandler(RunTime_Elapsed);
//RunTime.Interval = SetInterval(); //calculated interval
RunTime.Interval = test_interval; // test interval
RunTime.Enbled = true; //set timer to true
//QBridge bridge_object = new QBridge();
//bridge_object.SendNotification("start");
//SendNotification("start");
}
protected override void OnStop()
{
RunTime.Enabled = false; RunTime.Dispose();
try
{
bridge_object.SendNotification("stop");
}
catch (NullReferenceException nre) { System.Windows.Forms.MessageBox.Show("Error " + nre); }
catch (Exception er) { System.Windows.Forms.MessageBox.Show("Error " + er); }
//SendNotification("end");
}
//Included this to test locally. works fine when just calling the method
protected void RunTime_Elapsed(object source, ElapsedEventArgs e)
{
//SendNotification("run");
try
{
bridge_object.SendNotification(run);
}
catch (NullReferenceException nre) { System.Windows.Forms.MessageBox.Show("Error " + nre); }
catch (Exception er) { System.Windows.Forms.MessageBox.Show("Error " + er); }
}
public void SendNotification(string email_text)
{
MailMessage initial = new MailMessage();
initial.Bcc.Add(new MailAddress(""));
initial.From = new MailAddress("");
initial.Subject = "Web notification";
initial.IsBodyHtml = true;
initial.Body = email_text;
SmtpClient mailClient = new SmtpClient("192.168.1.1");
try
{
mailClient.Send(initial);
}
catch (Exception ex) { }
}
}
Class
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Net.Mail;
using System.IO;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace Intake
{
public class QBridge
{
SqlConnection con =
new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
private string login_error;
public QBridge()
{
}
public void SendNotification(string email_text)
{
MailMessage initial = new MailMessage();
initial.Bcc.Add(new MailAddress(""));
initial.From = new MailAddress("");
initial.Subject = "Web notification";
initial.IsBodyHtml = true;
initial.Body = email_text;
SmtpClient mailClient = new SmtpClient("192.168.1.1");
try
{
mailClient.Send(initial);
}
catch (Exception ex) { }
}
}
}
View 7 Replies
