Following C# code snippet can be used to display the name of all the databases in the SQL Server:
using System;
using System.Data;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
//Update connection string in the connString for your SQL Server
String connString = "Data Source=SQLDatabaseServer; Integrated Security=True;";
using (SqlConnection sqlConn = new SqlConnection(connString))
{
sqlConn.Open();
DataTable tblDatabases = sqlConn.GetSchema("Databases");
sqlConn.Close();
foreach (DataRow row in tblDatabases.Rows)
{
Console.WriteLine("Database: " + row["database_name"]);
}
}
}
}
}