Read data from Progress database using .NET

using System;
using System.Data;
using System.Data.Odbc;

namespace ProgressDatabaseReaderExample
{
    class Program
    {
        static void Main(string[] args)
        {
            // Define the connection string for the Progress database
            string connectionString = "DSN=ProgressDSN;UID=Username;PWD=Password;";

            // Define the SQL statement to select data from the Progress database
            string sql = "SELECT * FROM Customer WHERE CustomerID = ?";

            // Define the parameter value for the SQL statement
            string customerID = "12345";

            // Create a new instance of the OdbcConnection class
            using (OdbcConnection connection = new OdbcConnection(connectionString))
            {
                // Open the connection to the Progress database
                connection.Open();

                // Create a new instance of the OdbcCommand class
                using (OdbcCommand command = new OdbcCommand(sql, connection))
                {
                    // Define the parameter value for the SQL statement
                    command.Parameters.AddWithValue("@CustomerID", customerID);

                    // Create a new instance of the OdbcDataAdapter class
                    using (OdbcDataAdapter adapter = new OdbcDataAdapter(command))
                    {
                        // Create a new instance of the DataTable class
                        DataTable dataTable = new DataTable();

                        // Fill the DataTable with the data from the Progress database
                        adapter.Fill(dataTable);

                        // Loop through each row in the DataTable
                        foreach (DataRow row in dataTable.Rows)
                        {
                            // Print the data to the console
                            Console.WriteLine("{0} {1} {2} {3} {4} {5}", row["CustomerID"], row["CustomerName"], row["Address"], row["City"], row["State"], row["Zip"]);
                        }
                    }
                }
            }

            Console.WriteLine("Data has been read from the Progress database.");
            Console.ReadLine();
        }
    }
}