DbType Property (PgSqlParameter)

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 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.

csharp

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

Visual Basic

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

Reference

PgSqlParameter Class
PgSqlParameter Members

Send Feedback