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.

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)

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

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

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

PgSqlRow Class
PgSqlRow Members
Overload List