从PowerShell sql查询中获取列名称

SqlDataAdapter.Fill() DataTable 将保留列名的对象:

$cmd = new-object System.Data.SqlClient.SqlCommand($sqlquery, $SqlConnection)
$SqlConnection.Open()

# Create adapter, associate with command
$Adapter = [System.Data.SqlClient.SqlDataAdapter]::new($cmd)

# Create empty DataTable
$DataTable = New-Object System.Data.DataTable

# Fill datatable based on query
$Adapter.Fill($DataTable)

$DataTable.Rows[0] # returns a DataRow object with correct column names

尝试查找

$table = New-Object System.Data.DataTable

希望有帮助!

编辑: 在c中是这样的

SqlConnection conn = new SqlConnection(ConnectionString); 

SqlDataAdapter da = new SqlDataAdapter(); 

SqlCommand cmd = conn.CreateCommand(); 

cmd.CommandText = SQL; 

da.SelectCommand = cmd; 

DataSet ds = new DataSet(); 

conn.Open(); 

da.Fill(ds); 
conn.Close();return ds;