sqlite c# 数据增删
时间: 2024-09-27 17:06:59 浏览: 4
SQLite是一个轻量级的关系型数据库管理系统,适合于嵌入式设备或对性能要求不高的应用。在C#中使用SQLite,你可以通过System.Data.SQLite库来操作数据库。以下是基本的数据增删操作步骤:
1. **连接数据库**:
```csharp
using SQLiteConnection conn = new SQLiteConnection("Data Source=mydatabase.db;Version=3;");
conn.Open();
```
这里的`mydatabase.db`是你的SQLite数据库文件名。
2. **创建表**:
```csharp
string createTableQuery = "CREATE TABLE IF NOT EXISTS Users (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Email TEXT)";
SQLiteCommand command = new SQLiteCommand(createTableQuery, conn);
command.ExecuteNonQuery();
```
3. **插入数据**:
```csharp
string insertQuery = "INSERT INTO Users (Name, Email) VALUES (@name, @email)";
SQLiteParameter[] parameters = { new SQLiteParameter("@name", DbType.String), new SQLiteParameter("@email", DbType.String) };
parameters[0].Value = "John Doe";
parameters[1].Value = "john@example.com";
SQLiteCommand insertCommand = new SQLiteCommand(insertQuery, conn);
insertCommand.Parameters.AddRange(parameters);
insertCommand.ExecuteNonQuery();
```
4. **查询数据**:
```csharp
string selectQuery = "SELECT * FROM Users WHERE Email = @email";
SQLiteCommand selectCommand = new SQLiteCommand(selectQuery, conn);
selectCommand.Parameters.AddWithValue("@email", "john@example.com");
SQLiteDataReader reader = selectCommand.ExecuteReader();
while (reader.Read())
{
Console.WriteLine($"Id: {reader["Id"]}, Name: {reader["Name"]}, Email: {reader["Email"]}");
}
reader.Close();
```
5. **删除数据**:
```csharp
string deleteQuery = "DELETE FROM Users WHERE Id = @id";
SQLiteParameter parameter = new SQLiteParameter("@id", 1); // 示例ID
SQLiteCommand deleteCommand = new SQLiteCommand(deleteQuery, conn);
deleteCommand.Parameters.Add(parameter);
deleteCommand.ExecuteNonQuery();
```
6. **关闭连接**:
```csharp
conn.Close();
```