dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlRowType Class / Parse Method
String that contains data for PgSqlRow.
Example

In This Topic
    Parse Method (PgSqlRowType)
    In This Topic
    Converts a PgSqlRow from its string representation.
    Syntax
    'Declaration
     
    Public Function Parse( _
       ByVal rowValue As String _
    ) As PgSqlRow
    public PgSqlRow Parse( 
       string rowValue
    )

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