Post
Ask Question

How To Get All The Databases Of A Server In C#

App.Config  (Getting the Connection String) 
  1. <connectionStrings>  
  2. <clear />  
  3. <add name="MyConnection" connectionString="Server=ServerName; Database=Any DatabaseName; User Id=Your UserId; Password= Your Password;" providerName="System.Data.SqlClient" />    
  4. </connectionStrings>  
  5. </configuration>  
C# Code 

This will add all the databases to the Combobox,
  1. string connectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString.ToString();  
  2. using (SqlConnection con = new SqlConnection(connectionString))  
  3. {  
  4.     con.Open();  
  5.   
  6.     // Set up a command with the given query and associate  
  7.     // this with the current connection.  
  8.     SqlDataAdapter d = new SqlDataAdapter("SELECT name from sys.databases", con);  
  9.     DataTable dt = new DataTable();  
  10.     d.Fill(dt);  
  11.     cmbDatabase.DataSource = dt;  
  12.     cmbDatabase.DisplayMember = "name";  
  13. }