How to take value of sql table in c#

Question

I have a table in sql, in the my table there are 3 columns (no of schedule, name of class, penalty cost).. 

So I need to take all values in penalty cost column and compare them to know which one has the smallest cost..

and I need to write it in c#..

thx