free SQLite Database Programming for Xamarin tutorial

FREE SQLITE DATABASE PROGRAMMING FOR XAMARIN TUTORIAL FREE

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.

FREE SQLITE DATABASE PROGRAMMING FOR XAMARIN TUTORIAL FREE

SQLite is an excellent database with good free admin tools.

Free SQLite Database Programming for Xamarin tutorial