You'll find several, depending on 32/64 bit and PC Framework 3.5/4.0 on the download page.Ĭreate a blank C# Winforms project.
ACCESSING SQLITE DATABASE INSTALL
First, you need to install the ADO driver. Now it's time to setup Visual C# 2010 Express or Visual Studio 2010. You should see the data.Īccessing the SQLite Database From a C# Program If all goes well, you'll have three rows imported into the friends table.Ĭlick Execute SQL and change tablename in SELECT * from tablename to friends and then click the Run SQL button. It asks you to click OK before importing, so click it then again. Enter the name of the table (friends) on the CSV tab and confirm the "First row contains column names" is ticked and "Fields Enclosed by" is set to none. Browse to the folder and select the file and then click Open in the dialog. On the database menu, click Import and choose Select File. Here's an example that you can cut and paste into a CSV file, which is just a text file with data in a comma delimited format. Populate a few rows, making sure that the values in idfriend are unique. Use Excel to create a spreadsheet with columns: idfriend, firstname, lastname, and age. You can select any column and right-click Edit Column/Drop Column or add a new column at the bottom and click the Add Column button. You can modify this definition at any time by selecting Structure on the tabs on the right side of the SQLite Manager window. It will display the SQL, which should look something like this.Ĭlick the Yes button to create the table, and you should see it on the left side under Tables(1). Call the first column idfriend, select INTEGER in the Data Type combo and click the Primary Key> and Unique? checkboxes.Īdd three more columns: firstname and lastname, which are type VARCHAR, and age, which is INTEGER. Next, define a few columns and populate it from a CSV file. Create a simple table and call it "friends" (type it in the box on the top). You'll see the Window caption has the path to the file. The database is stored in the MyDatabase.sqlite file, in whatever folder you select. From the Database menu, create a new database. Otherwise, visit the SQLite-manager website.Īfter SQLite Manager is installed and Firefox restarted, access it from the Firefox Web Developer menu off the main Firefox menu. If you have Firefox installed, select Add-ons, then Extensions from the pull-down menu at the top of the Firefox screen. This tutorial uses SQLite Manager, which is an extension for the Firefox browser.
SQLite is an excellent database with good free admin tools.
0 kommentar(er)
