Add data to a SQLite Database with C# (16/23)



Add data to a SQLite Database with C# (16/23)

Add data to a SQLite Database with C# (16/23)

In this video we will cover how to add data to tables in a SQLite database for your application.

Basic Steps:
Display SQLite Toolbox and DB Browser
Use SQLite library
Generate connection string
SQLiteConnection
SQLiteCommand
Execute SQL insert into statement to populate database
Data from array
Data from CSV file
View data from both sources
SQLite Toolbox
DB Browser

C# .NET
Windows Form Application
Visual Studio
SQLite
Using statement
Static Class
Static Method
Static Variable
For loop
SQL insert into
Command parameters