Run your application and click on the button. We are ready, now lets cleanup and close our connection: Note - This project has previous been known as 'SQLite Browser' and 'Database Browser for SQLite'. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface. String myreader = sqlite_datareader.GetString(0) DB Browser for SQLite is a light GUI editor for SQLite databases, built on top of Qt. Print out the content of the text field: While (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read The SQLiteDataReader allows us to run through the result lines: Sqlite_datareader = sqlite_cmd.ExecuteReader() Now the SQLiteCommand object can give us a DataReader-Object: Sqlite_cmd.CommandText = "SELECT * FROM test" But how do we read something out of our table ? Sqlite_cmd.CommandText = "INSERT INTO test (id, text) VALUES (2, 'Test Text 2') " Sqlite_cmd.CommandText = "INSERT INTO test (id, text) VALUES (1, 'Test Text 1') " Lets insert something into our new table: Sqlite_cmd.CommandText = "CREATE TABLE test (id integer primary key, text varchar(100)) " Let the SQLiteCommand object know our SQL-Query: Sqlite_cmd = sqlite_conn.CreateCommand() Sqlite_conn = new SQLiteConnection( "Data Source=database.db Version=3 New=True Compress=True ") - As C# is purely object-oriented the following lines must be put into a class: Private void Choose_Btn_click( object sender, EventArgs e) Right-click on your application and select "Open folder in your window application" and then go to:īIN -> Debug and extract your application here.Īfter this again right-click on your application and select "Add reference" and go to:īrowser -> BIN -> Debug and select DLL file (Sqlite Net.dll).ĭouble-click on the button and write the following code. Open your Visual Studio and select new project and in Visual C# select "Windows Forms Application" and provide the name as Sqlite and click on OK. The download first link is a ZIP file so you extract this file to your application in the debug folder. There is a link, from this link you can get a DLL file link and at this link you go to the download section and download the latest version. Basically C# doesn't support Sqlite itself so we need a third-party DLL to connect to a Sqlite database. Most of mobile and small databases don't require a server and if we want to make a standalone application for one computer that doesn't depend on another server then Sqlite is perfect for us.įor more information about Sqlite you can go to this link: Sqlite. So we don't require any server for a Sqlite database. We use Sqlite because all ther other databases that we use generally require a server and Sqlite is a database that we can embed within our system. Here I will explain how to use and connect to Sqlite in a Windows application.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |