Ejecutar una sentencia SELECT

// cadena de conexión
string connectString = "database=test_paresco;server=am01;User ID=BACK;pwd=xxxxxx";
// objeto connection
SqlConnection connection = new SqlConnection(connectString);
// abertura
connection.Open();
// objeto Command
SqlCommand command = new SqlCommand("SELECT * FROM usr_contract", connection);
// objeto DataReader
SqlDataReader reader = command.ExecuteReader();
Object[] row = null;
while (reader.Read())
{
    if (row == null)
        row = new Object[reader.FieldCount];
    reader.GetValues(row);
    for (int i=0; i<row.GetLength(0); i++)
    {
        if (row[i] != DBNull.Value) 
            Console.Write(row[i]);
        else
            Console.Write("NULL");
        if (i<row.GetUpperBound(0))
            Console.Write("|");
    }
    Console.WriteLine();
}
// cerramos reader
reader.Close();
// cerramos connection
connection.Close();