DbType Property

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overrides Property DbType As DbType

public override DbType DbType {get; set;}

Property Value

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

Remarks

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

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

Example

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

csharp

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

Visual Basic

Public Sub CreateDB2Parameter()
  Dim myParameter As New DB2Parameter()
  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

DB2Parameter Class
DB2Parameter Members

Send Feedback