SetDateTime 方法

Assigns a DateTime value to the PipelineBuffer column.

命名空间：  Microsoft.SqlServer.Dts.Pipeline
程序集：  Microsoft.SqlServer.PipelineHost（在 Microsoft.SqlServer.PipelineHost.dll 中）

语法

声明
Public Sub SetDateTime ( _
    columnIndex As Integer, _
    value As DateTime _
)
用法
Dim instance As PipelineBuffer
Dim columnIndex As Integer
Dim value As DateTime

instance.SetDateTime(columnIndex, value)

public void SetDateTime(
    int columnIndex,
    DateTime value
)

public:
void SetDateTime(
    int columnIndex, 
    DateTime value
)

member SetDateTime : 
        columnIndex:int * 
        value:DateTime -> unit 

public function SetDateTime(
    columnIndex : int, 
    value : DateTime
)

参数

• columnIndex
  类型：System. . :: . .Int32
  The index of the column in the buffer row.

• value
  类型：System. . :: . .DateTime
  The value assigned to the buffer column.

注释

The SetDateTime method assigns a DateTime value to the buffer column specified by the columnIndex parameter.

This method works with the following Integration Services data types:

• DT_DATE

• DT_DBTIMESTAMP

• DT_DBTIMESTAMP2

• DT_FILETIME

When the DateTime value requires more digits for fractional seconds than the DT_DBTIMESTAMP2 column supports, the data is truncated and a DoesNotFitBufferException occurs.

If the DataType of the buffer column is not DT_DATE, DT_DBTIMESTAMP, DT_DBTIMESTAMP2, or DT_FILETIME an UnsupportedBufferDataTypeException occurs.

For a complete list of Integration Services data types and the corresponding Get and Set methods of the PipelineBuffer class to use with each type, see 在数据流中使用数据类型.

请参阅

参考

PipelineBuffer 类

Microsoft.SqlServer.Dts.Pipeline 命名空间