That query will only return one record - indeed only one value - even when fixed, because it returns the number of rows that match the condition, not the actual rows themselves.
To make the WHERE work, you need to tell SQL that CPU is a string (assuming it is):
SqlCommand cmd = new SqlCommand("Select count(*) from Equipments where EquipmentType = 'CPU'", Con);
But to return the actual records:
SqlCommand cmd = new SqlCommand("Select * from Equipments where EquipmentType = 'CPU'", Con);