开启停止SqlServer服务代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】开启停止SqlServer服务

作者:Dezai.CN / 发布于2013/1/29/ 564

using System.Diagnostics;
using System.ServiceProcess;
    /**//// <summary>
    /// 程序载入时的状态,
    /// </summary>
    private void LoatStatus()
    {
      ServiceController sc = new ServiceController("MSSQLSERVER");
      string status = sc.Status.ToString();
      sc.Close();
      label1.Text = "Current status is:" + status;
      if (status.Equals("Running"))
        StartSql.Text = "Stop";
      else
        StartSql.Text = "Start";
    }
    /**//// <summary>
    /// 开启停止SqlServer服务,Author:Kennytian@msn.com
    /// </summary>
    /// <param name="text">按钮上的字</param>
    private void StartOrStopSqlServerService(string text)
    {
      ServiceController sc = new ServiceController("MSSQLSERVER");
      bool startText = text.Equals("Start");
      bool stopText = text.Equals("Stop");
      bool Runned = sc.Status.ToString().Equals("Running");
      if (stopText && Runned)
      {
        label1.Text = "Current status is:Stopped";
        sc.Stop();
        StartSql.Text = "Start";
      }
      else if (startText && !Runned)
      {
        label1.Text = "Current status is:Running";
        sc.Start();
        StartSql.Text = "Stop";
      }
      else
      {
        MessageBox.Show("出现异常,请联系开发人员!", "警告", MessageBoxButtons.OK);
      }
      sc.Close();
    }

试试其它关键字

　SqlServer服务　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)