Insert data into SQLite DB in C#
Visual Studio
C#
Simple way to insert data into SQLite DB in C#
Here's a step-by-step guide on how to insert data into an SQLite database in C#:
- Install the System.Data.SQLite NuGet package:
Install-Package System.Data.SQLite
- Create an SQLite database:
using System.Data.SQLite;
class Program
{
static void Main()
{
string connectionString = "Data Source=YourDatabase.db;Version=3;";
SQLiteConnection.CreateFile("YourDatabase.db");
}
}
- Open a connection to the SQLite database:
using System.Data.SQLite;
class Program
{
static void Main()
{
string connectionString = "Data Source=YourDatabase.db;Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
connection.Open();
// Insert data here
}
}
}
- Insert data into the database:
using System;
using System.Data.SQLite;
class Program
{
static void Main()
{
string connectionString = "Data Source=YourDatabase.db;Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
connection.Open();
string insertSql = "INSERT INTO users (username, email) VALUES (@username, @email)";
using (SQLiteCommand cmd = new SQLiteCommand(insertSql, connection))
{
cmd.Parameters.AddWithValue("@username", "john_doe");
cmd.Parameters.AddWithValue("@email", "[email protected]");
cmd.ExecuteNonQuery();
}
}
}
}
- Close the connection:
connection.Close();
Loading...
Sorry! No comment found:(
There is no comment to show for this.
Leave your comment
Tested Versions
- Visual Studio 2022
- .NET 4.6