C# sqlite数据库增删改查
时间: 2024-09-06 18:05:13 浏览: 28
C# 中使用 SQLite 数据库进行增删改查操作,你可以通过 NuGet 包 `System.Data.SQLite` 来集成 SQLite 的支持。以下是基本的操作步骤:
1. **安装 SQLite**:
首先,在项目中安装 System.Data.SQLite 的包,可以在 Package Manager Console 输入以下命令:
```
Install-Package System.Data.SQLite
```
2. **连接数据库**:
使用 `SQLiteConnection` 类创建一个数据库连接,例如:
```csharp
string connectionString = "Data Source=myDatabase.db;Version=3";
using (var connection = new SQLiteConnection(connectionString))
{
connection.Open();
// 连接打开,可以执行 SQL 操作了
}
```
3. **插入数据**(INSERT):
```csharp
string sqlInsert = "INSERT INTO MyTable (Column1, Column2) VALUES (@value1, @value2)";
using (var command = new SQLiteCommand(sqlInsert, connection))
{
command.Parameters.AddWithValue("@value1", value1);
command.Parameters.AddWithValue("@value2", value2);
command.ExecuteNonQuery(); // 执行插入
}
```
4. **查询数据**(SELECT):
```csharp
string sqlSelect = "SELECT * FROM MyTable WHERE Column1 = @searchValue";
using (var command = new SQLiteCommand(sqlSelect, connection))
{
command.Parameters.AddWithValue("@searchValue", searchValue);
var reader = command.ExecuteReader();
while (reader.Read())
{
// 处理每一行数据
}
}
```
5. **更新数据**(UPDATE):
```csharp
string sqlUpdate = "UPDATE MyTable SET Column1 = @newValue WHERE ID = @id";
using (var command = new SQLiteCommand(sqlUpdate, connection))
{
command.Parameters.AddWithValue("@newValue", newValue);
command.Parameters.AddWithValue("@id", id);
command.ExecuteNonQuery();
}
```
6. **删除数据**(DELETE):
```csharp
string sqlDelete = "DELETE FROM MyTable WHERE Column1 = @deleteValue";
using (var command = new SQLiteCommand(sqlDelete, connection))
{
command.Parameters.AddWithValue("@deleteValue", deleteValue);
command.ExecuteNonQuery();
}
```
记得处理异常,并确保在完成操作后关闭数据库连接。