CODEWITHSUNDEEP
c#sqldatabasesql-server-2008
Gokul Kumar
Gokul Kumar

Reputation: 409

Need to get current network server names

I am using enumerator for getting list of server names, But I am getting only one.

         DataTable table = System.Data.Sql.SqlDataSourceEnumerator.Instance.GetDataSources();
        foreach (DataRow server in table.Rows)
        {
            Console.WriteLine(server[table.Columns["ServerName"]].ToString());
            Console.Read();
        }

But i am getting only one server name, what wrong in this code. Please help me!

Upvotes: 1

Views: 69

Answers (1)

Ankit
Ankit

Reputation: 1214

Try

DataTable table = System.Data.Sql.SqlDataSourceEnumerator.Instance.GetDataSources();
foreach (DataRow server in table.Rows)
{
    Console.WriteLine(server["ServerName"].ToString());
    Console.Read();
}

Upvotes: 1

Related Questions