Browse by Tags

data type mismatch issue in a parametrized insert

cmd2.CommandText = "select * from " + TableName; reader = cmd2.ExecuteReader(); if (reader != null) { String s = "".PadLeft(reader.FieldCount - 1, 'X').Replace("X", "?,") + "?"; cmd.CommandText = String.Format("{0} into {1} values ({2})"...

Posted to General (Forum) by pentium10 on 02-12-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
Char is inserted into table as an Integer

SQLite inserts a Character as an Integer interpreted as the decimal ASCII value. This happens if you do not specify the DBtype of a parameter used in a SQLiteCommand. You can verify the problem with the code below. All the SQLiteCommands insert a Character/String as asumed. But the last one inserts a...

Posted to Bugs (Forum) by kws on 08-25-2009
Data type not inherited when creating tables by CREATE TABLE x AS SELECT * FROM y WHERE ...

I've found this BUG with1.0.65, later I checked with 1.0.63, but it performs the same. When creating tables using CREATE TABLE x AS SELECT * FROM y WHERE ... the created table does not inherit the data types of the original table! for example: The original 'BinaryAttachment' is: CREATE TABLE...

Posted to Bugs (Forum) by BilikTamas on 07-30-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
Reading Blob data from a table

I have a SQLite table with a blob data. I would like to do the following, but it doesn't work: String con = String.Format("Data Source={0};UTF8Encoding=True;Version=3;", open.FileName); SQLiteConnection sql_con; SQLiteCommand sql_cmd; SQLiteDataAdapter DB; DataSet DS = new DataSet(); sql_con...

Posted to How To (Forum) by bradak on 03-27-2009
How to compare varchar() datatype with numeric value.

Dear All, I have a column named amount1 varchar(50) in table tbTest . The column have value '0.00' My query is Select * from tbTest WHERE IfNull(amount1, 0) > 0 I expect this query should not return any rows but its returning.How to solve the problem.Is there any way to cast or conversion...

Posted to How To (Forum) by Min on 11-26-2008
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 2 (12 items) 1 2 Next >