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. |
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