in

System.Data.SQLite

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

Browse by Tags

  • Problem with encoding

    I have a database that contains French characters like in this: Bâtiment The problem is that when I query it into a datatable using the SQLiteDataAdapter and then get the value of the field into a string, I get this: "B�timent" (doesn't show up in here but it's a black diamond with...
    Posted to How To (Forum) by Schroedingerscat on 11-16-2011

  • SQLITE_MAX_COLUMN

    Question: Is it possible to create a table with more than 3000 columns/fields? I found this environment variable (SQLITE_MAX_COLUMN) on the SQLite site and it appears to default to 2000 max columns but can be changed. However, I don't see any reference to it here so I'm not sure how to change...
    Posted to How To (Forum) by precipios on 09-12-2011

  • 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

  • Can't access data in TEXT field

    I've been trying to read data from a TEXT field, but the best I seem to be able to get is a string of rubbish characters. I think this means that the encoding needs to be specified somewhere, but I can't work out where. I'm able to get data from other field types (Int, etc), but just not...
    Posted to How To (Forum) by NickRogers on 06-18-2009

  • I'm a totally new user and need a DataGrid sample in VB.NET 2008

    I have used VB6 before and I'm totally new to SQLite and pretty new to VB.NET ... I successfully created a database, and inserted some data in my test project, so far so good. But, when I try to view the data in a datagrid I can't get it to work, eahh Anyone here who can share some VB.NET sample...
    Posted to How To (Forum) by Stefan57 on 05-31-2009
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems