C#启动停止SQL数据库服务

方法一：在命令行里填写命令：net start/stop mssqlserver

方法二：通过c#代码实现；

 using system;

using system.windows.forms;

using system.serviceprocess;

class test : form

{

test()

//启动按钮；

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(btnclick);

//标题；

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.left = btn1.right + 10;

btn2.top=50;

btn2.width = 120;

btn2.click += new eventhandler(btnclick);

this.text="c#启动sql服务";

}

void btnclick(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()

application.run(new test());

效果如图：