Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. How to get a list of databases in .NET

How to get a list of databases in .NET

Scheduled Pinned Locked Moved C#
csharpdatabasehelptutorial
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    spbdenis
    wrote on last edited by
    #1

    Hi, Could anyone suggest how to get a list of SQL servers and a list of databases using ADO.NET? In VB6, SQLDMO could be used for this, but how it is done in .NET? Any help would be appreciated. Thanks, Denis

    L 1 Reply Last reply
    0
    • S spbdenis

      Hi, Could anyone suggest how to get a list of SQL servers and a list of databases using ADO.NET? In VB6, SQLDMO could be used for this, but how it is done in .NET? Any help would be appreciated. Thanks, Denis

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      I know how to get the list of database, but list of SQL servers. It's simply just the following query statement SELECT name FROM sysdatabases sysdatabases is located in Master Database. Please let me know when you get the list of SQL servers :)

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups