dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteDataReader Class / GetFloat Method / GetFloat(Int32) Method
Example

In This Topic
    GetFloat(Int32) Method
    In This Topic
    Gets the value of the specified column as a single-precision floating point number.
    Syntax
    'Declaration
     
    Public Overloads Overrides Function GetFloat( _
       ByVal i As Integer _
    ) As Single
    public override float GetFloat( 
       int i
    )

    Parameters

    i

    Return Value

    The value of the specified column.
    Remarks

    Call IsDBNull to check for null values before calling this method.

    Example
    static void GetMyFloat(SQLiteConnection myConnection) {
      SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM AllTypes");
      cmd.Connection = myConnection;
      myConnection.Open();
      try {
        SQLiteDataReader reader = cmd.ExecuteReader();
        reader.Read();
        float recievedFloat = reader.GetFloat(reader.GetOrdinal("FloatCol"));
        reader.Close();
      }
      finally {
        myConnection.Close();
      }
    }
    Shared Sub GetMyFloat(ByVal myConnection As SQLiteConnection)
      Dim cmd As New SQLiteCommand("SELECT * FROM AllTypes")
      cmd.Connection = myConnection
      myConnection.Open()
      Try
        Dim reader As SQLiteDataReader = cmd.ExecuteReader
        reader.Read()
        Dim recievedFloat As Single = reader.GetFloat(reader.GetOrdinal("FloatCol"))
        reader.Close()
      Finally
        myConnection.Close()
      End Try
    End Sub
    See Also