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

posted @ 2012-05-20 21:09  踏浪帅  阅读(310)  评论(0编辑  收藏  举报