Display SQL database names

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Roy

    Display SQL database names

    I am using C# and would like to display all my SQL databases in a listbox.
    How do I use the sp_helpdb to retrive the names of my databases?


  • Michael Earls

    #2
    Re: Display SQL database names

    Browse around the MSDN library in the System.Data namespace. If you look
    deep enough, you'll find classes that will assist you in getting the
    database schema (based on the ADOX from the "legacy" ASP/COM days).

    Michael Earls

    "Roy" <roy@royeagle.c om> wrote in message
    news:ehFHVEKiDH A.1368@TK2MSFTN GP12.phx.gbl...[color=blue]
    > I am using C# and would like to display all my SQL databases in a listbox.
    > How do I use the sp_helpdb to retrive the names of my databases?
    >
    >[/color]


    Comment

    Working...