DbType Property

On this page

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; }

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

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

Reference

DB2Parameter Class
DB2Parameter Members

Send Feedback