in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Browse by Tags

  • How to convert excel datetimes using tableadapter?

    Here's my question: I have an SQLite table containing Excel datetimes e.g. 40057.0069444444 (old OLE format), stored in SQlite db in Double format. Now I want to show them in a TableGridView using a tableadapter. This doesn't work because .net can't convert from Double numbers to the .net...
    Posted to General (Forum) by andy2m on 01-30-2010
  • Re: SQLiteDataAdapter.Fill(datatable)

    Leo, I get the same message when using dataAdapter.fill(). While I couldn't solve it properly, i used CREATE TABLE (myDatetimeField TEXT) instead. But it translates time to my timezone (dd/mm/yyyy hh:mm:ss) so i cannot sort on this field. Thus far, i just managed to avoid a program crash What about...
    Posted to Bugs (Forum) by Lionel on 08-26-2009
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems