如何终止进程(EXCEL上传后). [英] How to kill Process(After EXCEL uploading).

问题描述

大家好，
我正在将.xlsx文件上载到sql server 2008数据库，第一次将.xlsx文件上载到数据库是成功的，但是在第一次上载后，给出了用户代码未处理COMException的异常.消息为"RPC服务器不可用.(HRESULT的异常:0x800706BA)"


我正在使用cod eto杀死进程，如:
File.Delete("FilePath");

Hi All,
I am uploading .xls file to sql server 2008 database, First Uploading .xlsx file to database is successful but after first uploading it gives exception of COMException was unhandled by user code. with message "The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)"


i am using cod eto kill process like :
File.Delete("FilePath");

Process[] prs = Process.GetProcesses();
       List<int> excelPID = new List<int>();
       foreach (Process p in prs)
           if (p.ProcessName == "EXCEL")
               excelPID.Add(p.Id);

       prs = Process.GetProcesses();

       foreach (Process p in prs)
       {
           if (p.ProcessName == "EXCEL" && excelPID.Contains(p.Id))
           {
               p.Kill();
           }
       }

//以及我在下面的代码中使用的..

//as well as I used below code also..

foreach (Process p in Process.GetProcesses())
       {
           if (p.ProcessName == "EXCEL")
               p.Kill();
       }

我没有得到确切的问题.提供解决方案.

谢谢.

m not getting what is exact issue.Provide solution.

Thanks.

推荐答案

检查下面的链接.

http://july-code.blogspot.com/2008/11/kill-excelexe-process-in-c-net.html [

Check the below link.

http://july-code.blogspot.com/2008/11/kill-excelexe-process-in-c-net.html[^]

这篇关于如何终止进程(EXCEL上传后).的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！