This topic has not yet been rated - Rate this topic

OleDbParameter.DbType Property

.NET Framework 4.5

Gets or sets the DbType of the parameter.

Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)

abstract DbType : DbType with get, set 
override DbType : DbType with get, set

Property Value

Type: System.Data.DbType
One of the DbType values. The default is String.

Implements

IDataParameter.DbType

Exceptions

Exception	Condition
ArgumentOutOfRangeException	The property was not set to a valid DbType.

Remarks

The OleDbType and DbType are linked. Therefore, setting the DbType changes the OleDbType to a supporting OleDbType.

For a list of the supported data types, see the appropriate OleDbType member. For more information, see DataAdapter Parameters (ADO.NET).

Examples

The following example creates an OleDbParameter and sets some of its properties.

No code example is currently available or this language may not be supported.

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Platforms

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

OleDbParameter Class

System.Data.OleDb Namespace

Other Resources

Commands and Parameters (ADO.NET)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)