Gets the value of the specified column in its native format given the column name.
'Declaration
Public Overloads Overrides ReadOnly Property Item( _
ByVal As String _
) As Object
Parameters
- name
- The column name.
Property Value
The value of the specified column in its native format.
static void GetHireDate(SQLiteConnection myConnection) {
SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM emp");
cmd.Connection = myConnection;
myConnection.Open();
try {
SQLiteDataReader reader = cmd.ExecuteReader();
reader.Read();
DateTime recievedTime = (DateTime)reader["hiredate"];
reader.Close();
}
finally {
myConnection.Close();
}
}
Shared Sub GetHireDate(ByVal myConnection As SQLiteConnection)
Dim cmd As New SQLiteCommand("SELECT * FROM emp")
cmd.Connection = myConnection
myConnection.Open()
Try
Dim reader As SQLiteDataReader = cmd.ExecuteReader
reader.Read()
Dim recievedTime As DateTime = CDate(reader("hiredate"))
reader.Close()
Finally
myConnection.Close()
End Try
End Sub