Notes

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;

namespace ConsoleApp7
{
internal class Class1
{
static void Main(string[] args)
{


// Set up connection string and query string
string connectionString = "Data Source=(localdb)\MSSQLLocalDB; Initial Catalog = Northwind; Integrated Security = SSPI";
string queryString = "SELECT TOP 5 * FROM products ORDER BY Unitprice DESC";

// Set up connection and command objects
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);

// Open connection and execute query
connection.Open();
SqlDataReader reader = command.ExecuteReader();

// Iterate through results and print them out
while (reader.Read())
{
Console.WriteLine("{0}t{1}t{2}t{3}", reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetInt32(3));
}

// Close reader and connection
reader.Close();
connection.Close();
}
}
}
}