コード例 #1
0
        public DataTable GetDataBaseList()
        {

            if (String.IsNullOrEmpty(StrServer))
            {
                txt_Server.ErrorText = "服务器不能为空!";
                txt_Server.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return null;
            }

            if (String.IsNullOrEmpty(StrUser))
            {
                txt_User.ErrorText = "用户名不能为空!";
                txt_User.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return null;
            }

            if (String.IsNullOrEmpty(StrPassword))
            {
                txt_Pwd.ErrorText = "密码不能为空!";
                txt_Pwd.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return null;
            }

            DataTable dt = new DataTable();

            DB_SQL tmp = new DB_SQL()
            {
                Server = StrServer,
                DataBase = "master",
                UserID = StrUser,
                Password = StrPassword
            };
            string ConnectionStr = tmp.GetConnectionStr();
            SqlConnection conn = new SqlConnection(ConnectionStr);
            try
            {
                conn.Open();
                string str = "SELECT name FROM  sys.sysdatabases WHERE dbid>6";
                SqlCommand cmd = new SqlCommand(str, conn);
                SqlDataAdapter sdap = new SqlDataAdapter();
                sdap.SelectCommand = cmd;

                sdap.Fill(dt);
                conn.Close();

            }
            catch (Exception ex)
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
                MessageBox.Show(ex.ToString());
                dt = null;
            }
            return dt;
        }
コード例 #2
0
        public IDB DoConfig()
        {
            DB_SQL Config = null;

            if (String.IsNullOrEmpty(StrServer))
            {
                txt_Server.ErrorText = "服务器不能为空!";
                txt_Server.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return Config;
            }

            if (String.IsNullOrEmpty(StrUser))
            {
                txt_User.ErrorText = "用户名不能为空!";
                txt_User.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return Config;
            }

            if (String.IsNullOrEmpty(StrPassword))
            {
                txt_Pwd.ErrorText = "密码不能为空!";
                txt_Pwd.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return Config;
            }

            if (String.IsNullOrEmpty(StrDataBase))
            {
                txt_DataBase.ErrorText = "数据库不能为空!";
                txt_DataBase.ErrorIconAlignment = ErrorIconAlignment.MiddleRight;
                return Config;
            }


            DB_SQL tmp = new DB_SQL()
            {
                Server = StrServer,
                DataBase = StrDataBase,
                UserID = StrUser,
                Password = StrPassword,
                Port = txt_Port.Text
            };
            try
            {
                var fac = System.Data.Common.DbProviderFactories.GetFactory(tmp.ProviderName);

                using (var conn = fac.CreateConnection())
                {
                    conn.ConnectionString = tmp.GetConnectionStr();
                    conn.Open();
                    conn.Close();
                    Config = tmp;
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            return Config;
        }