<?xml version="1.0" encoding="utf-8" ?> <codesnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <codesnippet format="1.0.0"> <header> <title>Retrieving List of SQL Server Databases</title> <shortcut>getsqlserverdatabases</shortcut> <description>Illustrates how to retrieve a list of databases available from a single SQL Server instance.</description> <author>C# .Net Fun - http://www.dotnetfun.com - Michael G.</author> </header> <snippet> <declarations> <literal> <id>strConnectionString</id> <type>System.String</type> <tooltip>The connection string for the SQL Server you want to query.</tooltip> <default>"Data Source=MYSERVER; User ID=sa; Password=password"</default> </literal> </declarations> <code language="CSharp"> <![CDATA[ // NOTE: This code snippet is designed for VS.NET 2005 or later. // Implements the following using statements: // using System.Data; // using System.Data.SqlClient; String strConn = $strConnectionString$; using (SqlConnection sqlConn = new SqlConnection(strConn)) { sqlConn.Open(); DataTable tblDatabases = sqlConn.GetSchema("Databases"); sqlConn.Close(); foreach (DataRow row in tblDatabases.Rows) { String strDatabaseName = row["database_name"].ToString(); } } ]> </code> </snippet> </codesnippet> </codesnippets>