DB2 V9.7 for Linux, UNIX, and Windows
DB2 V9.7 for Linux, UNIX, and Windows
返回一个值，它指示指定的 DB2BulkCopyColumnMapping 对象是否包含在 DB2BulkCopyColumnMappingCollection 中。
[Visual Basic]
Public Function Contains ( _
inValue As DB2BulkCopyColumnMapping _
) As Boolean
[C#]
public bool Contains(DB2BulkCopyColumnMapping inValue)
[C++]
public:
bool Contains (DB2BulkCopyColumnMapping* inValue)
[JScript]
public function Contains(
inValue : DB2BulkCopyColumnMapping
) : boolean如果集合中存在指定的 DB2BulkCopyColumnMapping，那么 Contains 将返回 true。否则，Contains 将返回 false。
[C#] 以下示例演示如何将 DB2DataReader 中的数据成批复制到 DEPARTMENT 表中。源表与目标表之间的列映射由 DB2BulkCopyColumnMappingCollection 实例定义。除了成批复制操作之外，还演示了 Contains 方法，此方法确定集合中是否存在 DB2BulkCopyColumnMapping。
[C#]
public static void copyIntoSales(DB2Connection conn, DB2DataReader reader)
{
DB2BulkCopy salesCopy = new DB2BulkCopy(conn);
salesCopy.DestinationTableName = "DEPARTMENT";
DB2BulkCopyColumnMappingCollection colMapCollection;
colMapCollection = new DB2BulkCopyColumnMappingCollection();
salesCopy.ColumnMappings = colMapCollection;
colMapCollection.Add("DEPTNUMB", "DEPTNO");
colMapCollection.Add("DEPTNAME", "DEPTNAME");
colMapCollection.Add("MANAGER", "ADMRDEPT");
colMapCollection.Add("LOCATION", "LOCATION");
//Determine if a DB2BulkCopyColumnMapping
//is included in the current collection.
DB2BulkCopyColumnMapping colMapDeptNum =
new DB2BulkCopyColumnMapping("DEPTNUMB", "DEPTNO");
//If the DB2BulkCopyColumnMapping does exist, print a message indicating this.
if (colMapCollection.Contains(colMapDeptNum))
{
MessageBox.Show("The Department Number mapping is included in the mapping collection.");
}
try
{
salesCopy.WriteToServer(reader);
salesCopy.Close();
}
catch (DB2Exception ex)
{
MessageBox.Show(ex.ToString(), "Exception");
}
}