dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlParameter Class / DbType Property
Example

DbType Property (PgSqlParameter)
Gets or sets the System.Data.DbType of the parameter.
Syntax
'Declaration
 
Public Overrides Property DbType As DbType
 

Property Value

One of the System.Data.DbType values. The default value is System.String.
Remarks
The PgSqlType and DbType are linked. Therefore, setting the changes the PgSqlType to a supporting PgSqlType.

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

Example
The following example creates a PgSqlParameter and sets some of its properties, including the DbType property.
public void CreatePgSqlParameter()
{
  PgSqlParameter myParameter = new PgSqlParameter();
  myParameter.ParameterName = "DName";
  myParameter.DbType = DbType.String;
  myParameter.Direction = ParameterDirection.Output;
  myParameter.Size = 15;
}
Public Sub CreatePgSqlParameter()
  Dim myParameter As New PgSqlParameter()
  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

See Also