我目前在安装部署项目中是这样写的
private void CreateKillSpId()
{
System.Diagnostics.Process sqlProcess=new System.Diagnostics.Process();
string cmd = "";
string cmdKillSpId = "";
string connString="server="+dbServer+";uid="+dbLoginId+";password="+dbPassword;
string scriptPath = "";
scriptPath = targetdir+@"\"+KillSpIdsqlScriptFileName;
cmdKillSpId = " -S "+dbServer+" -U "+dbLoginId+" -P "+dbPassword+" -d master -i "+scriptPath;
sqlProcess.StartInfo.FileName="osql.exe";
sqlProcess.StartInfo.Arguments=cmd;
sqlProcess.StartInfo.WindowStyle=ProcessWindowStyle.Hidden;
sqlProcess.Start();
sqlProcess.WaitForExit();//等待执行
sqlProcess.Close();
DeleteSqlScript(scriptPath);
}
private void CreateKillSpId()
{
System.Diagnostics.Process sqlProcess=new System.Diagnostics.Process();
string cmd = "";
string cmdKillSpId = "";
string connString="server="+dbServer+";uid="+dbLoginId+";password="+dbPassword;
string scriptPath = "";
scriptPath = targetdir+@"\"+KillSpIdsqlScriptFileName;
cmdKillSpId = " -S "+dbServer+" -U "+dbLoginId+" -P "+dbPassword+" -d master -i "+scriptPath;
sqlProcess.StartInfo.FileName="osql.exe";
sqlProcess.StartInfo.Arguments=cmd;
sqlProcess.StartInfo.WindowStyle=ProcessWindowStyle.Hidden;
sqlProcess.Start();
sqlProcess.WaitForExit();//等待执行
sqlProcess.Close();
DeleteSqlScript(scriptPath);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货