在winform里如何用代码实现SQL Server 的启动和停止? 请高手帮忙。谢谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在c#里执行cmd命令,net start/stop mssqlserver System.ServiceProcess.ServiceController sc2 = new System.ServiceProcess.ServiceController("Telnet");if (sc2.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Stopped)){ sc2.Start();}else{ sc2.Stop();} using System;using System.Diagnostics;using System.Windows.Forms;class Test : Form{ Test() { Button btn1 = new Button(); btn1.Parent = this; btn1.Text = "启动 SQL Server"; btn1.Tag = "START"; btn1.Left = 10; btn1.Width = 120; btn1.Click += new EventHandler(BtnClick); Button btn2 = new Button(); btn2.Parent = this; btn2.Text = "停止 SQL Server"; btn2.Tag = "STOP"; btn2.Left = btn1.Right + 10; btn2.Width = 120; btn2.Click += new EventHandler(BtnClick); } void BtnClick(object sender, EventArgs e) { string s = string.Format("{0} MSSQLSERVER", (sender as Button).Tag); Process.Start("NET.EXE", s); } static void Main() { Application.Run(new Test()); }} // 使用 Windows 服务控制器来启动或停止服务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.Left = 10; btn1.Width = 120; btn1.Click += new EventHandler(BtnClick); Button btn2 = new Button(); btn2.Parent = this; btn2.Text = "停止 SQL Server"; btn2.Tag = "STOP"; btn2.Left = btn1.Right + 10; btn2.Width = 120; btn2.Click += new EventHandler(BtnClick); } 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(); } if (s == "STOP" && !sc.Status.Equals(ServiceControllerStatus.Stopped)) { sc.Stop(); } } static void Main() { Application.Run(new Test()); }} using System.ServiceProcess; 怎么出错了阿? C# sockets 设置端口重用 高分急问急问:关于C#程序中DLL引用的问题!!! 如何编程绕过Vista下的UAC 打印机无法自动切纸,如何处理? 网站策划[II]如何实现注册用户的email帐户激活 C# 动态生成的控件 text 属性 类中调用另一个类的han数。 重写一个DateTimePicker更改其中的样式 如何实现字符串转二进制? 请问TimePicer里的Checked怎么不起作用了。 急救 请问数据转换的问题 请问:哪位朋友肯提供一下C# WINFORM + Sql Server2000 (ado.net)写的项目,最好是在代码万行以上的,谢谢!!!!
if (sc2.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Stopped)){
sc2.Start();
}
else
{
sc2.Stop();
}
using System.Diagnostics;
using System.Windows.Forms;class Test : Form
{
Test()
{
Button btn1 = new Button();
btn1.Parent = this;
btn1.Text = "启动 SQL Server";
btn1.Tag = "START";
btn1.Left = 10;
btn1.Width = 120;
btn1.Click += new EventHandler(BtnClick); Button btn2 = new Button();
btn2.Parent = this;
btn2.Text = "停止 SQL Server";
btn2.Tag = "STOP";
btn2.Left = btn1.Right + 10;
btn2.Width = 120;
btn2.Click += new EventHandler(BtnClick);
} void BtnClick(object sender, EventArgs e)
{
string s = string.Format("{0} MSSQLSERVER", (sender as Button).Tag);
Process.Start("NET.EXE", s);
} static void Main()
{
Application.Run(new Test());
}
}
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.Left = 10;
btn1.Width = 120;
btn1.Click += new EventHandler(BtnClick); Button btn2 = new Button();
btn2.Parent = this;
btn2.Text = "停止 SQL Server";
btn2.Tag = "STOP";
btn2.Left = btn1.Right + 10;
btn2.Width = 120;
btn2.Click += new EventHandler(BtnClick);
} 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();
}
if (s == "STOP" && !sc.Status.Equals(ServiceControllerStatus.Stopped))
{
sc.Stop();
}
} static void Main()
{
Application.Run(new Test());
}
}