Get all local network sql instances.

GetLocalNetworkSqlInstances.cs

//using System.Data.Sql;
 
public List<string> GetLocalNetworkSqlInstances()
{
            SqlDataSourceEnumerator instances = SqlDataSourceEnumerator.Instance;
            List<string> listInstance = new List<string>();
            DataTable dt = instances.GetDataSources();
            
            listInstance.Clear();

            foreach (DataRow item in dt.Rows)
            {
                if (item.ItemArray[1] == DBNull.Value)
                {
                    listInstance.Add((string) item.ItemArray[0]);
                }
                else
                {
                    listInstance.Add(item.ItemArray[0] + @"\" + item.ItemArray[1]);
                }
            }
            
        return listInstance;
}