Parse Method (PgSqlRowType)

In This Topic

Syntax
Example
See Also

Converts a PgSqlRow from its string representation.

Syntax

Visual Basic
C#

public PgSqlRow Parse( 
   string rowValue
)

'Declaration
 
Public Function Parse( _
   ByVal rowValue As String _
) As PgSqlRow

Parameters

rowValue: String that contains data for PgSqlRow.

Return Value

Parsed PgSqlRow.

Example

This sample shows how to obtain PgSqlRowType from server and create a PgSqlRow object on the client side. The object is later inserted into table.

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 parse data
  //Note that connection must be open
  PgSqlRowType pgRowType = PgSqlRowType.GetRowType("tperson", conn);
  PgSqlRow pgRow = pgRowType.Parse("(''Robert'',30)");
  //provide parameters to command and execute it
  pgCommand.Parameters.Add("ID",4);
  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
  'Note that connection must be open
  Dim pgRowType As PgSqlRowType = PgSqlRowType.GetRowType("tperson", conn)
  Dim pgRow As PgSqlRow = pgRowType.Parse("(''Robert'',30)")
  '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

PgSqlRowType Class
PgSqlRowType Members
Parse Method

Send Feedback