System.Data.SQLite

Awesome! Thank you both. That was SO much faster!So these DbTransactions, are they unique to sqlite or are they used in all sql dbs'? Thanks again for helping the noob

I don't know if I doing something wrong, but I switch my code to use parameterized queries and I see no benefit as far as processing time. There are 185 recods being inserted here and it takes nearly a minutes. Something must be wrong. Any clues?        Dim FamCmd, MemCmd As ...

Oops. I only saw the first post, not the entire thread....

Just a guess, but trySQLiteCommand IDCmd = new SQLiteCommand(''Select last_insert_rowid();'', conn);

Okay, that's what I was afraid of :(Thanks for the info.

When I create a table adapter from a table, even though I specify a default value for a field, it is not reflected in the dataTable created by .NET. Is this standard behavior, or is there a bug or something?To clarify, here is a field I am creating:code39 BOOL NOT NULL DEFAULT TRUEWhen I generate the data table, I get this: see attached.So for ...

So what is the difference between using System.IO.File.Create() to create the file?

I found the issue. There was a field on my form that would sometimes contain a string value when it should alwasy be an integer value.Sorry! Thanks for the help.

Any luck on this? Do you want all the code?

I've got a SQLite db set up as follows:create table processes (    id INTEGER PRIMARY KEY AUTOINCREMENT,    name varchar,    source varchar,    destination varchar,    copy bool,    copy_folder varchar,    delete_days int,    ...