Ejemplo n.º 1
0
        public static string[] GetDatabases(string serverName, string userName, string password, BLL.ConnectionStringHelper.DatabaseTypes dbType, bool trustedConnection)
        {
            List <string> databaseNames = new List <string>();

            Microsoft.SqlServer.Management.Smo.Server server = new Server(new ServerConnection(serverName, userName, password));

            foreach (Microsoft.SqlServer.Management.Smo.Database database in server.Databases)
            {
                databaseNames.Add(database.Name);
            }

            return((string[])databaseNames.ToArray());
        }
Ejemplo n.º 2
0
        public static string[] GetDatabases(string serverName, string userName, string password, BLL.ConnectionStringHelper.DatabaseTypes dbType, bool trustedConnection)
        {
            List <string> databases = new List <string>();

            SQLDMO.SQLServer sqlServer = new SQLServerClass();
            sqlServer.Connect(serverName, userName, password);

            foreach (SQLDMO.Database database in sqlServer.Databases)
            {
                databases.Add(database.Name);
            }

            return((string[])databases.ToArray());
        }
Ejemplo n.º 3
0
        public static string[] GetDatabases(string serverName, string userName, string password, BLL.ConnectionStringHelper.DatabaseTypes databaseType, bool trustedConnection)
        {
            SqlCommand    cmd  = new SqlCommand();
            SqlConnection conn = null;

            if (trustedConnection)
            {
                conn = new SqlConnection(string.Format("Server={0};Database=master;Trusted_Connection=True", serverName));
            }
            else
            {
                conn = new SqlConnection(string.Format("Server={0};Database=master;User ID={1};Password={2};Trusted_Connection=False", serverName, userName, password));
            }

            List <string> databaseNames = new List <string>();

            try
            {
                conn.Open();

                cmd.Connection  = conn;
                cmd.CommandText = "SELECT name FROM master..sysdatabases";
                cmd.CommandType = CommandType.Text;

                SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                cmd.Parameters.Clear();

                while (rdr.Read())
                {
                    databaseNames.Add(rdr.GetString(0));
                }
            }
            catch
            {
                conn.Close();
                throw;
            }

            return((string[])databaseNames.ToArray());
        }