c#如何将包含文本之间空格的.dat文件按原样存储到sql server数据库中。

string filePath = "path/to/your/file.dat";
string[] lines = File.ReadAllLines(filePath);

string connectionString = "your_connection_string";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    foreach (string line in lines)
    {
        string insertQuery = "INSERT INTO YourTable (ColumnName) VALUES (@Value)";
        using (SqlCommand command = new SqlCommand(insertQuery, connection))
        {
            command.Parameters.AddWithValue("@Value", line);
            command.ExecuteNonQuery();
        }
    }
}