using System.Diagnostics;
using System.ServiceProcess;
/**//// <summary>
/// 程式載入時的狀態,Author:Kennytian@msn.com
/// </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();
}
注:StartSql是一個按鈕,添加一個引用ServiceProcess