I have an asp.net application, which opens an excel file and reads it content. If user closes the application or the page when the excel file reading in progress, i want to kill the Excel process (which is opened by the current instance.
View 17 RepliesIs it possible to kill the current running process in order to run a new process in asp.net? The problem I have is that when a report is running, the user may click on other process, then the process of report should be finished in order to run another process. So is it possible to kill the current process?
View 1 Repliesi am using icrosoft.Office.Interop.Excel to read the excel file datas. i need to kill the "EXCEL" process if any runtime error occur or any other "EXCEL" process running before read the excel data. I am using this code to kill the process.
private void KillProcess(string processName)
{
system.Diagnostics.Process myproc = new System.Diagnostics.Process();
//Get all instances of proc that are open, attempt to close them.
try
{
foreach (System.Diagnostics.Process thisproc in System.Diagnostics.Process.GetProcessesByName(processName))
{
if (!thisproc.CloseMainWindow())
{
//If closing is not successful or no desktop window handle, then force termination.
thisproc.Kill();
}
} // next proc
}
catch (Exception Exc)
{
throw Exc;
}
}
Now, My question is if the multiple users running the web application with different sessions then it cause problem right. because this method close all the "Excel" process that are currently running. how to kill the excel process for the particular session.
I have window application and I want to use same instance of opened forms from application. I know this is possible with singleton pattern so if you have code example of singleton pattern then
View 2 Replieshow to get the names of excel files opened on the Client machine and populate it in a ListBox? If somebody did it please reply to this or give some pointers / web site links to me, so that i will read and try to use for building my code.
View 1 RepliesFailed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
View 2 RepliesI am generating a new report page by using the following code.
[Code]....
But, the above script is used in more than 20 parameter page which ultimately always open the same Report_preview.Aspx page.
What i want to check while running the above script is "give a warning if the Report_preview.Aspx is already opened"
Basic question - is it possible to access the current Page from a static class in ASP.NET?
I am thinking no, as google turns up no results.
In fact, I DO NOT want to ask a question but to share one solution to this. One cause of this problem is you did not register your sql express on iis.I installed .net 3.5 sp1, then ran aspnet_iis -i, then installed sql express 2005 advanced. Yes, here came the notorious alert. So, I ran aspnet_regiis again and everything is OK.Run aspnet_regiis before you have installed sql express.
View 1 RepliesI have a webservice, it has few webmethods. when i create a client proxy and invoke the methods to check its response, i am getting this error. Can someone tell me what things can i check to know the cause of this? The error is not saying much hence blocked on this.
View 1 RepliesI want to set timeout of particular session.for e.g. in web.config session timeout is set to 30.
when user enter in particular page say test.aspx we create new session say session("a")=3.
after that user enter to new page say xyz.aspx .
CASE 1:
I want to set timeout of session("a") to 10.
CASE 2 :
I want to destroy this particular session (i.e session("a")) not all the sessions.
CASE 3 :
I don't want user can use session("a") on this page but other session's should be accessible.
I need to pass the current url in the website to Excel.
Case is
Step 1: I got a button in a ASP page, click a button to close the window and grab the current url
Step 2: create a variable in Excel-addin projct (C#, .net4, vs 2010) which is used to save this url.
Step 3: Pass this url from asp web page to c# Project.
How to kill the session when Browser closed/page closed.
View 1 RepliesI've developed a popup email .aspx used on our intranet based web app that is auto generated with .pdf's attached. I'm developing with VS 2008 ASP.Net 3.5 C# and System.Net.Mail.MailMessage. I can create and send the email with no issues. The problem is with any attempt to open or delete the attachments I get the above error. The .pdf's a copied with the following code:
FileStream fsr = new FileStream(inFilename, FileMode.Open, FileAccess.Read, FileShare.Read);
BinaryReader reader = new BinaryReader(fsr);
byte[] bytes = new byte[fsr.Length];
reader.Read(bytes, 0, bytes.Length);
FileStream fsw = new FileStream(outFileName, FileMode.Create, FileAccess.Write, FileShare.Write);
BinaryWriter writer = new BinaryWriter(fsw);
writer.Write(bytes, 0, bytes.Length);
// clean up
writer.Flush();
writer.Close();
writer = null;
fsw.Close();
fsw.Dispose();
fsw = null;
reader.Close();
reader = null;
fsr.Close();
fsr.Dispose();
fsr = null;
Later after sending the email I:
mailMessage.Dispose();
mailMessage = null;
foreach (string fileName in attachments)
{
if (File.Exists(fileName))
File.Delete(fileName);
}
The error occurs at: the File.Delete(fileName);
how I can delete or reopen these files after sending the email?
I have a GridView populated by an ObjectDataSource. I also have several DropDownLists filtering the ObjectDataSource. I found a link providing a way to export a DataSet (or DataTable) to Excel here:
http://msmvps.com/blogs/deborahk/archive/2009/07/23/writing-data-from-a-datatable-to-excel.aspx
ow I can ensure that filters applied to the ObjectDataSource when the method is called are applied. In short, how can I ensure what the UI is displaying is what the file will include when exported?
My code is that I want to create a log file and log it upon a new user browsing the site. However, what i did was I put in a 6 second delay and then used another browser to access the page. And it threw an Exception saying it is being used by another process which is true. So how come I set it so that, if IT is being used by another process, WAIT and retry every 500 milliseconds until it becomes free/available?
here's the code:
protected void Page_Load(object sender, EventArgs e)
{if (!IsPostBack) // if this is the first time page loads, set k to 1
{ lognewuser();
}}
[Code]....
I have a Gridview that displays a huge list of products. On Client click of a select button in the grid I fill textboxes with the selected row's data. When i do this, I want to stop the Grid from Binding in Javascript. Is this a possible feat? Now the Gridview is in an updatepanel. Perhaps i could stop it from updating???
View 2 RepliesIn a project when user click a button, some data is gotten and written to an excel instance by interop library.
Now, I want that: When excel instance get all data, a save as dialog box muste be open and save this excel instance to user specified path.
Is there a way to do it?
[Code]....
My javascript code is calling a asp.net webservice, so i have a call to the webservice something like this:MyWebservice.GetData(param, ResponseReceived, ResponseTimeOut, ResponseError);When the webservice returns data, ResponseReceived method is called.However sometimes the user might navigate to another url before the webservice call actually returns, in such a scenario FireFox throws an Error saying 'An error occured oricessubg the request. The server method GetData failed'So my question is how can i kill the async call when the user navigates to another page or makes another request to the webservice? I know in a normal XMLHttpRequest i could have called Abort method, but not sure how to make it work with the above webservice proxy.
View 2 RepliesI am developing one aspnet application in that i am using Sessions. if user login into the application and click on logout here i am closing session.
suppose if the user doesn't click on the logout and he close the browser. how to kill the session when user closed the brower without logout
I want to show a popup about browser compatibility to the users visiting my website. I have used the popup in about 5 pages and it would be annoying for the users to see the same popup for more than once when they visit my website. So I am thinking to use a session and kill it when the user closes the poup. IT should not be shown until the browser is restarted.
View 4 RepliesI've written a aspx.net(C#) page that after the user has done what they do on the page they hit a Submit button. The Submit button
1) takes the work the users was producing on the page and writes it to a file.
2) attempts to execute a batch file.
The call to the batch file is executed via:
protected void Execute123EDI()
{
try
{
string File = @"c:80sAdminSendV80s.bat";
lblCancelled.Text = lblCancelled.Text + File;
Process proc = new System.Diagnostics.Process();
proc.StartInfo.UseShellExecute = false;
proc.StartInfo.LoadUserProfile = false;
proc.StartInfo.UserName = "administrator";
proc.StartInfo.RedirectStandardOutput = true;
System.Security.SecureString secPass = new System.Security.SecureString();
string paswd = "123abc";
for (int i = 0; i < paswd.Length; i++)
{
secPass.AppendChar(paswd[i]);
}
proc.StartInfo.Password = secPass;
proc.StartInfo.FileName = File;
proc.Start();
FileStream fs = new FileStream(@"c:80sAdminSendV80sOutput.log", FileMode.Append);
StreamWriter sw = new StreamWriter(fs);
sw.Write(proc.StandardOutput.ReadToEnd());
proc.WaitForExit();
sw.Close();
proc.Close();
}
catch(Exception ex)
{
lblDebug.Text = lblDebug.Text + ex.Message + "<br/>";
}
If I watch the processes tab in Task Manager on the web server I see "cmd.exe" under the context of 'administrator' but it just hangs. For test purposes c:SendV80s.bat: copy c: oot.ini c:zzz.txt
If I logon onto the webserver's console and execute SendV80s.bat it works and exits without issue. But when I execute the same batch file via the Submit button it gets stuck executing in Task Manager/Process. I believe this has something to do with the fact that cmd is not running in a full environment/desktop context. I just noticed this on the actual console of the webserver (not in my RDP console but console 0 instead)
A pop-up box stating: CMD.exe Application error The application failed to initialize properly (0xc0000142). Click OK to terminate the application. And when I click on the OK button my ASPX page's WaitForExit is satisfied and the continues processing normally.
How to set session timeout and clear session in web.config and login.aspx ? And when we close the web application , the session must be cleared? I have use session.abandon as per below but is not working.
protected void btnLogout_Click(object sender, EventArgs e)
{
Session.RemoveAll();
Session.Abandon();
Response.Redirect("LoginPage.aspx");
}
I know that similar questions have been asked all over the place, but I'm having trouble finding one that relates directly to what I'm after.
I have a website where a user uploads a data file, then that file is transformed and imported into SQL. The file could be up to 50mb in size, and some times this process can take 30 minutes or sometimes even longer.
I realise I need to palm off the actual work to another process, and poll that process on the web page. I'm wondering what the best approach would be though? Being a web developer by trade, I'm finding all this new Windows Service stuff a bit confusing, and I just wanted somewhere to start.
So:
Can I do / should I being doing this with a windows service? if so, how?
Should I use WCF? If this runs under IIS, will I have problems with aspnet_wp.exe recycling and timing out my process?
clarifications
The data is imported into sql, there's no file distribution taking place.
If there is a failure, it absolutely MUST be reported to the user. The web page will poll every, lets say, 5 seconds, from the time the async task begins, to get the 'status' of the import. Once it's finished another response will tell the page to stop polling for status updates.
queries on final decision
ok, so as I thought, it seems that a windows service is the best idea. So as to HOW to get it to work, it seems the 'put the file there and wait for the service to pick it up' idea is the generally accepted way, is there a way I can start a process run by the service, without it having to constantly be checking a database table / folder? As I said earlier, I don't have any experience with Windows Services - I wondered if I put a public method in the service, can I call it somehow?
I'm working on an ASP.net app I'm trying to execute a process remotely , using System.Diagnostics.Process class here's my code:
ProcessStartInfo startInfo = new ProcessStartInfo(@"C:TestCommand.exe");
startInfo.Domain = "myDomain";
startInfo.UserName = "MyUserName";
SecureString sec = new SecureString();
foreach (char item in "MyPassword")
{
sec.AppendChar(item);
}
sec.MakeReadOnly();
startInfo.Password = sec;
startInfo.UseShellExecute = false;
Process.Start(startInfo);
I keep receiving an exception with the message "Logon failure: unknown user name or bad password". Im absolutelly sure that i'm submiting my correct username/pwd