Enumerate SQL Server Instances in C#, Using ODBC

<br />
using System.Data;<br />
using System.Data.Sql;<br />
using System.Data.SqlClient;<br />
<br />
namespace Helpers<br />
{<br />
public class SQLHelpers<br />
{<br />
		/// <summary><br />
		/// Returns a list of SQL servers<br />
		/// </summary><br />
		/// <returns></returns><br />
		private string[] GetSQLServerList()<br />
		{<br />
			SqlDataSourceEnumerator dse = SqlDataSourceEnumerator.Instance;<br />
			DataTable dt = dse.GetDataSources();<br />
			if( dt.Rows.Count == 0 )<br />
				return null;<br />
<br />
			string[] SQLServers = new string[dt.Rows.Count];<br />
			int f = 0;<br />
			foreach (DataRow r in dt.Rows)<br />
			{<br />
//				Debug.WriteLine(r[0].ToString() + " : " + r[1].ToString() + " : " + r[2].ToString() + " : " + r[3].ToString());<br />
				string SQLServer = r["ServerName"].ToString();<br />
				string Instance = r["InstanceName"].ToString();<br />
				if (Instance != null && Instance != "")<br />
					SQLServer += "\\" + Instance;<br />
				SQLServers[f++] = SQLServer;<br />
			}<br />
			Array.Sort<string>(SQLServers);<br />
			return SQLServers;<br />
		}<br />
<br />
		/// <summary><br />
		/// Returns a list of user databases on the specified server instance<br />
		/// </summary><br />
		/// <param name="serverInstanceName">Name of server and if applicable the instance name<br />
		///		<example> DEV10\SQLEXPRESS </example><br />
		///		<example> MYSQLSERVER </example><br />
		/// </param><br />
		/// <param name="useWindowsAuthentication">true if SSPI should be used; otherwise the username and password must be specified.</param><br />
		/// <param name="username">username of an SQL server user account</param><br />
		/// <param name="password">password for the SQL account specified by the username above</param><br />
		/// <returns>fixed string array containing the list of user databases</returns><br />
		private string[] GetSQLDatabaseList(string serverInstanceName, bool useWindowsAuthentication, string username, string password)<br />
		{<br />
			SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();<br />
			csb.DataSource = cboSrcDB.Text;<br />
			csb.TrustServerCertificate = useWindowsAuthentication;<br />
			csb.InitialCatalog = "master";<br />
			if (!useWindowsAuthentication)<br />
			{<br />
				csb.UserID = username;<br />
				csb.Password = password;<br />
			}<br />
			SqlConnection conn = new SqlConnection(csb.ToString());<br />
<br />
			// The 'where sid <> 0x01' part of the command removes the system tables from the list<br />
			SqlDataAdapter da = new SqlDataAdapter("Select name from sysdatabases where sid <> 0x01", conn);<br />
			try<br />
			{<br />
				DataTable dt = new DataTable("Databases");<br />
				int rowsAffected = da.Fill(dt);<br />
				if (dt == null || rowsAffected <= 0)<br />
					return null;<br />
<br />
				int f = 0;<br />
				string[] databases = new string[dt.Rows.Count];<br />
				foreach (DataRow r in dt.Rows)<br />
				{<br />
					databases[f++] = r["name"].ToString();<br />
				}<br />
				da.Dispose();<br />
				Array.Sort<string>(databases);<br />
				return databases;<br />
			}<br />
			catch (SqlException ex)<br />
			{<br />
				MessageBox.Show("Cannot obtain database list:\n" + ex.Message, "Migration Tool", MessageBoxButtons.OK, MessageBoxIcon.Error);<br />
				return null;<br />
			}<br />
			finally<br />
			{<br />
				conn.Close();<br />
			}<br />
		}<br />
}<br />
}<br />