Parameters
- i
Return Value
The value to return.
static void GetMyFieldType(SQLiteConnection myConnection) { SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM AllTypes"); cmd.Connection = myConnection; myConnection.Open(); try { SQLiteDataReader reader = cmd.ExecuteReader(); reader.Read(); for (short i = 0; i < reader.FieldCount; i++) { object someValue = reader.GetProviderSpecificValue(i); Console.Write(reader.GetProviderSpecificFieldType(i).FullName + " : "); Console.WriteLine(someValue.ToString()); } reader.Close(); } finally { myConnection.Close(); } }
Shared Sub GetMyFieldType(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() For i As Short = 0 To reader.FieldCount - 1 Dim someValue As Object = reader.GetProviderSpecificValue(i) Console.Write((reader.GetProviderSpecificFieldType(i).FullName & " : ")) Console.WriteLine(someValue.ToString) Next i reader.Close() Finally myConnection.Close() End Try End Sub