操作MSSQL服务还有测试是否连接
private void btnOk_Click(object sender, EventArgs e)
{
IList<string> _DataBaseList = new List<string>();
System.ServiceProcess.ServiceController sc = new System.ServiceProcess.ServiceController();
sc.ServiceName = "MSSQLSERVER";
if (sc == null)
{
MessageBox.Show("您的机器上没有安装SQL SERVER!", "提示信息");
return;
}
else if (sc.Status != System.ServiceProcess.ServiceControllerStatus.Running)
{
MessageBox.Show("SQL数据库服务未启动,请点击开启SQL服务!", "提示信息");
return;
}
//_DBConfig = new DBConfig();
if (cboServerName.Text == "Local(本机)")
{
_DBConfig.ServerName = "(local)";
}
else
{
_DBConfig.ServerName = cboServerName.Text.ToString();
}
if (cboValidataType.Text == "Windows身份认证")
{
_DBConfig.ValidataType = "Windows身份认证";
}
else
{
txtPassword.Enabled = true;
txtUser.Enabled = true;
_DBConfig.ValidataType = "SQL Server身份认证";
_DBConfig.UserName = txtUser.Text.ToString();
_DBConfig.UserPwd = txtPassword.Text.ToString();
}
_conString = GetSQLmasterConstring(_DBConfig);
_DBConfig.DB = new DBUtility.DbHelperSQL(_conString);
_DataBaseList = _DBConfig.DB.GetDataBaseInfo();
if (_DataBaseList.Count > 0)
{
cboDataBase.DataSource = _DataBaseList;
cboDataBase.Enabled = true;
cboDataBase.SelectedIndex = 0;
}
else
{
cboDataBase.Enabled = false;
cboDataBase.Text = "";
cboDataBase.DataSource = null;
}