PgSqlRow Constructor(String,PgSqlConnection)

In This Topic

Syntax
Remarks
Example
See Also

Initializes a new instance of the PgSqlRow class with the specified parameters.

Syntax

Visual Basic
C#

public PgSqlRow( 
   string typeName,
   PgSqlConnection connection
)

'Declaration
 
Public Function New( _
   ByVal typeName As String, _
   ByVal connection As PgSqlConnection _
)

Parameters

typeName: Name of composite type that describes data structure.
connection: PgSqlConnection to use to obtain composite type information from server.

Remarks

The must be open before using this constructor.

Example

The following example demonstrates how to construct a PgSqlRow object and use it as parameter value.

CREATE TYPE tperson AS (name text, age integer)

CREATE TABLE personnel (id integer, person tperson)

csharp

static void InsertDataWithParameters(PgSqlConnection conn)
{
  string str = "INSERT INTO personnel VALUES (:ID, :ROW)";
  PgSqlCommand pgCommand = new PgSqlCommand(str,conn);
  //Create instance of PgSqlRow and fill with data
  PgSqlRow pgRow = new PgSqlRow("tperson",conn);
  pgRow[0] = "Fred";
  pgRow[1] = 24;
  //provide parameters to command and execute it
  pgCommand.Parameters.Add("ID",3);
  pgCommand.Parameters.Add("ROW",pgRow);
  pgCommand.ExecuteNonQuery();
  Console.WriteLine("Record added");
}

Visual Basic

Sub InsertDataWithParameters(ByVal conn As PgSqlConnection)
  Dim str As String = "INSERT INTO personnel VALUES (:ID, :ROW)"
  Dim pgCommand As PgSqlCommand = New PgSqlCommand(str, conn)
  'Create instance of PgSqlRow and fill with data
  Dim pgRow As PgSqlRow = New PgSqlRow("tperson", conn)
  pgRow(0) = "Fred"
  pgRow(1) = 24
  'provide parameters to command and execute it
  pgCommand.Parameters.Add("ID", 3)
  pgCommand.Parameters.Add("ROW", pgRow)
  pgCommand.ExecuteNonQuery()
  Console.WriteLine("Record added")
End Sub

Reference

PgSqlRow Class
PgSqlRow Members
Overload List

Send Feedback