共用方式為

  • 發行項

EnumWindowsDomainGroups 方法

列舉網域上定義之 Microsoft Windows 群組帳戶的清單。

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Function EnumWindowsDomainGroups As DataTable
'用途
Dim instance As Server
Dim returnValue As DataTable

returnValue = instance.EnumWindowsDomainGroups()

public DataTable EnumWindowsDomainGroups()

public:
DataTable^ EnumWindowsDomainGroups()

member EnumWindowsDomainGroups : unit -> DataTable 

public function EnumWindowsDomainGroups() : DataTable

傳回值

型別：System.Data. . :: . .DataTable
DataTable 系統物件值，包含指定網域之 Windows 群組帳戶的清單。下表將描述傳回之 DataTable 的不同資料行。

資料行

資料類型

說明

Name

String

Windows 網域群組的名稱。

Description

String

Windows 網域群組的描述

範例

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Call the EnumCollations method and return collation information to DataTable variable.
Dim d As DataTable
'Select the returned data into an array of DataRow.
d = srv.EnumCollations
'Iterate through the rows and display collation details for the instance of SQL Server.
Dim r As DataRow
Dim c As DataColumn
For Each r In d.Rows
    Console.WriteLine("============================================")
    For Each c In r.Table.Columns
        Console.WriteLine(c.ColumnName + " = " + r(c).ToString)
    Next
Next

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$d = new-object System.Data.Datatable
$d = $srv.EnumCollations

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}