in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows
All Tags » sqlite (RSS)

Browse by Tags

  • Importance of the primary key

    Is the rowid in sqlite tables considered as a primary key to the table, or do I need to create another separate column to use as a primary key. Thank you
    Posted to How To (Forum) by Sakyamuni on 03-29-2008

  • How to speed up dataGridView filling

    Hi, I'm having a problem with slow dataGridView filling. My table has ~400000 records and it takes about 53 seconds to load the data in my code, while in SqliteAdmin it takes only 9 seconds. Here is the code : DataSet ds = new DataSet(); string sql = "SELECT rowid, length,sec,usec,sip,dip,protocol...
    Posted to How To (Forum) by Sakyamuni on 03-29-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

  • Connection String Problem

    I am trying to create a new SQLiteConnection which connects to a database on a network drive. Here is some sample code: scn = new SQLiteConnection ( "Data Source ='" + databasePath + "'" ); scn.Open(); The databasePath is L:\Priv\developer\virtualbeach\csc_data\beachmanager...
    Posted to General (Forum) by bd_epa on 03-05-2008

  • Soundex Function

    Hi, I've seen here http://www.sqlite.org/lang_expr.html that it's available a method to compute the Soundex of a string. By default this function is not available, unless you pass the "-DSQLITE_SOUNDEX=1" parameter to the compiler. I use your ADO.NET dll in my projects. Now I need the...
    Posted to How To (Forum) by ottomano on 03-05-2008

  • What datatype should i use for representing a number with a floating point? (float, double..)

    Hello everyone, I'm having some trouble getting a float value out of a table. Although i can add a floating point value correctly (ex: 0.5) and see the correct value using a tool like SQLite Database Browser, i always get value "0.0" when i read it from my application. I have tried: double...
    Posted to General (Forum) by linc on 02-28-2008

  • Change type of field

    In mysql i used ALTER TABLE `te` CHANGE `4` `ga` VARCHAR ( 2 ) NOT NULL what the sql lite equaliant
    Posted to How To (Forum) by thomaxz on 01-31-2008

  • Re: using a dataset to create a new sqlite db

    Yes you can do it programatically. You would basically just have to loop through the tables in the dataset, read out the schema, and build your create table and insert statements. I've done this in a fairly generic sense for some software I worked on recently where I receive datasets from a webservice...
    Posted to How To (Forum) by Nazguy on 12-18-2007

  • Supported CE platforms

    Hello, I'm developing an app for a denso-wave handheld, I got your engine to work with CE 5.0 CF 2 but I can't get it to work with a CE 4.1 CF 2 (the testce.exe app fails just after the second line of output) do you think CE 4.1 is supported? I know you don't support CF 1 but do you think...
    Posted to General (Forum) by alphac on 12-03-2007

  • Stream and System.IO.Packaging

    I'm just wondering if SQLite could be able to work against a stream and not a file. Would be cool to be able to have the database inside a System.IO.Packaging.Package. bjarte
    Posted to How To (Forum) by bjarte.skogoy on 10-11-2007
Page 1 of 2 (11 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems