title: How do I get a list of SQL Servers available on my network?
body: <p>I'm trying this but I'm not sure how to proceed. Can you give me a hand?</p>
  
  <pre><code>SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
  DataTable table = instance.GetDataSources();
  
  foreach (var row in table.Rows)
  {
       foreach (var column in table.Columns)
       {
            ddlPublisherServer.Items.Add(???);
       }
  }
  </code></pre>
  
  <p>Where ??? = SQL Server Name.</p>
  
  <p>How would I go about extracting the sql server name from the table?</p>
  
  <p>I'm working in ASP .NET with C#.</p>