DataTypes

[Jim Heavey]

If I am building a DataTable for a SQL Result set and I have SQL datatype
of
Binary
Image
SmallMoney
VarBinary

and setting the dataTable.Column.Type property, what "Type" do I set it to?

Thanks in advance for your assistance!!!!!!

 

[Philip Rieck]

The data type must be one of:
Boolean
Byte
Char
DateTime
Decimal
Double
Int16
Int32
Int64
SByte
Single
String
TimeSpan
UInt16
UInt32
UInt64 ,

So I would set them as:
Binary -> byte[]
Image -> byte[]
SmallMoney -> Decimal
VarBinary -> byte[]

For more mapping info, see here:
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/ht
ml/cpconmappingnetdataproviderdatatypestonetframeworkdatatypes.asp>

 

[Jon Skeet [C# MVP]]

If I am building a DataTable for a SQL Result set and I have SQL datatype
of
Binary
Image
SmallMoney
VarBinary

and setting the dataTable.Column.Type property, what "Type" do I set it to?

Have a look at the SqlDbType enumeration - it says what maps to what.