in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » datatype » datetime (RSS)

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

  • Problems in insert and retriving dates

    I am new user of sqlite I have the following table CREATE TABLE Sighting ( SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, SpeciesId integer, LocationId integer, SightingDate date, Note nvarchar(100) ); and the following insert INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) VALUES...
    Posted to How To (Forum) by Prachi on 09-11-2009

  • 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

  • Re: DataType Mappings ("DATETIME" --> DbType.DateTime and "BOOLEAN" --> DbType.Boolean)

    Hello, I was using the conversion code from System.Data.SQLite.SQLiteConvert (SQLiteConvert.cs) to convert some types and I'm a bit puzzled over two types: "DATETIME" and "BOOLEAN": The "DATETIME" from/to DbType.DateTime conversion: SQLiteConvert.DbTypeToTypeName( DbType...
    Posted to General (Forum) by folderol on 06-25-2009

  • SQLiteDataAdapter.Fill(datatable)

    Hi everyone i have a problem with the sqlite data adapter when i try to execute fill() method for filling the datatable; when querying the DateTime column in table where that column is NULL. I get the following exception: String was not recognized as a valid DateTime. i found somewhere that...
    Posted to Bugs (Forum) by leo_Mostar on 11-21-2008
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems