Name

OleDbType

Synopsis

This enumeration specifies values for common OLE DB data types. For information about the mapping between these enumerated values, the underlying OLE DB type, and the compatible .NET framework type, refer to Appendix A.

public enum OleDbType {

   Empty = 0,

   SmallInt = 2,

   Integer = 3,

   Single = 4,

   Double = 5,

   Currency = 6,

   Date = 7,

   BSTR = 8,

   IDispatch = 9,

   Error = 10,

   Boolean = 11,

   Variant = 12,

   IUnknown = 13,

   Decimal = 14,

   TinyInt = 16,

   UnsignedTinyInt = 17,

   UnsignedSmallInt = 18,

   UnsignedInt = 19,

   BigInt = 20,

   UnsignedBigInt = 21,

   Filetime = 64,

   Guid = 72,

   Binary = 128,

   Char = 129,

   WChar = 130,

   Numeric = 131,

   DBDate = 133,

   DBTime = 134,

   DBTimeStamp = 135,

   PropVariant = 138,

   VarNumeric = 139,

   VarChar = 200,

   LongVarChar = 201,

   VarWChar = 202,

   LongVarWChar = 203,

   VarBinary = 204,

   LongVarBinary = 205

}

Hierarchy

System.Object System.ValueType System.Enum(System.IComparable, System.IFormattable, System.IConvertible) OleDbType

Returned By

OleDbParameter.OleDbType

Passed To

OleDbParameter.{OleDbParameter( ), OleDbType}, OleDbParameterCollection.Add( )

Get ADO.NET in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.