dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlDataReader Class / GetChar Method / GetChar(Int32) Method
Example

In This Topic
    GetChar(Int32) Method
    In This Topic
    Gets the value of the specified column as a single character.
    Syntax
    'Declaration
     
    Public Overloads Overrides Function GetChar( _
       ByVal i As Integer _
    ) As Char
    public override char GetChar( 
       int i
    )

    Parameters

    i

    Return Value

    The value of the specified column as a character.
    Example
    static void GetMyChar(PgSqlConnection myConnection) {
      PgSqlCommand cmd = new PgSqlCommand("SELECT * FROM Test.AllTypes");
      cmd.Connection = myConnection;
      myConnection.Open();
      try {
        PgSqlDataReader reader = cmd.ExecuteReader();
        reader.Read();
        char recievedChar = reader.GetChar(reader.GetOrdinal("CharCol"));
        reader.Close();
      }
      finally {
        myConnection.Close();
      }
    }
    Shared Sub GetMyChar(ByVal myConnection As PgSqlConnection)
      Dim cmd As New PgSqlCommand("SELECT * FROM Test.AllTypes")
      cmd.Connection = myConnection
      myConnection.Open()
      Try
        Dim reader As PgSqlDataReader = cmd.ExecuteReader
        reader.Read()
        Dim recievedChar As Char = reader.GetChar(reader.GetOrdinal("CharCol"))
        reader.Close()
      Finally
        myConnection.Close()
      End Try
    End Sub
    See Also