DataColEnumerator Class

项目
12/15/2008

This class is used when the ADO enumerator returns a Dataset or Recordset. This enumerator allows you to enumerate over the columns. This class cannot be inherited.

命名空间: Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO
程序集: Microsoft.SqlServer.ForEachADOEnumerator (in microsoft.sqlserver.foreachadoenumerator.dll)

语法

声明
Public NotInheritable Class DataColEnumerator
    Implements IEnumerator

public sealed class DataColEnumerator : IEnumerator

public ref class DataColEnumerator sealed : IEnumerator

public final class DataColEnumerator implements IEnumerator

public final class DataColEnumerator implements IEnumerator

备注

The members of this class cannot be used directly. This class is used by the foreach keyword (For Each in Visual Basic). The following code example is a piece of a foreach loop showing simply how to use indexing to place a data column into the enumerator and iterate over it.

Vardisp.LockOneForWrite("VariableThatHadIndexSetToMinus1", vars)

DataColEnumerator dcEnum = (DataColEnumerator)vars[0]
foreach (object o in dcEnum)
{
    // Do something with o, 
    // where o is the value of the column, just as you would get
    // if you had a variable for a specific index.
}

You must set the index for the variable mapping to -1 to retrieve the entire collection into the variable, instead of retrieving just a column which is based on an index, so then you can access it directly.

Inheritance Hierarchy

System.Object
Microsoft.SqlServer.Dts.Runtime.Enumerators.ADO.DataColEnumerator

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台