dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlRowType Class / GetRowType(String,PgSqlConnection) Method
Name of the type to describe.
Connection to be used to obtain metadata information.
Example

In This Topic
GetRowType(String,PgSqlConnection) Method
In This Topic
Returns PgSqlRowType object that corresponds to given name.
Syntax
'Declaration
 
Public Shared Function GetRowType( _
   ByVal typeName As String, _
   ByVal connection As PgSqlConnection _
) As PgSqlRowType
 

Parameters

typeName
Name of the type to describe.
connection
Connection to be used to obtain metadata information.

Return Value

PgSqlRowType with given name.
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 = PgSqlRow.Parse(pgRowType,"(''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 = PgSqlRow.Parse(pgRowType, "(''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