使用C#删除CSV文件中的记录

using System;
using System.IO;
using System.Text;

public void DeleteRecordFromCSV(string filePath, string recordToDelete)
{
    // 读取原始CSV文件内容
    string[] lines = File.ReadAllLines(filePath, Encoding.UTF8);

    // 创建一个新的StringBuilder来存储修改后的CSV内容
    StringBuilder sb = new StringBuilder();

    // 遍历每一行记录
    foreach (string line in lines)
    {
        // 检查当前行是否包含要删除的记录
        if (!line.Contains(recordToDelete))
        {
            // 如果不包含，则将当前行添加到StringBuilder中
            sb.AppendLine(line);
        }
    }

    // 将修改后的CSV内容写回到原始文件中
    File.WriteAllText(filePath, sb.ToString(), Encoding.UTF8);
}

string filePath = "path/to/your/csv/file.csv";
string recordToDelete = "record to delete";

DeleteRecordFromCSV(filePath, recordToDelete);