PgSqlParameter Constructor(String,PgSqlType,Int32,ParameterDirection,Boolean,Byte,Byte,String,DataRowVersion,Object)

In This Topic

Syntax
Example
Requirements
See Also

Initializes a new instance of the PgSqlParameter class with the parameter name, data type, width, source column name, parameter direction, numeric precision, and other properties.

Syntax

Visual Basic
C#

public PgSqlParameter( 
   string parameterName,
   PgSqlType dbType,
   int size,
   ParameterDirection direction,
   bool isNullable,
   byte precision,
   byte scale,
   string sourceColumn,
   DataRowVersion sourceVersion,
   object value
)

'Declaration
 
Public Function New( _
   ByVal parameterName As String, _
   ByVal dbType As PgSqlType, _
   ByVal size As Integer, _
   ByVal direction As ParameterDirection, _
   ByVal isNullable As Boolean, _
   ByVal precision As Byte, _
   ByVal scale As Byte, _
   ByVal sourceColumn As String, _
   ByVal sourceVersion As DataRowVersion, _
   ByVal value As Object _
)

Parameters

parameterName: The name of the parameter.
dbType: One of the PgSqlType values.
size: The maximum size, in bytes, of the data within the column.
direction: One of the System.Data.ParameterDirection values.
isNullable: true if the value of the field can be null; otherwise, false.
precision: The total number of digits to the left and right of the decimal point to which Devart.Common.DbParameterBase.Value is resolved.
scale: The total number of decimal places to which Devart.Common.DbParameterBase.Value is resolved.
sourceColumn: The name of the source column.
sourceVersion: One of the System.Data.DataRowVersion values.
value: An Object that is the value of the PgSqlParameter.

Example

The following example creates a new PgSqlParameter and displays the ParameterName.

csharp

public void CreatePgSqlParameter()
{
        PgSqlParameter myParameter = new PgSqlParameter("DName", PgSqlType.VarChar, 15, ParameterDirection.Output, true, 0, 0, "DName", DataRowVersion.Current, "DEVELOPMENT");
  MessageBox.Show(myParameter.ToString());
}

Visual Basic

Public Sub CreatePgSqlParameter()
  Dim myParameter As New PgSqlParameter("DName", PgSqlType.VarChar, 15, ParameterDirection.Output, True, 0, 0, "DName", DataRowVersion.Current, "DEVELOPMENT")
  MessageBox.Show(myParameter.ToString())
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

PgSqlParameter Class
PgSqlParameter Members
Overload List

Send Feedback