Getting Data back using literals

[neeraj]

I have a C# program snippet. What is the equivalent expression in Dyalog

using System;
using System.Data;
using System.Data.Sql;
.
.
public static void Main(string[] args)
{
// Obtain the DataTable of SQL Server instances.
using (DataTable SqlSources =
SqlDataSourceEnumerator.Instance.GetDataSources())
{
// Enumerate the set of SQL Servers and display details.
Console.WriteLine("Discover SQL Server Instances:");
foreach (DataRow source in SqlSources.Rows)
{
Console.WriteLine(" Server Name:{0}", source["ServerName"]);
Console.WriteLine(" Instance Name:{0}",
source["InstanceName"]);
Console.WriteLine(" Is Clustered:{0}",
source["IsClustered"]);
Console.WriteLine(" Version:{0}", source["Version"]);
}
}

// Wait to continue.
Console.WriteLine(Environment.NewLine);
}
}

EQUIVALENT APL
Z←AllSqlServerInstances;⎕USING;SqlSources;source
⍝ Returns all SQL Server Instances
⎕USING←,⊂'System'
⎕USING,←'System.Data,System.Data.dll' 'System.Data.Sql,System.Data.dll'
SqlSources←SqlDataSourceEnumerator.Instance.GetDataSources
:For source :In SqlSources.Rows
source.ItemArray ⍝ This works
source[0] ⍝ This works as well
source["ServerName"] ⍝ This does not work
:EndFor
⎕←Environment.NewLine

[PGilbert]

Could you try the following for the line that does not work:

Code: Select all

source[⊂'ServerName']

[neeraj]

That worked. I am lovin it.