All of the data brought into the Grid Display Adapter comes in as text fields. This property is used to convert the fields collected from external XML to a different type of field. This is not required unless the data should be considered as something other than text.
Note: This procedure will occur after the Mapping XSL has been applied.
Example:
<convert>
<column>
<ColumnName>DueDate</ColumnName>
<ColumnType>System.DateTime</ColumnType>
</column>
</convert>
The name of the column you want to convert.
The System Type you would like to convert the column to.
Options:
•System.Boolean
•System.Byte
•System.Char
•System.DateTime
•System.Decimal
•System.Double
•System.Int16
•System.Int32
•System.Int64
•System.SByte
•System.Single
•System.String
•System.TimeSpan
•System.UInt16
•System.UInt32
•System.UInt64
TableName (Optional) – String
The name of the table that contains the column to convert. The TableName comes from the Table node used in the XML. For instance if your xml looks like this: “<Data><Title>Hello</Title></Data><Data><Title>World</Title></Data>” the name of your table is “Data”.