• C# 启动停止SQLServer数据库服务器


    C#启动停止SQL数据库服务方法之一:

    在命令行里填写命令:net start/stop mssqlserver

    C#启动停止SQL数据库服务方法之二:

    通过C#代码实现;

    class Program : Form
    {
    public Program()
    {
    Button btn1 = new Button();
    btn1.Parent = this;
    btn1.Text = "启动 SQL SERVER";
    btn1.Tag = "START";
    btn1.Top = 50;
    btn1.Left = 20;
    btn1.Width = 120;
    btn1.Click += new EventHandler(Button_Click);

    Label la = new Label();
    la.Text = "C#启动SQL服务";
    la.ForeColor = System.Drawing.Color.Green;
    la.Left = 100;
    la.Top = 20;
    la.Parent = this;

    Button btn2 = new Button();
    btn2.Parent = this;
    btn2.Text = "停止 SQL SERVER";
    btn2.Tag = "STOP";
    btn2.Top = 50;
    btn2.Left = btn1.Right + 10;
    btn2.Width = 120;
    btn2.Click += new EventHandler(Button_Click);

    this.Text = "C#启动SQL服务";
    }

    void Button_Click(object sender, EventArgs e)
    {
    string s = (sender as Button).Tag.ToString();
    ServiceController sc = new ServiceController("MSSQLSERVER");
    if (s == "START" && sc.Status.Equals(ServiceControllerStatus.Stopped))
    {
    sc.Start();
    MessageBox.Show("SQL数据库服务启动成功!", "提示信息");
    }
    if (s == "STOP" && !sc.Status.Equals(ServiceControllerStatus.Stopped))
    {
    sc.Stop();
    MessageBox.Show("SQL数据库服务已经关闭!", "提示信息");
    }
    }

    static void Main(string[] args)
    {
    Application.Run(new Program());
    }
    }

  • 相关阅读:
    网络流24题-分配问题
    网络流24题-圆桌问题
    git ssh
    SQL Server 添加说明 语句
    问题思路
    数据库事务和锁
    Castle Windsor
    Flask学习笔记11之特殊的装饰器
    python中的"环绕通知"
    Flask学习笔记10之flash
  • 原文地址:https://www.cnblogs.com/wlming/p/5113494.html
Copyright © 2020-2023  润新知