Getting Database Names from Server

[PDTUM]

Good Afternoon, I used a nice SQL insert/update program for years with MSSQL 2000, but was never able to get it past security to make it work with 2005. This weekend, out of frustration, I decided to take a shot at writing one of my own. In doing so, I attempted to list the databases that were on the server. I first tested the command in the Query analyzer and it worked fine, returning all the names of the databases. However, when I tried to use the exact same code in the application, every database name comes up as "master" in the array, so I cannot continue to propagate the tables without a named database. I cannot understand how the identical code can return different results in different places. Here is the code. Appreciate your assistance....Thank you, Pat

string Sql = "SELECT name FROM sys.databases";

            SqlCommand Comm = new SqlCommand(Sql, Conn);

            SqlDataAdapter da = new SqlDataAdapter(Comm);
            DataSet ds = new DataSet();
            da.Fill(ds);
            
	int cnt = ds.Tables\[0\].Rows.Count;
            string\[\] dbs = new string\[cnt\];

            for(int i = 0; i < cnt; i++)
            {
             dbs\[i\] = ds.Tables\[0\].Rows\[0\]\["name"\].ToString();   
            }

            foreach(string s in dbs)
            {
                databases.Items.Add(s);
            }

[Lost User]

Cross-post, answers go here[^] :)

I are Troll :suss: