Parameters
- i
Return Value
The value of the specified column as a character.
static void GetMyChar(SQLiteConnection myConnection) { SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { SQLiteDataReader reader = cmd.ExecuteReader(); reader.Read(); char recievedChar = reader.GetChar(reader.GetOrdinal("CharCol")); reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyChar(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 recievedChar As Char = reader.GetChar(reader.GetOrdinal("CharCol")) reader.Close() Finally myConnection.Close() End Try End Sub