DbType Property (OracleParameter)

In This Topic

Syntax
Remarks
Example
Requirements
See Also

Gets or sets the System.Data.DbType of the parameter.

Syntax

Visual Basic
C#

public override DbType DbType {get; set;}

'Declaration
 
Public Overrides Property DbType As DbType

Property Value

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

Remarks

The Devart.Data.Oracle.OracleParameter.OracleType and DbType are linked. Therefore, setting the changes the Devart.Data.Oracle.OracleParameter.OracleType to a supporting OracleType.

For a list of the supported data types, see the appropriate OracleType member.

Example

The following example creates a OracleParameter and sets some of its properties, including the DbType property.

csharp

public void CreateOracleParameter()
{
  OracleParameter myParameter = new OracleParameter();
  myParameter.ParameterName = "DName";
  myParameter.DbType = DbType.String;
  myParameter.Direction = ParameterDirection.Output;
  myParameter.Size = 15;
}

Visual Basic

Public Sub CreateOracleParameter()
  Dim myParameter As New OracleParameter()
  myParameter.ParameterName = "DName"
  myParameter.DbType = DbType.String
  myParameter.Direction = ParameterDirection.Output
  myParameter.Size = 15
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleParameter Class
OracleParameter Members
Devart.Data.Oracle.OracleParameter.OracleType

Send Feedback