ado.net删除行并更新到数据源

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

public class Program
{
    public static void Main()
    {
        string connectionString = "your_connection_string";
        string deleteQuery = "DELETE FROM TableName WHERE Condition = @Param";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            using (SqlCommand command = new SqlCommand(deleteQuery, connection))
            {
                command.Parameters.AddWithValue("@Param", "some_value");

                int rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine("Deleted rows: " + rowsAffected);
            }

            // 如果需要更新数据源，可以执行以下代码
            // using (SqlDataAdapter adapter = new SqlDataAdapter())
            // {
            //     adapter.DeleteCommand = new SqlCommand(deleteQuery, connection);
            //     adapter.DeleteCommand.Parameters.AddWithValue("@Param", "some_value");
            //     adapter.Update(dataTable);
            // }
        }
    }
}