System.Data.Common Namespace DataColumnMappingCollection Class
Sets or retrieves the DataColumnMapping from the collection with the specified source column name.
DataColumnMapping variable = DataColumnMappingCollection.Item [ sourceColumn ];
... or ...
DataColumnMapping variable = DataColumnMappingCollection [ sourceColumn ];
dim variable as DataColumnMapping = DataColumnMappingCollection.Item ( sourceColumn )
... or ...
dim variable as DataColumnMapping = DataColumnMappingCollection ( sourceColumn )
variable : DataColumnMapping = DataColumnMappingCollection.Item ( sourceColumn );
... or ...
variable : DataColumnMapping = DataColumnMappingCollection ( sourceColumn ); |
| |
C# |
VB |
JScript |
- sourceColumn
- The case-sensitive name of a SourceColumn.
The DataColumnMapping with the specified name; otherwise a null value if the DataColumnMapping does not exist.
Use the Contains method to test for the existence of a specific DataColumnMapping.
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.
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 DataColumnMappingCollection.Item Overload List
