using System;

using System.Collections.Generic;

using System.Data.OleDb;

using System.Net;

using System.Threading;

​

using HtmlAgilityPack;

​

class Program

{

    static void Main()

    {

        // List of names and zip codes

        List<string> names = new List<string> { "CALLISTER, BERNADETTE" };

        List<string> zipCodes = new List<string> { "98110" };

​

        // Connection string for MS Access

        string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Path\\To\\Your\\Database.accdb;Persist Security Info=False;";

​

        // Loop through names and zip codes

        foreach (var name in names)

        {

            foreach (var zipCode in zipCodes)

            {

                // Construct URL

                string url = $"https://www.fec.gov/data/receipts/individual-contributions/?two_year_transaction_period=2024&min_date=01%2F01%2F2023&max_date=12%2F31%2F2024&zip={zipCode}&contributor_name={WebUtility.UrlEncode(name)}";

​

                // Scraping data

                string html = DownloadHtml(url);

​

                // Process the HTML using HtmlAgilityPack

                HtmlDocument document = new HtmlDocument();

                document.LoadHtml(html);

​

                // Extract relevant data and insert into MS Access database

                // (Implement this part based on the actual structure of the website)

​

                // Pause to avoid overloading the server

                Thread.Sleep(5000); // 5 seconds delay

            }

        }

    }

​

    static string DownloadHtml(string url)

    {

        using (WebClient client = new WebClient())

        {

            return client.DownloadString(url);

        }

    }

}

​