Item Property (DbDataReaderBase)
Gets the value of the specified column in its native format given the column name.
| Overload | Description |
|---|
| Item(String) | Gets the value of the specified column in its native format given the column name. |
| Item(Int32) | Gets the value of the specified column in its native format given the column ordinal. |
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