C# 清空SQLite数据表并添加新数据 - 代码示例

您可以使用以下代码来清空SQLite数据表内的数据并添加新的数据：\n\ncsharp\nusing System.Data.SQLite;\n\nstring connectionString = "Data Source=your_database.db;Version=3;";\nstring tableName = "your_table";\n\n// Clearing data from the table\nusing (SQLiteConnection connection = new SQLiteConnection(connectionString))\n{\n connection.Open();\n \n string clearTableQuery = $"DELETE FROM {tableName}";\n using (SQLiteCommand command = new SQLiteCommand(clearTableQuery, connection))\n {\n command.ExecuteNonQuery();\n }\n}\n\n// Adding new data to the table\nusing (SQLiteConnection connection = new SQLiteConnection(connectionString))\n{\n connection.Open();\n \n string insertDataQuery = $"INSERT INTO {tableName} (column1, column2) VALUES (@param1, @param2)";\n using (SQLiteCommand command = new SQLiteCommand(insertDataQuery, connection))\n {\n command.Parameters.AddWithValue("@param1", "value1");\n command.Parameters.AddWithValue("@param2", "value2");\n command.ExecuteNonQuery();\n }\n}\n\n\n请确保将your_database.db替换为您的SQLite数据库文件路径，your_table替换为您要清空和添加数据的数据表名称，并根据需要调整插入数据的查询和参数。\n\n这段代码首先与数据库建立连接，然后使用DELETE语句清空数据表内的数据。接下来，使用INSERT语句将新的数据插入到数据表中。