using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace ConsoleApplication12
{
    class Program
    {
        static void Main(string[] args)
        {
            string dataSource = "(local)";
            string userID = "sa";
            string password = "123456";

            List<string> bases = GetDatabaseList(dataSource, userID, password);

            foreach (string db in bases)
                Console.WriteLine(db);
        }

        private static List<string> GetDatabaseList(string dataSource, string userID, string password)
        {
            List<string> bases = new List<string>();

            SqlConnectionStringBuilder conStringBuilder = 
                new SqlConnectionStringBuilder();
            conStringBuilder.DataSource = dataSource;
            conStringBuilder.UserID = userID;
            conStringBuilder.Password = password;

            SqlConnection connection = new SqlConnection(conStringBuilder.ToString());
            connection.Open();
            
            SqlCommand command = new SqlCommand("sp_databases", connection);
            command.CommandType = System.Data.CommandType.StoredProcedure;

            SqlDataReader reader = command.ExecuteReader();
            if (reader.HasRows)
                while (reader.Read())
                    bases.Add(reader.GetString(0));
            
            connection.Dispose();

            return bases;
        }
    }
}