已将多条记录添加到DataSet，但只有一条记录存储在数据库(C#)中

using System;
using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "your_connection_string";
        string selectQuery = "SELECT * FROM your_table";
        string updateQuery = "UPDATE your_table SET column1 = @column1, column2 = @column2 WHERE id = @id";

        // 创建连接对象和DataAdapter对象
        using (SqlConnection connection = new SqlConnection(connectionString))
        using (SqlDataAdapter adapter = new SqlDataAdapter(selectQuery, connection))
        {
            // 创建DataSet和DataTable
            DataSet dataSet = new DataSet();
            DataTable dataTable = new DataTable();

            // 填充DataSet
            adapter.Fill(dataSet, "your_table");
            dataTable = dataSet.Tables["your_table"];

            // 修改DataTable中的数据
            foreach (DataRow row in dataTable.Rows)
            {
                row["column1"] = "new_value";
                row["column2"] = "new_value";
            }

            // 更新数据库
            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter);
            adapter.UpdateCommand = commandBuilder.GetUpdateCommand();
            adapter.Update(dataSet, "your_table");
        }
    }
}