操作MSSQL服务还有测试是否连接1

       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;
            }

 

 

 

        private void button1_Click(object sender, EventArgs e)
        {
            System.ServiceProcess.ServiceController sc = new System.ServiceProcess.ServiceController();
            sc.ServiceName = "MSSQLSERVER";
            if (sc == null)
            {
                MessageBox.Show("您的机器上没有安装SQL SERVER！", "提示信息");
                return;
            }
            //sc.MachineName = "localhost";
            else if (sc.Status != System.ServiceProcess.ServiceControllerStatus.Running)
            {
                sc.Start();
                MessageBox.Show("SQL数据库服务启动成功！", "提示信息");
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            System.ServiceProcess.ServiceController sc = new System.ServiceProcess.ServiceController();
            sc.ServiceName = "MSSQLSERVER";
            if (!sc.Status.Equals(System.ServiceProcess.ServiceControllerStatus.Stopped))
            {
                sc.Stop();
                MessageBox.Show("SQL数据库服务已经关闭！", "提示信息");
            }
        }

        public static string GetSQLmasterConstring(DBConfig db)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("Data Source=" + db.ServerName);
            sb.Append(";Initial Catalog=master");
            if (db.ValidataType == "Windows身份认证")
            {
                sb.Append("; Integrated Security=SSPI;");
            }
            else
            {

                sb.Append("User ID=" + db.UserName + ";Password=" + db.UserPwd + ";");

            }
            return sb.ToString();
        }

        public static string GetConstring(DBConfig db)
        {
            if (db.ProviderName == "SQL")
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("Data Source=" + db.ServerName);
                sb.Append(";Initial Catalog=" + db.DataBase);
                if (db.ValidataType == "Windows身份认证")
                {
                    sb.Append("; Integrated Security=SSPI;");
                }
                else
                {

                    sb.Append("User ID=" + db.UserName + ";Password=" + db.UserPwd + ";");

                }
                return sb.ToString();
            }
            else
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("Provider=Microsoft.Ace.OleDb.12.0");
                sb.Append(";Data Source= " + db.DataBase);
                sb.Append(";Persist Security Info=False;");
                return sb.ToString();
            }

        }