C#: How do I iterate the contents in a DataColumn?

Question

I have a database column I simply need to check to see if a value is there.

        DataTable dt = masterDataSet.Tables["Settings"];
        DataColumn SETTINGS = dt.Columns["DEFAULTSETTINGS"];

I just need to iterate over the values in this column to see if a value exists. Help

Answer 1

You iterate the rows, not the column

DataColumn SETTINGS = dt.Columns["DEFAULTSETTINGS"];
foreach(DataRow row in dt.Select())
{
    object columnValue = row[SETTINGS];
    // Do something with columnValue
}