使用C#的winform控制数据库实例服务的运行状态

一、得到sqlserver的实例名

二、引用对应的程序集和命名空间

   using System.ServiceProcess; 

C#操作服务要用的类

ServiceController

声明类

private ServiceController serviceController = new ServiceController("MSSQLSERVER");

三、判断服务状态 

 serviceController.Refresh();
 switch (serviceController.Status)
 {
     case ServiceControllerStatus.ContinuePending:
         AddText("正在挂起. . .");
         break;
     case ServiceControllerStatus.Paused:
         AddText("服务已暂停");
         break;
     case ServiceControllerStatus.PausePending:
         AddText("正在暂停. . .");
         break;
     case ServiceControllerStatus.Running:
         serviceStatus = true;
         AddText("正在运行");
         break;
     case ServiceControllerStatus.StartPending:
         AddText("正在启动. . .");
         break;
     case ServiceControllerStatus.Stopped:
         AddText("停止运行");
         serviceStatus = false;
         break;
     case ServiceControllerStatus.StopPending:
         AddText("正在停止. . .");
         break;
     default:
         break;
 }

四、启动服务和停止服务 

  serviceController.Start();

  serviceController.Stop();