How to get list of all database from NpgsqlConnection in a combobox using c#.net

Question

Im trying to develop a console application and i need to know the all database list name .but this code is not working .This is my code:

public static List<string> AllNpgsqlDatabaseName()
         {
            List<string> li = new List<string>();
            NpgsqlConnection connection = new NpgsqlConnection("Host=localhost;Username=root;Password=root;");
            connection.Open();
            NpgsqlCommand command = connection.CreateCommand();
            command.CommandText = "SELECT name from sys.databases";
            NpgsqlDataReader Reader;

            Reader = command.ExecuteReader();
            while (Reader.Read())
            {
                string row = "";
                for (int i = 0; i < Reader.FieldCount; i++)
                    row += Reader.GetValue(i).ToString() + ", ";
                li.Add(row);
            }

            connection.Close();
            return li;
        }

Answer 1

You can run

SELECT datname FROM pg_database