designscas.blogg.se - Download sqlite expert personal

SqliteCmd.CommandText = "SELECT * FROM names" Var sqliteCmd = sqliteConn.CreateCommand() Var sqliteConn = new Source=c:\MyDB.db") The complete application looks like this. Here is the complete code listing for my DB, it runs a simple select and prints out each name in the namestable.

Right click on references -> Add Reference.

To add a reference to the SQLite DLL in your project preform the following actions under the solution explorer tab. Give it a name and choose a location to save.net 4) for my test, feel free to use whatever version you want. I am going to be creating a console application (using. Next up we need to create a blank VS2010 project to test our code in.

We will be using the DLL directly so if you don’t want to register it in the GAK you don’t have to. Please make a note of where you install SQLite to! Create a new VS2010 project This is simple enough, just download the right version of SQLite for your environment and run the installer.

Close SQLite Expert Personal as we are done for now.

In my case I created a table called names with a single entry “Richard Niemand”

Add some columns and data to the table.

Right click on the DB and select new table.

Click on the new database button and complete the prompt.

Once downloaded and installed fire up SQLite Expert Personal and follow these steps.

SQLite Expert Personal ( )Starting Simpleįirst let’s create our DB, this is simple and requires only using (SQLite Expert Personal).

This is a quick post on how to build your first SQLite C# (.net 4) application. I must admit this took me some time to work out and gave me a headache hopefully this post can save you the headache.