System.Data.Common Namespace DataColumnMappingCollection Class
Checks whether a DataColumnMapping object exists in the collection.
1. Checks whether a given DataColumnMapping object exists in the collection.
2. Checks whether a DataColumnMapping with the given source column name exists in the collection.
The following example searches for a DataColumnMapping object with the given source column name within a DataColumnMappingCollection. If the DataColumnMapping exists, the code displays the name and index of the mapping; otherwise, it displays an error.
NOTE: This example uses one of the overloaded versions of Contains. For other examples that may be available, see the individual overload topics.
public void FindDataColumnMapping ( DataTableMapping myTableMap ) {
// get column mappings
DataColumnMappingCollection myFieldsMaps = myTableMap.ColumnMappings;
if ( myFieldsMaps.Contains ( "Description" ) ) {
MessageBox.Show ( "Name: " + myFieldsMaps [ "Description" ].ToString ( )
+ "\nIndex: " + myFieldsMaps.IndexOf ( "Description" ).ToString ( ) );
} else {
MessageBox.Show ( "Error: no such field in collection" );
}
}
Public Sub FindDataColumnMapping ( ByVal myTableMap As DataTableMapping )
' get column mappings
Dim myFieldsMaps As DataColumnMappingCollection = myTableMap.ColumnMappings;
If myFieldsMaps.Contains ( "Description" ) Then
MessageBox.Show ( "Name: " + myFieldsMaps ( "Description" ).ToString ( ) _
+ ControlChars.Cr + "Index: " + myFieldsMaps.IndexOf ( "Description" ).ToString ( ) )
Else
MessageBox.Show ( "Error: no such field in collection" )
End If
End Sub |
| |
C# |
VB |
DataColumnMappingCollection Members
