public void DeleteAllTableData(string tableName)
{
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString = @"Data Source=" + databaseFile + ";Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connString))
{
connection.Open();
//SQLiteDataReader reader = null;
string queryString = "DELETE FROM "+tableName;
SQLiteCommand command = new SQLiteCommand(queryString, connection);
// command.Parameters.AddWithValue("@id_value", id);
//SqlDataAdapter dataAdapter = new SqlDataAdapter(queryString, connection.ConnectionString); //connection.ConnectionString is the connection string
command.ExecuteNonQuery();
}//close of using..
}