using System;

using System.Data.SqlClient;

using System.Text;

​

public class Program

{

    public static void Main()

    {

        string sql = "SELECT * FROM Customers WHERE Country = 'UK'";

        StringBuilder Output = new StringBuilder();

        using (SqlConnection connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerNorthwind()))

        {

            SqlCommand command = new SqlCommand(sql, connection);

            connection.Open();

            using (SqlDataReader dataReader = command.ExecuteReader())

            {

                while (dataReader.Read())

                {

                    for (int i = 0; i < dataReader.FieldCount; i++)

                    {

                        Output.AppendFormat("{0}: {1}{2}", dataReader.GetName(i), dataReader.GetValue(i), (i != dataReader.FieldCount - 1) ? ", " : "");

                    }

​

                    Output.AppendLine();

                }

            }

​

            Console.WriteLine(Output);

        }

    }

}