''DbType'' ''serializable'

DbType serializable

System.Data (system.data.dll) enum

This enumeration specifies a data type of a field, property, or parameter in the data source. It sets the IDataParameter.DbType property, which identifies the data type of a Command parameter, typically for a stored procedure. Most ADO.NET providers include an enumeration for the data types supported by the data source. For example, the OLE DB provider includes a System.Data.OleDb.OleDbType enumeration, which can be used to set the System.Data.OleDb.OleDbParameter.OleDbType property. When you set the System.Data.OleDb.OleDbParameter.OleDbType property, the System.Data.OleDb.OleDbParameter.DbType property is updated automatically with the closest compatible type from the DbType enumeration.

public enum DbType {
   AnsiString = 0,
   Binary = 1,
   Byte = 2,
   Boolean = 3,
   Currency = 4,
   Date = 5,
   DateTime = 6,
   Decimal = 7,
   Double = 8,
   Guid = 9,
   Int16 = 10,
   Int32 = 11,
   Int64 = 12,
   Object = 13,
   SByte = 14,
   Single = 15,
   String = 16,
   Time = 17,
   UInt16 = 18,
   UInt32 = 19,
   UInt64 = 20,
   VarNumeric = 21,
   AnsiStringFixedLength = 22,
   StringFixedLength = 23
}

Hierarchy

System.Object figs/U2192.gif System.ValueType figs/U2192.gif System.Enum(System.IComparable, System.IFormattable , System.IConvertible) figs/U2192.gif DbType

Returned By

IDataParameter.DbType , System.Data.OleDb.OleDbParameter.DbType , System.Data.OracleClient.OracleParameter.DbType , System.Data.SqlClient.SqlParameter.DbType

Passed To

IDataParameter.DbType , System.Data.OleDb.OleDbParameter.DbType , System.Data.OracleClient.OracleParameter.DbType , System.Data.SqlClient.SqlParameter.DbType



    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference
    Chapter 34. The System.Data Namespace