C#

string connectionString = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info={2};User ID={3};Password={4};",
                "Server", "DB", false, "DBUser", "DBPassword");
        SqlConnection conn = new SqlConnection(connectionString);
            conn.Open();

            SqlCommand sqlCommand = conn.CreateCommand();

            sqlCommand.CommandType = CommandType.Text;
            sqlCommand.CommandText = @"SELECT 'asd' AS strName, 'asdasd' AS strName, 'asdasdasd' AS strName";

            SqlDataAdapter da = new SqlDataAdapter(sqlCommand);

            DataTable test = new DataTable();
            da.Fill(test);

            foreach (DataColumn col in test.Columns)
            {
                Console.WriteLine(col.ColumnName);
            }