retrieve list of databases from .net

[j-in-uk]

Can i get a list of sql databases by just connecting to the server
programmatically

string myConnString = "Integrated Security=SSPI;Initial
Catalog={0};Data Source=" + serverName +";";
SqlConnection cn = new SqlConnection(myConnString);
cn.Open();
SqlDataReader dr = (new SqlCommand("sp_databases",
cn)).ExecuteReader();
while (dr.Read())
{
lstDatabases.Items.Add(dr["DATABASE_NAME"]);
}

This does not work cos I don't know the name of database/initial
catalog at this point

[Mark Rae]

"j-in-uk" <je******@gmail.comwrote in message
news:11**********************@51g2000cwl.googlegro ups.com...

This does not work cos I don't know the name of database/initial
catalog at this point

Yes you do - it's called 'master' :-)

[j-in-uk]

Thanks, master worked. I am using NetServerEnum to get a list of the
sqlServers, I realise that this does not return sqlExpress servers but
get everything else. Do you know what returns SQLExpress & other sql
servers?

thanks

On Jan 4, 1:52 pm, "Mark Rae" <[e-mail]:

"j-in-uk" <[e-mail] in messagenews:11**********************@51g2000cwl.go oglegroups.com...

This does not work cos I don't know the name of database/initial
catalog at this pointYes you do - it's called 'master' :-)