判斷機器是否裝有MS-SQL

 

1. using System.Diagnostics;
2. using System.ServiceProcess;
4. protected void ChkSQLInst_Click(object sender, EventArgs e)
5.         {
6.             /*
7.             //通過進程判斷是否有SQL
8.             Process[] myProcesses;
9.             myProcesses = Process.GetProcessesByName("sqlservr");
10.             if (myProcesses.Length > 0)
11.                 lbInfo.Text = "Install OK,And Runing...";
12.             else
13.                 lbInfo.Text = "Not Install Or Not Run";
14.             */
15.             
16.             //通過服務判斷是否有SQL
17.             ServiceController[] service=ServiceController.GetServices();
18.             for (int i = 0; i < service.Length; i++)
19.             {
20.                 //Response.Write(service[i].ServiceName.ToString() + "---" + service[i].DisplayName.ToString() + "<br>");
21.                 //if (service[i].DisplayName.ToUpper() == "MSSQLSERVER")
22.                 if(service[i].DisplayName.ToUpper().Contains("SQL") && service[i].DisplayName.ToUpper().Contains("SERVER")) //兼容SQL2K,2005
23.                 {
24.                     lbInfo.Text = "Install OK";
25.                     break;
26.                 }
27.                 else
28.                 {
29.                     lbInfo.Text = "Not Install";
30.                 }
31.             }
33.         }