Click here to Skip to main content
Click here to Skip to main content


, 10 Mar 2007 CPOL
Rate this:
Please Sign up or sign in to vote.
A GUI for SQLite in .NET
Screenshot - SQLiteGUI.gif


This article describes how to create, insert, update SQLite database from GUI.


SQLite GUI is a simple GUI for creating a new SQLite database and opening an existing SQLite database. It can also create, delete and update tables in the database. All the available tables in the database are shown. The records of various types including BLOB are displayed in the DataGridView. And the data in the DataGridView can be printed. The schema for all the available tables is displayed.


The SQLite.NET assembly is available here. Add the reference SQLite.Net.dll to the project and use the namespace Finisar.SQLite to work with SQLite.


Finisar.SQLite is an ADO.NET Data Provider for accessing SQLite-Databases using the .NET-Framework. In SQLite, a complete database is stored in a single disk file. SQLite is zero-configuration - no setup or administration needed. SQLite itself is "a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine" (quoted from the Website). The Finisar.SQLite Data Provider is an easy way to use the SQLite-Database in .NET languages like C# and VB.NET.

Sample Code

      //Connection string 
      string connString = String.Format("Data Source={0};New=False;Version=3", DB_NAME);
      //Connecting database
      SQLiteConnection sqlconn = new SQLiteConnection(connString);
      //Open the connection

      string CommandText = "Select name from sqlite_master;";

      //SQLiteDataAdapter to fill the DataSet
      SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(CommandText, sqlconn);

      //Get the collection of rows from the DataSet
      DataRowCollection dataRowCol = ds.Tables[0].Rows;

      //Add the tables available in the DB to the combo box
      foreach (DataRow dr in dataRowCol)
      //Close the Connection

catch (SQLiteException sqlex)

To Do

Update cannot be performed on table without primary key. The SelectCommand must also return at least one primary key or unique column. If none are present, an InvalidOperation exception is generated, and the commands are not generated. The alternative way is create select, insert and update command for that particular table. Refer to MSDN. It will be available in the next version of SQLite GUI.


  • 10th March, 2007: Initial post


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Udhaya Kumar.D
India India
No Biography provided

Comments and Discussions

QuestionUpdates for .NET 4.5.1 ? Pinmemberkiquenet.com31-Jan-14 5:36 
GeneralMy vote of 2 PinprofessionalMarco Bertschi14-Jun-13 3:07 
QuestionMultiple User Access To SQLite DB? PinmemberFatih BURAL14-Sep-12 10:32 
AnswerRe: Multiple User Access To SQLite DB? Pinmemberadriancs21-Oct-12 20:10 
GeneralRe: Multiple User Access To SQLite DB? PinmemberFatih BURAL10-Nov-12 11:09 
GeneralRe: Multiple User Access To SQLite DB? Pinmemberjbmckim30-Nov-12 12:58 
GeneralRe: Multiple User Access To SQLite DB? Pinmemberadriancs30-Nov-12 13:54 
GeneralWindows 7 Pinmemberjimmygyuma13-Nov-09 11:49 
GeneralRe: Windows 7 Pinmemberkazmirci23-Dec-09 22:39 
GeneralExcellent Pinmemberloyal ginger6-Oct-09 7:11 
GeneralRe: Excellent PinmemberUdhaya Kumar.D22-Nov-09 23:53 
GeneralUpdate problem Pinmemberjimmygyuma13-Jun-09 8:38 
GeneralProblem PinmemberZergushonok28-Oct-08 6:49 
GeneralRe: Problem PinmemberUdhaya Kumar.D4-May-09 7:23 
QuestionReadonly Mode Pinmembercawoodm17-Sep-08 10:49 
AnswerRe: Readonly Mode PinmemberUdhaya Kumar.D30-Sep-08 6:25 
GeneralPassword Protection PinmemberH0G4N3-Dec-07 10:09 
Generaluse System.Data.SQLite in the program PinmemberVirusCamp12-Jun-07 21:33 
GeneralRe: use System.Data.SQLite in the program PinmemberVirusCamp12-Jun-07 21:42 
GeneralA little problem Pinmembernemopeti25-Mar-07 0:12 
GeneralRe: A little problem PinmemberUdhaya Kumar.D25-Mar-07 22:55 
GeneralRe: A little problem [modified] PinmemberMad_Mike10-Apr-07 5:31 
GeneralRe: A little problem Pinmemberstuttgart28-Sep-07 13:16 
GeneralYou can get sqllite3.dll at Pinmemberwombleme5-Oct-10 5:25 
GeneralSimple to the point Pinmemberspoodygoon10-Mar-07 11:38 
GeneralSimilar project PinmemberGeorge_Saveliev10-Mar-07 5:36 
NewsRe: Similar project PinmemberAndré Ziegler10-Mar-07 8:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150301.1 | Last Updated 10 Mar 2007
Article Copyright 2007 by Udhaya Kumar.D
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid