Browse by Tags

Concurrency errors on datatime column

If I include a column in my dataset that I have defined as a datetime data type, I eventually get concurrency errors from the datagridview. The dataset includes as I mentioned a datetime data type. The grid is bound via the usual tableadapter and bindingsource. The grid allows deletes. When the delete...

Posted to Bugs (Forum) by glennwelker on 02-22-2010
Change DateTime Format On Insert

I am using datatables to make large changes to my database, however the datatable class is changing the format of the date, so that when i try to access the data i get the classic "String is not a valid DateTime" error. So i am wondering if there is some SQL that i can use in an INSERT statement...

Posted to How To (Forum) by alex21 on 02-10-2010
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
DataReader can not read DateTime data that was imported with strftime

Hi, I'm a newbee with SQLite and its ADO.Net provider. I'm using 1.0.60 ADO.Net Provider and SQLite 3.6.11 (but I also tried with 3.6.3 and its the same result) I just did migrate the Northwind database to sqlite and I was making some tests. Unfortunately I'm encountering some problems with...

Posted to Bugs (Forum) by silversens on 03-07-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
Bug or My Error?

This is probably just my ignorance. If I try to execute the following query in the designer in VS 2005, the program crashes and restarts: SELECT * FROM tablename WHERE date(DateVar) BETWEEN '2008-02-01' AND '2008-10-31' ORDER BY Var1,Var2 Assume that Var1 and Var2 are string variables...

Posted to Bugs (Forum) by rkulp on 11-15-2008
Formatting date time in the where clause for an update query

I am writingn an update query where I have to specify a date time value to correctly update the right row in a table. The date time is currently stored as 5/20/2008 12:00:00 AM. When I write my update query and use this particular date time, however, it does not update the row. My query looks like the...

Posted to How To (Forum) by bd_epa on 03-05-2008

Page 1 of 2 (12 items) 1 2 Next >