SQLite GUI

SQLite GUI is a simple user Interface for SQLite dB. You can create / open a dB and also can create, delete and update tables in the database. All the tables in a database are shown in the DataGridView .
Data Types including BLOB are supported.

Dependencies
Add the reference SQLite.Net.dll to the project and use the namespace Finisar.SQLite to work with SQLite.

Finisar.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 sqlite.org Website). The Finisar.SQLite Data Provider is an easy way to use the SQLite-Database in .net Languages like C# and VB.net.

Screenshot
sqliteGui Screenshot

Sample Code

try
{
//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
sqlconn.Open();

//Query
string CommandText = “Select name from sqlite_master;”;

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

//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)
{
tablecombobox.Items.Add(dr[“name”]);
}

//Close the Connection
sqlconn.Close();

}
catch (SQLiteException sqlex)
{
MessageBox.Show(sqlex.Message);
}

To Do/Known Issues

Update cannnot 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 MSDN .It will be available in the next version of SQLite GUI.

Download Code

Published in CodeProject.com on March 10, 2007

3 Replies to “SQLite GUI”

  1. I am new to programming. I am using CodeoGear’s 3rdRail IDE for Ruby on Rails web application programming. In it, I am using Sglite 3. I love it but would like to use a gui to look at data in the tables. But, I do not know how to setup this gui to accomplish it. Help me, please.

    In addition, this gui seems to be just what I am looking for, if I could only get it setup for Ruby on Rails use.

    James

Leave a Reply to James Galloway Cancel reply

Your email address will not be published. Required fields are marked *