List SQL Server databases

Method 1

using System.Data;
using System.Data.SqlClient;
...
// Substitute your connection string below in conxString 
String conxString = 
   "Data Source=MYSERVER; Integrated Security=True;";
 
using (SqlConnection sqlConx = new SqlConnection (conxString))
   {
   sqlConx.Open();
   DataTable tblDatabases = sqlConx.GetSchema ("Databases");
   sqlConx.Close();
 
   foreach (DataRow row in tblDatabases.Rows)
   {
      Console.WriteLine ("Database: " + row["database_name"]);
   }

Method 2 


System.Data.SqlClient.SqlConnection SqlCon = newSystem.Data.SqlClient.SqlConnection("server=192.168.0.1;uid=sa;pwd=1234");
SqlCon.Open();

System.Data.SqlClient.SqlCommand SqlCom = new System.Data.SqlClient.SqlCommand();
SqlCom.Connection = SqlCon;
SqlCom.CommandType = CommandType.StoredProcedure;
SqlCom.CommandText = "sp_databases";

System.Data.SqlClient.SqlDataReader SqlDR;
SqlDR = SqlCom.ExecuteReader();

while(SqlDR.Read())
{
MessageBox.Show(SqlDR.GetString(0));
}